Search results

I have 5 tables. Customer info (20 fields), Project specs (10 fields), Tracking (46 fields), scheduling (33 fields) and Notes (12 fields). I could have use a flat table but was trying to group things logically to help me design the front end. I have read a lot about relationships but don’t...

I am using a unique project number for the key. All my tables are linked back to the customer table (My main table) with one to one relationships. I have referential integrity on all relationships and only one person can add new project numbers. All other forms have the project numbers as read...

good to know about the save icon. I have already added the save record button and the close record button to all forms. So it should save when you use the close button? Can you explain "If Me.Dirty Then Me.Dirty = False" to me more?

Some are not saving. It seems to me the records auto save when you switch records or close a form. Some use a save record button I added to the form and some use the save icon in the upper left of access. The user with the most problems stated using the upper left save icon after each record...

I am new to access. I have created a simple split database with 4 tables, 1500 records in each and about 10 forms. It is largely used for tracking the status of projects with in and out dates. There are 15 users with about 5 simultaneous users. The back end sits on the shared drive and I have...