My code seems to ignore the WHERE condition when it initially opens the form but if I run it a second time with the form already open the filter is applied. Just seeking advice on what property on the form could be blocking this from working properly because in a simplified database I tested...
I was adding an autonumber field to an existing table and I assumed the numbering would follow the order of the primary key but that doesn't seem to be the case. I was curious if anyone could shed some light on this.
I have a form where I originally was going to have a table view subform but the users requested that it be a popup window so it could show more information and could be dragged to another monitor and viewed at the same time as a data entry form. I had the two forms up and running with the...
Within the database I've been building I have a form that has ~30 fields. I have a fear that users will be very unhappy with me when the data they've entered gets lost. Perhaps I have built the database improperly (this is my first attempt) but it seems strange to me that a record isn't saved...
I've been in the process of building my first Access database over the past few weeks. It has been pretty enjoyable so far but I just came across something that worries me.
When I go to make a report or form and click 'add existing fields' my main table shows as ~TMPCLP followed by various...
I'm very new to all of this so apologies for my inexperience. I have been slowly working on a new database in Access for work and have run into another road block.
I have never tried passing variables while calling a function so I don't know what the heck I'm doing. I'll give a simplified...