Search results

I am working on a database that has about 15 users. Someone else added to it so that it will automatically detect the user ID so they don't have to select their name. Their name displays on the top of the main form where there are additional buttons to open other forms. The code is working...

Thank you both for taking the time to answer. It appears I have figured out my problem! I believe my original manual fix did work, but there was another reason it wouldn't let me set up referential integrity. For my original backend, I made another copy to function as an archive for old records...

Thank you so much! I will make backup copies and try that tonight after every one is out, so all of today is in there.

Yes, I do still have the old backend data with the autonumbers preserved. It has records through the end of 11/14. The new backend started being used on 11/15 to the present. I compared the autonumbers from 11/14 to the autonumbers on 11/15 and there are 831 records with the same autonumber...

Yes, I realized how stupid that was the next morning. I will not make that mistake again! People were entering data in the old one up through 11/14. The new one only had data copied over up to 11/13, and then on 11/15 they started using it. So everything from 11/14 that needs to go over to...

Hello, thank you for the responses! I am self taught with Access so I struggle sometimes with figuring out some of these things. I have the old backend dated 6.6.17. It contains data from 10/2/17 to 11/14/17. I imported that table into the new back end on 11/13/17. The new backend contains...

I have a split database with a main table and 2 junction tables that should be related. I was having trouble with blanks in my table so I decided to make a new backend and remove the auto name correct and clean up a few things. The main table has over 30,000 records in it so far, and I was...

Thank you so much!! That worked! :)

Thank you for that. I am still not really sure which one to use because in the example, it sounds like subform 2 is on subform 1, and both of mine are on the main form. I tried a few of them, but I am not great with references. I need to work on that. The reason I used a subreport was...

Hi all, I'm new here so I hope I don't do this wrong. I am self taught with Access and VBA and have been learning through trial and error and Google. I have created a database for work. It is split and there are 4 different front ends, each used by different people depending on their job. Some...