Over 1 million tech questions and answers.

Using Access 2016 on a Win10 PC. Have a 2 table db w/problem

Q: Using Access 2016 on a Win10 PC. Have a 2 table db w/problem

I have previously built 3 or 4 much larger databases with up to 10-12 tables with with look-up tables with no problem. I am now creating a new DB connecting a look-up table to the main table with a 1-to-many join. I used the same join in another DB that works fine but with the new one, the lookup value is not being saved to the main table. After reviewing the tables and the relationship diagram and comparing them to an older working DB, the only difference I can see is that in the older DB, the main table and the look-up table are joined from field TypeCode to TypeCode in a 1-to-many. In the new DB, the Cat Type table is the 1 (field CCode) to the SLIDES table (field CatCode.Value) as the many connection. The SLIDES table has a field of CatCode which is comparable to the CCode field in the look-up table. Even when I edit the relationship to join to the CatCode field, it is not saved and changed from the CatCode.Value link. The CatCode.value field does NOT exist in the SLIDES table so I have no idea where it came from and why it is capturing the standard 1-to-many link. Here is a simple diagram of the two tables and the important fields as shown in the Relationship diagram. There are 5 more fields in the Main table "SLIDES".

SLIDES Cat Type

---------------- -------------------------

Slides CCode

CatCode CatDesc

CatCode.Value

Yes, the CatCode.Value is indented in the actual diagram and it is connected to Cat Type(CCode). Why and why is it there in the first place ?? I don't know.... What I think needs to be connected is the CatCode field to the CCode field. But that raises the question of whether both fields need to have the exact same fieldname?

In the relationship window, I've checked Enforce Referential Integrity and in the Join properties window I have selected the type 1 Join, as I had in the previous projects.

(I try to attach a file with images of an older and the new DB relationship diagrams and the two windows for each if someone can tell me the best format in which to send or attach them.)

Any thoughts?

RELEVANCY SCORE 200
Preferred Solution: Using Access 2016 on a Win10 PC. Have a 2 table db w/problem

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Using Access 2016 on a Win10 PC. Have a 2 table db w/problem

fred615 said:





I have previously built 3 or 4 much larger databases with up to 10-12 tables with with look-up tables with no problem. I am now creating a new DB connecting a look-up table to the main table with a 1-to-many join. I used the same join in another DB that works fine but with the new one, the lookup value is not being saved to the main table. After reviewing the tables and the relationship diagram and comparing them to an older working DB, the only difference I can see is that in the older DB, the main table and the look-up table are joined from field TypeCode to TypeCode in a 1-to-many. In the new DB, the Cat Type table is the 1 (field CCode) to the SLIDES table (field CatCode.Value) as the many connection. The SLIDES table has a field of CatCode which is comparable to the CCode field in the look-up table. Even when I edit the relationship to join to the CatCode field, it is not saved and changed from the CatCode.Value link. The CatCode.value field does NOT exist in the SLIDES table so I have no idea where it came from and why it is capturing the standard 1-to-many link. Here is a simple diagram of the two tables and the important fields as shown in the Relationship diagram. There are 5 more fields in the Main table "SLIDES".

SLIDES Cat Type

---------------- -------------------------

Slides CCode

CatCode CatDesc

CatCode.Value

Yes, the CatCode.Value is indented in the actual diagram and it is connected to Cat Type(CCode). Why and why is it there in the first place ?? I don't know.... What I think needs to be connected is the CatCode field to the CCode field. But that raises the question of whether both fields need to have the exact same fieldname?

In the relationship window, I've checked Enforce Referential Integrity and in the Join properties window I have selected the type 1 Join, as I had in the previous projects.

(I try to attach a file with images of an older and the new DB relationship diagrams and the two windows for each if someone can tell me the best format in which to send or attach them.)

Any thoughts?Click to expand...

I added one more file.....

Read other 2 answers
RELEVANCY SCORE 58

I have a Make Table query that when I run it and view the table in the query it shows only the data I want. But when I go and open the table that theis query made, there are entries that should not be there.

It is putting in rows with blank fields, I am not sure how to stop it. I have tired to put something in the query for that field but I get back the error "Invalid Use of Null"

If I could put in the criteria that worked I would be all set.

Any ideas?
 

A:Solved: Access (Make Table) Query Results Returned not Same as Table

Read other 6 answers
RELEVANCY SCORE 57.6

hi,

Just wondering if anyone could tell me if and how i can revert back to an older version of a table.

I had a table saved contain product details
whilst i was away a work mate accessed the table deleted some colums and saved over the table.
i was just wondering if the was anyway to undo this save, or if a back of the previous table could be found somewhere.

using Access 2000 on Win XP (no restore point available).

thx in adv.
Dam
 

A:Access 2000 table backups? / undo a save to a table

No.
Not unless it's on a drive where you have been backing up the entire database or have specifically set up for the database to backup the data...
 

Read other 1 answers
RELEVANCY SCORE 57.6

Hi guys

I am trying to create a pivot table in Excel 2016 (and I'm by no means a wiz...) so I normally use recommended tab Pivot tables.
The problem I have is that the data that I need in my pivot table is text as well as numbers (because some SKU's start with a 0)
I think this is why it won't show in the recommended pivot tables

I may be on the wrong path here, but all I try to do is to see how many of every SKU have been sold

Can anyone point me in the right direction please?

Thanks for reading!
 

Read other answers
RELEVANCY SCORE 57.6

Hi all,
I have a 3 column table in a word document each column is labeled 0-h, i-q, r-z this is reference page at the start of the document. as i add to the document i have been adding headers with hyperlink to the top of the document and then hyperlink from the table to the section of the document.
The question is how do I sort each column individually? (see attached PDF)

Thanks
 

Read other answers
RELEVANCY SCORE 57.2

I am starting this Access database from scratch. I have to import/upload a sales file weekly. I will be adding this file to a main sales data table. The issue I have is that this file does not have any dates on it. I need to be able to add a start and end date to the table.

Example fields that I would need/have

Need:
start date
end date

Have:
Item #
Store #
Sales Units
Sales Dollars

What is the best way to handle this? I have an idea - just not sure what order I should put my steps for importing the file, asking for the date range, adding the date to the table, etc....
 

A:Solved: Access - import table - add date to table

Read other 9 answers
RELEVANCY SCORE 57.2

I'm trying to run a clear table query (to keep the table, but delete the data), and then an append query to repopulate the table, and it's not working.

...any idea what I'm doing wrong?
 

A:ACCESS clear table/append table not working?

Read other 11 answers
RELEVANCY SCORE 57.2

I am having trouble updating data from one table to another. I am not Appending the data.

I've linked the two tables on an ID field.
I created a select query to see the data I would update.
I changed the query to an Update query.
In the Update To field I placed the following: [table].[field name]

After running the query I noticed the update did not work. The data from the first Table did not get updated to the second Table it wound up being deleted from the first Table.

Your help is appreciated.

Buttercup
 

A:Solved: Access 2003 Update Table from another Table

Buttercup1, welcome to the Forum.
I am not sure why you wan to update the second table with data from the first table.
Can you show me a screenshot of your query with the table(s) in and also your Table relationships?
 

Read other 3 answers
RELEVANCY SCORE 57.2

Hey there folks...
I am in need of some assistance. Obviously!

I need a form which allows a user to select a record from one table and completely move the record to a totally separate table in the same database. I need it to transfer all the data for the selected record.

AutoNumber will not be an issue as each record has unique identifiers.

I found this article online but it seems it will append ALL data and doesn't allow a user to select the correct record. This uses an Append Query which makes sense but again it seems as though it will transfer ALL records. All I need is for it to transfer a specific record depending on the user's selection in the form.
 

A:MS Access 2007: Moving a record from one table to another table...

Is this to "Archive" the record?
It is not normally necessary to actually "Move" a record, as you can just have a tick box called archive or similar that can be used to exclude that record from normal display and to display it as an Archived record.
There are 2 ways to do what you want, if it is really necessary, one is using an Append query, you can Identify the currently selected record on the Form using
forms![Form Name]![name of Key Field]
in the First Criteria row of your Key field, where Form name is the actual name of your form and name of Key Field is the actual name of your Key Field.
The other version is to use a VBA recordset Clone to do the same thing.
The
 

Read other 1 answers
RELEVANCY SCORE 57.2

http://www.mediafire.com/?8bbfjsbun24m74z

In this database, i have a data entry form called "Information Requested" and all information in this form when entered are added into table Information Requested. In the form, 3 fields Names, Business Units and Emails are drop down lists based on table Contact List. However, what the form does now is i have to pick the name, business unit and email manually. It's not really efficient this way. what i want is when i pick the name, the corresponding business unit and email of that person will automatically show up in the box. How can I achieve this?
 

A:[Access 2010] How to append record from one table to another table.

The data should NOT be transferred to the table, only displayed on the Form, as it should only be entered once.
You can display it on the form by including the data in the Combo as a "Concatenated" field or you can transfer the data to "Unbound" fields.
 

Read other 1 answers
RELEVANCY SCORE 57.2

Hi All. I've tried all of the border/shading tweaks, table tweaks, playing with some advanced options, etc., but the dreaded dotted border persists. Easiest thing to do is show you an image of what I mean. This is a resume, and I don't want anyone opening up to find the ugly dotted border around the header information. Please see attached.

Note that it does print without a border, and I convert it to a PDF without the border appearing??

I appreciate any help. Again this is Microsoft Word 2016 on Windows 10 64-bit.

ARNK

Read other answers
RELEVANCY SCORE 56.4

I have a problem I made a database that has all my movie collection from different formats (DVD, Blu-Ray, HD DVD, etc...) but in my Movies Form under the text box format it shows the ID but not the actual format but on all others like TV Shows it shows the format? How can i fix that?
 

A:Form/Table Problem in MS Access 2010?

Read other 16 answers
RELEVANCY SCORE 56.4

hello
i am having a problem in Access 2002, it is probably quite simple, as i am very new to working with it.
the problem i am having is that i need to use a query to calculate a total, using 2 columns already in the table to fill a blank column in the same table.
i have tried using append and update but keep getting validation errors
in short i am trying to multiply column A times column B to fill column C.
i tried using a make table query to do this , but that makes another table, although it does do the calculation, but i need to keep the original table intact. i hope i have provided enough information to get some help, because i am running out of hair to pull out.

Thanx
MacataQ
 

A:query/table problem access 2002

Read other 7 answers
RELEVANCY SCORE 56.4

Hi, my table consists of

TrackName - Autonumber - Primary Key
ArtistID - Number
FilePath - Text
GenreID - Number

For some strange reason when i open the table it shows all the records in ascending order of "ArtistID" when it should be track name which is the autonumber field.

Can anyone help?

Thank you.
 

A:Solved: Weird problem with Access table

The only way to get data out of a table in a specific order is to run a Select query with an Order By.
There is no guaranteed order of the data out by opening the table directly.
 

Read other 3 answers
RELEVANCY SCORE 56.4

This should be easy, but I'm baffled. If I create a table in a word doc, then go to delete a column, the column on the far right will lose its right border. Huh???

What am I doing wrong? Never seen this before....Oh, and it also happens in Google Docs....
 

A:MS Office 2016: In Word, deleting column in table

Please check if the border exists when you zoom in. Vertical and horizontal lines seem to have a hard time when you are zoomed out.

Please see the gif below:

https://i.gyazo.com/43905bd1ec00c61d2ce92f9f27e3271b.gif
 

Read other 1 answers
RELEVANCY SCORE 56

Hi There

To make a long story short say I have a table called Table1 with only 3 currency fields called Deposit1, Deposit2, Deposit3 and TotalDeposit. I then create an input form based on Table1. On the form, In design view, I use all 4 fields. On the TotalDeposit field on the form, I do a calculated field as follows:

[Deposit1]+[Deposit2]+Deposit3]

I then populate the 3 fields with currency - $100, $200 and $300

On the form the calculated field shows a total of $600. However, when I go back to the table, the TotalDeposit field has a zero? How come? How do I get the calculated field on the form to appear on the table??

Mario
 

A:Access problem in calculated field on form to appear in Table

Hi Mario

How exactly have you set your TotalDeposit field to be populated with the sum of the other three fields? That is - where have you typed [Deposit1]+[Deposit2]+[Deposit3]?

Deej
 

Read other 2 answers
RELEVANCY SCORE 56

I've been working on a database to save subscriber & ticket information for my community non-profit theater group. After lots of trial and a ton or error, I like what I have, but determined that I need to change the way I store some of my data. This required the addition of a text field which has a list of 3 lookup values. I added this to the table in design view--no problem.

The problem is in the forms I've already generated. I went to design view for my form and put in a combo box for this new field. The wizard asks me what I want to do with the values: remember them for later or enter them into a field. I would like them entered into my new field. That's what this combo box is for. However, to enter them into a field, the wizard lets me select only from a drop down list of the fields available in that table, and it doesn't include my newly added field. I imagine that this is because the form itself was created before I added this field. I could recreate the whole form, but I spent a long time designing it, and all I want is to add the one new field. If push comes to shove, I'll start from scratch and do the whole form over again, but I can't believe there is not a way to do this.

If it's of any consequence, this form is actually a subform, but I'm attempting all the modifications to the subform on it's own, so I don't imagine that's got anything to do with this prpoblem.

If someone could please educate me I'... Read more

A:Solved: Access--new field in table & problem with form

Read other 8 answers
RELEVANCY SCORE 56

Hi Everyone
I'm needing to automate a process that notifies a group of users to complete specific data on a shared Excel template file. The process is date driven. For example; row 1 has data due on 4/25/2017 by Bob Smith, while row 2 has similar data due on 4/29/2017 by Rose Hill, etc. We are in a Windows 7 environment, Outlook 365 mail clients and recently updated to Office 2016 from 2010.
Anyone have any ideas on how to best approach a solution for via Excel macros?
 

Read other answers
RELEVANCY SCORE 55.6

I copied all of my themes over from my Win7 machine, but regardless of whether I try to tweak old themes or create new ones, the "Sounds" are NOT customizable. You get a choice of "Windows default" or "No sounds"... When is this going to be fixed in Win10? (This is true as of Jul 23, 2016)...

A:Sounds still cannot be customized in Win10 (2016, July)

Originally Posted by ColoMtnWoman


I copied all of my themes over from my Win7 machine, but regardless of whether I try to tweak old themes or create new ones, the "Sounds" are NOT customizable. You get a choice of "Windows default" or "No sounds"... When is this going to be fixed in Win10? (This is true as of Jul 23, 2016)...



The Win7 sounds might not carry over, but when I create a theme, with custom sounds, and .wav files and post it here: Solved Windows 10 Themes created by Ten Forums members - Windows 10 Forums
They do carry over.

Note: except for the very first few(which were created on Windows 8.1) all themes were created using Windows 10.

You could try getting ahold of the Win7 sounds files and folders, and pasting them in C:\Windows\Media. That's how I add custom .wav files, then just use Control Panel\Sounds and create my sound theme, mixing & matching.

Read other 0 answers
RELEVANCY SCORE 54.8

I recently upgraded to Outlook 2016, and for some reason, some of my e-newsletters have sections blocked (i.e., those sections don't download so a small X appears in the upper-left corner of that section). It doesn't happen with ALL my e-news, only some. I thought it might be a security setting but can't find anything. I have constant malware protection and did full scans several times over the past 10 days.

Any ideas what this could be and what I can do to fix it? Thanks, I'd really appreciate the help.

My computer:
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: Intel(R) Core(TM) i7-5500U CPU @ 2.40GHz, Intel64 Family 6 Model 61 Stepping 4
Processor Count: 4
RAM: 8094 Mb
Graphics Card: Intel(R) HD Graphics 5500, 1024 Mb
Hard Drives: C: Total - 932249 MB, Free - 656389 MB;
Motherboard: ASUSTeK COMPUTER INC., Q551LNB
Antivirus: Kaspersky Internet Security, Updated and Enabled
 

Read other answers
RELEVANCY SCORE 54.8

I have a form (parent form) that has more than 1 pages and on 1 page I put a sub-form with text boxes and combo boxes linked to a table say Table 2.
In this Table 2 it contains historical data of a particular field, say previous employers and the current employer and the data on each employer of a person, so there's a field: a flag to mark that a record is the current one and the other records of the same person are not flagged.

On the parent form, there's a list box displaying content of say Table 1, say list of people.
Whenever a row is selected in this list box, the text boxes and combo boxes on the sub-form should display this person's current data (a record with the current flag checked).
So I linked the list box to the sub-form by the person ID in both tables, by populating the child and parent fields on the forms.

What I'm confused about is the first text boxes display the current dummy data, but then the combo boxes are empty.
It's dummy data cos for now in Table 2, there's only 1 record for a person.
I haven't put the criteria to display data that has the current flag checked, cos there's only 1 record per person now.

I linked each combo box to the relevant field of Table 2 on the "control source".
There's nothing in the "row source" of the combo box, even though later on there should be.

Any idea what went wrong?

Thanks in advance.
 

A:Problem displaying value of a table field in a combo box in a subform in Access 2003

Read other 9 answers
RELEVANCY SCORE 53.2

I'm going to buy a new license of one of these product, so any suggest please?
I have used Bitdefender, Avast, Kaspersky ( about 3 years ago), I haven't used Norton and Trend Micro.
 

A:KIS 2016 vs NIS 2016 vs BIS 2016 vs Avast IS 2016 vs Trend Micro IS 2016

Out of all these,and your prerequisites,I would go with Kaspersky!
PS:This is from personal experience,and other members may have varying opinions!!
 

Read other 3 answers
RELEVANCY SCORE 50.8

MS Access:
I have several fields in a form that uses two tables. I would like to set up a command button so that when you are on a current record, it will copy the field information from the record you are on to other fields in the same record. I do not know the SQL commands to set this up.

For example, there are name fields, address fields, and phone to be copied. Reason: One is contact information; one is survey information. In most cases the information is the same but on rare instances, the information needs to be entered (when different).
This is not an update for all records in the database. This is based individually on each record.
Not sure if you need to do On current, on click, or after update.
Not sure if default value in form can be used.
Please help.
 

A:Copy data fields in same table to other fields in same table MS Access

Read other 16 answers
RELEVANCY SCORE 50.8

Now! ESET has just released their newest security suite: ESET Smart Security 9 (2016 Edition). These products are on the top of security suites which are produced by giants on security companies. Most of them released 2016 editions of their products. I want to compare on their newest products with new features (such as on ESET: Banking Protection, Bitdefender: Ransomware Protection and new Firewall, etc...) and some enhanced features.

And now, which is your choose for your security? Please let me know your opinion!
 

A:Battle: Kaspersky IS 2016 vs ESET Smart Security 2016 vs Bitdefender IS 2016 vs Emsisoft IS 10

its hard choice choose between Eset,Kaspersky and Emsisoft.
in fact i never test Eset 2016, but i tested kaspersky and Emsisoft, Kaspersky 2016 really go lighter than Emsisoft(now i am Emsisoft useres)
by your budget and your interest u can choose Emsisoft or kaspersky.
 

Read other 46 answers
RELEVANCY SCORE 50.4

Hi

I need to add rows from Access table to Excel spreadsheet by using VBA.

I cannot create a new file for various reasons, so I cannot use command “TransferSpreadsheet”.

Is it possible to do it?

Thanks
 

A:Solved: Access 2003. How to add rows from Access table to Excel spreadsheet by using

Read other 16 answers
RELEVANCY SCORE 50.4

Hi

We have an Access application that holds employees' table. When new employee comes, the email stating the name of a new employee and the link to this Access app. being sent to a supervisor. When supervisor starts the app, it opens the list of all new employees for a supervisor to choose from.
What my boss wants is, that access will open a new employee record by itself, depending on the name from the email. In other words, he wants to open the specific record by the link from email.

Is it possible to do this?

Thanks,
Barbos
 

A:Solved: Access 2003 - Opening specific record in Access table via link in Outlook

Read other 16 answers
RELEVANCY SCORE 50

Looking for the best approach to updating/altering an Access table via DSN-less connection string.

Situation: This process will be run nightly via MS Schedule tool

Database
1 - contains 1 table which acts as a linked central datasource for
numerous databases - this cannot be change. - in some instances this
maybe left active which affects the altering of the table. Alter is
need to change 3 fields's data types or convert prior to update.

Database
2 - contains the temporary table and the code or possibly just the code
to update the data in the linked table source.

Note this code
cannot be kept in DATABASE1 - due to the fact that this database is
occasionally opened and used by other users, so I cannot have the
Autoexec fired when the user access the database - hence the need for
Database2.

Now the Oracle data source contains numerous fields
that need to be converted in 1 way or another, including converting a
date that in contains a text (varchar) datatype ie. 090822, when I
attempt to covert this and place in an Access Date/Time field - I am
getting an error.

My thought is to create the temp table then
export into Database 1 - which will replace the existing with the new
data - or possibly have the Database2-tbl linked in Database1 and do a
delete and append queries - however, then I run into the conversion
issue.

Any and all suggestions is greatly appreciated.

Note
the date field = SERVICE_DUE_DATE_CMT, LAST_SERVICE_DATE, PURCHASE_DATE
that needs the conversio... Read more

Read other answers
RELEVANCY SCORE 48.8

Hi everyone,

I am struggling with some VBA.

I am trying to import a csv file into ms access table. The code i have is

DoCmd.TransferText acImportDelim, "ProScriptImport", "Combined", "G:\Ship_Export.csv",True

This works ok if the file is called "Ship_Export" but the file also as a time stamp on the end e.g "Ship_Export_20072017.csv" Can sombody help me with the vba to pick up the date stamp on the file?

Thanks.
 

Read other answers
RELEVANCY SCORE 48

I bought Office 2016 months ago, but due to windows update failure I had to reinstall win10 thereby losing Office 2016.
Can someone point me to a contact? I bought Office 2010 online from MS. TIA

A:how to reinstall Office 2016 after win10 reinstall?

If you bought online there should be a record of this and you will be able to download Office again. Try this link http://www.office.com/myaccount

Read other 0 answers
RELEVANCY SCORE 47.2

I have 6 months trial license all of them. Which one do you recommend?

Thank you in advance.

Best regards.

Heyye.
 

A:Avast IS 2016 / Panda IS 2016 / Bitdefender IS 2016

What kind of system do you have?
Panda and Avast are the lightest while Bitdefender can be heavy.

All 3 offer excellent protection (Avast requires tweaking; Bitdefender and Panda works out of the box), while Bitdefender is mainly known for its detection rate (signatures).

Try the 3 of them (trial versions, not the 6 months) and see which one you prefer.

In terms of UI, all 3 are user friendly.

Have a look here for Avast and Bitdefender info:
KIS 2016 vs NIS 2016 vs BIS 2016 vs Avast IS 2016 vs Trend Micro IS 2016
 

Read other 4 answers
RELEVANCY SCORE 46.8

Hi, I am designing my first people networking database. I could really use some help! I need to make a table with information in the fields that "repeats". One example would be interests, where you would have more than one person who enjoys "hunting" or "fishing", then this information would repeat. Another example would be x-mas cards. The table would list people who had " sent" a card or who you had "received" a card from. I am still looking for another table with data that would repeat and theat would be useful in a "people networking database". I would greatly appreciate any help or suggestions. Thank you again for your time and consideration.
ahouse
 

A:access table help

hi ashtech, welcome to the forum. "Repeating" data, as you call it, is usually stored in a lookup table. This is a table which just contains the various values that might repeat, obviously regrouping only things that go together. So you might have a table called lktblThingsILike, and it might contain two fields: ThingID and ThingNm. ThingID is a number you give the thing (duh) and ThingNm is what it is: Hunting, Fishing, Poker, Swimwear, etc. One record per thing, obviously. Then, in your "people" table, you create a ThingID field. Or, if people have more than one kind of thing they like (and many do ), you might need to build a second table in a one-to-many join, but that's perhaps going a bit fast. I'd take a look at the MS articles available here to get you started...
 

Read other 1 answers
RELEVANCY SCORE 46.8

I have a table in Access and I key in data using Forms.
There are some filed in Table which need to be automaticly get data from othere table based on the value I key In.

Can any one help me in this
 

A:Need Access Table Help

hsnayak, welcome to the Forum.
I can help you with this problem, but we need more information about your Table Structure.
A Printscreen of your Table Relationships would be useful, but a zipped copy of the database in Access 2000-2003 format would be best.
It should not have any personal data in it.
 

Read other 1 answers
RELEVANCY SCORE 46.4

Hello guys I'm new to Access but i have mad a DB now i have a date fleid call "DateHandOver" which the user can input the date but i also have a flied called "EndofMission" which i what the DB the take the date from "datehandove" and add 3 years on to that date and then when the date in "endofMission" is = today i ant a popup to come up saying please email the user.

i have got this

DateHandOver (Calculation, Date result) = Date (Month (EndofMission), Day (EndofMission) + 30, Year( EndofMission))

but it now working can anyone tell me why please
 

Read other answers
RELEVANCY SCORE 46.4

I want to import data from ODBC to an existing table, I did not find how to do that. Each time I choose the external data it's create me a new table with an increment like account1, account2

How should I do that?

Thank's in advance
 

Read other answers
RELEVANCY SCORE 46.4

I am working with a access db and i created a form for user to fill out with work that they have done. I want just certain user to be able to view and edit the actual table/date, and the user just to be able to view and fill out the form. How can i give just certain people access to the table and everyone else access to the form.
 

A:lock access table

I would check this site
http://office.microsoft.com/en-us/assistance/HA010546941033.aspx

has good information. I have a couple of application and I set all user to join a workgroup then set permissions. Still this solution has some floss.
 

Read other 1 answers
RELEVANCY SCORE 46.4

Hullo.

Just a quickie - sometimes I enter a series of six figure ID number directly into a filtered table. The numbers are sequential, but the records are not ordered by this field.

So, I'm entering one of these ID numbers and moving up and down to nearby records with the cursor keys to enter the next one.
The problem is, if a couple of records requiring these ID numbers happen to be contigious, and then I move up or down to the next record, Access automatically enters the next sequential ID number.

In other words, after a couple of records, using the arrow keys to move between records (in the same field) auto-fills.
Can I stop this?

Ta.

Gram
 

A:Access autofill in table

Read other 7 answers
RELEVANCY SCORE 46.4

I have a table in Access that contains 2 fields, ID and CODE. I have another spreadsheet that contains ID's for which the user needs to get their code again. Is there anyway that I can create a query that will take the ID's from the Spreadsheet, Look them up in Access, and then assign the correct code back to the spreadsheet?
 

A:How do Get data from One table in Access To another?

Spreadsheet or database table? Are both tables going to be "permanent"? If so, then "copying" this data is not appropriate normalization on the database and you'll just be "bloating" your data.

Your database is not going to be normalized properly if you plan on using two of the same exact fields in two separate tables unless you are using a lookup to obtain them. If you need more info, email me requesting the normalization.doc file.

Meanwhile, if you just need to get it out to a table or spreadsheet, just create a query on that table that grabs those two columns. When you're sure this query contains the exact data you want, open it again in design view and hit Query-Make table query (an "action" query). Now, when you run the query, it will create a new table. You can then go into the design of this NEW table to add other fields as necessary.

Hope this helps.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 1 answers
RELEVANCY SCORE 46.4

I have a table with multiple links to external databases. I need to remove selected links without removing them all. Is there a way to do this without having to start over and relink? Also I don't know VB or code. I've googled everything I can think of and nothing.
 

A:Table Links in Access

tphester, welcome to the Forum.
To remove the links to an external table just click on the table in the current Access database which shows the link and press the delete key. It only deletes the link not the table in the other database.
You can re-establish links using the Files>Get external data, you can refresh links using the Table Links Manager.
 

Read other 1 answers
RELEVANCY SCORE 46.4

Ok, ya'll have always came through for me before, so here we go again.

I have a database of students. There are 4 fields:

FirstName|LastName|ID|Course1:Course2:Course3:Course4:

The field that has the courses listed has each course, one after the other, with a colon separating them.

Let's say we have 200 courses and 100 of them are online and 100 are campus. I know if I set the criteria I can get all the fields to show up for just the 100 online classes. BUT, I want it to only show the online classes in the list of courses. When Access uses the criteria I set it finds all fields with that criteria.... but a criteria that has an online class may have a campus class as well, so how do I manipulate the output?

E-mail me at [email protected] if you think you could be of any assistance. Although, I'll make sure to post any information to the forum.

I'd greatly appreciate it.
Thanks,

Wes
 

A:Access: Table Design

Read other 7 answers
RELEVANCY SCORE 46.4

I have an Excel file that is linked in Access.
Access then has a query built on this linked table.
I have another Excel file (a pivot table) that is linked to the Access query that multiple users can open to view details of the query, with the ability to drill down to the record level.

However, I can not overwrite Excel file 1 if users have Excel file 2 open. Is there security options I can change somewhere to get this to work? I tried to change the permissions to only allow write access to the database for Admin (myself), but it still doesn't work if the Excel file is open as it is locking the table.

I am hoping a complete re-work of this is not needed.

Any help is appreciated.
 

A:Access Linked Table

Read other 16 answers
RELEVANCY SCORE 46.4

Q: I'm trying to loop through an access table and compare fields inorder to make sure that the values are in sequnce order and if not add 1 to previouse field and assign that value to a text box. Below is the code I'm using which recieves this error: Item not found in this collection. (Error 3265)
An attempt to reference a name in a collection failed.
Possible causes: Does anyone know what I'm doing wrong?

Set rstD = CurrentDb.OpenRecordset("SELECT ACCOUNT FROM [20XXXX1]", dbOpenDynaset)
Set rstD2 = CurrentDb.OpenRecordset("SELECT ACCOUNT FROM [20XXXX1]", dbOpenDynaset)

rstD.MoveFirst
rstD2.MoveFirst

For i = 0 To rstD.RecordCount + 1

For j = 0 To rstD.RecordCount + 2

If rstD.Fields(j).Value - rstD.Fields(i).Value > 1 Then
ACCOUNT.Value = Val(rstD.Fields(i).Value) + 1
Exit Sub
End If
rstD.MoveNext
Next j
rstD2.MoveNext
Next i

rstD.Close
rstD2.Close
Set rstD = Nothing
 

Read other answers
RELEVANCY SCORE 46.4

I haven't used ACCESS in a long time and need some help editing a table. Somehow this table was imported into ACCESS from another old database program called Paradox. I am trying to edit the table but keep getting this message:

Updating data in a linked table is not suported by this ISAM.

Can anyone please explain (not a beginner Access user) how to get around this?

Thanks very much! [email protected]
 

A:Editing a Table in MS ACCESS

Read other 8 answers
RELEVANCY SCORE 46.4

I am trying to create a link between two tables on the common fields of "CourseNumber". The tables are "Student Current Courses" & "Available Classes". One to many link would be "Available Classes" (one) and "Student Current Courses" (many). I keep getting an error message when I try to create the link with "reinforce referential integrity" that says "No unique index found for the referenced field of the primary table". I have confirmed that the "Available Classes" "Course Number" field does not have any duplication of data and the "Course Number" fields in both tables have identical properties. What else can I check or do?
 

A:Access '97 Table Links

One of the fields on the primary table needs to be a primary key and linked field in the second table is set to number and linked to the primary table.
 

Read other 2 answers
RELEVANCY SCORE 46.4

Hi there

I'm starting to learn Access. I have created a table and some queries based on my table. One of the colums in the table called "bus" is called "BusAge". I have been calculating the age of the bus in the "BusAge" column on an excel spread sheet. In other words I take today's date and subract it from a previous date and divide by 365 (=(now()-A1)/365). I then manually input these numbers into my Access table in the column called "BusAge". Then I do my queries.

I know that I can import the excel table into my Access data base. I also know that I can create a link to my Excel spread sheet. I want to avoid doing these kinds of steps if possible.

Is there a way that Access can do this for me automatically in the talble using a formula or a macro? I can do the formula in the query but that is of no use to me. I need the formula in the table. Is this possible or not?

Mario
 

A:Access Table formula

Read other 10 answers
RELEVANCY SCORE 46.4

Below are 3 tables that I've created in my database:

"CANDIDATE" TABLE FIELDS
- candidateID (primary key)
- Term
- CandidateName

"VOTE" Table Fields
- Candidate ID {indexed as Yes (duplicates OK)}
- ShareholderID

"SHAREHOLDER" TABLE FIELDS
- ShareholderID (primary key)
- LastName
- FirstName
- Address1
- Address2
- City
- Province
- PostalCode

I'm trying to create a one-to-many relationships between the CANDIDATE table to the VOTE table but it's showing up as one-to-one.

Any suggestions.
 

A:Table Relationships in Access

Fatma:

I'm not sure what purpose the Vote table has unless it has additional fields you're not mentioning. Without that table, the Shareholder table simply links right to the Candidate table.
 

Read other 3 answers
RELEVANCY SCORE 46.4

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Enterprise, 64 bit
Processor: Intel(R) Pentium(R) Dual CPU E2180 @ 2.00GHz, Intel64 Family 6 Model 15 Stepping 13
Processor Count: 2
RAM: 2047 Mb
Graphics Card: LANDesk Remote Control Mirror Driver, 5 Mb
Hard Drives: C: Total - 152524 MB, Free - 103602 MB;
Motherboard: LENOVO, LENOVO
Antivirus: Sophos Anti-Virus, Updated and Enabled

I have a database with 5 tables - Consultant Table, Contract Table, Passage Table, Gwinnett Bucketing Table, and Invoice Table. The Consultant table includes ID# as Primary Key and is related to the Contract table using the ID#. The Contract Table also has a ContractID# (Primary Key). I have set up the other tables using the ContractID# to connect them to the Contract Table. However, I broke the Passage Table off the Contract Table in November because it was very cumbersome and now my queries don't pick up any contract information after the November separation date.

How can I correct this problem? The Passage Table needs to be related to the Contract Table but this seems to have caused the problem. Everything worked until the passage info was separated.

Thank you for your advise.
 

A:Access - Table relationships

dblbl, welcome to the Forum.
I am not sure what you mean by "because it was very cumbersome"?
What was cumbersome about it, you obviously have to relate the table records in some way.
 

Read other 1 answers