Recent content by rosajen

This is a pretty good explaination of foreign keys and its better than I can explain myself http://msofficeuser.com/pages/access/creating-primary-keys-and-foreign-keys-in-microsoft-access

I figured out the issue. I had to set the OBCD table to my machine data source and not my file data source. thanks for your help though!!

I also cross posted this on utteraccess it under the title Odbc Database Linked Table Cannot Update sorry I can't post the link

Hi! Thanks for posting. I checked on both the primary key and the table/view part. It is actually a table and the primary key already had the increment set to one and had identity set to yes. Thank you for responding I really appreciate it

Hi, So from what I can tell in the database your trying to show all the information from those four tables in your one query right? Even though all the primary keys are linked to their counter parts in the tbgroup the other three tables aren't related to each other. You need foreign keys in...

Hi everyone, I have an access database that basically checks supplies in use and checks them out after they have expired. I have a table called All Supplies that holds the item's name, the date it started being used, its expiration date, and the date it actually stopped being used and how many...

Never mind just had to switch the form's default view property to continuous

Hi, I have a table called Properties that I need to be able to update through a form and add new records to through a form. My issue is that I have to sort through the records based on an identifier called Area and each Area has multiple instruments. I want to be able to display all of the...

Thanks for replying I have tried a filter before but it doesn't change the result unfortunately. As for the pdf printer this database can be accessed by over 300 computers so its not practical for me to make sure everyone has the pdf printer as default. I think I will try the report thanks...

Hi I'm using access 2007 and I have over 20 forms that are bound to their respective tables. When a save button I made is pressed I want the record to save in the table and the current individual record to save as a pdf in form view. Right now it saves as a record in the table but the pdf...