Search results

I have a reference in a form that is starting to drive me crazy. Usually I can resolve this, but maybe its from having a long week and not thinking clearly. Anyway, in the query I have the following tables: tblResponses -AssociateRef -QstnID -Chosen Value -ResponseDate tblResponsesList...

I have a listbox that has the following SQL in a query: SELECT tblResponsesList.Rspns, tblResponsesList.QstnID FROM tblResponsesList WHERE (((tblResponsesList.QstnID)=[Form]![QstnID])); I want to have it if I return back to the record at some point, the listbox will show all the options and...

I have a database that I have 2 tables using a One-Many relationship. I have these in a form and subform, linked by the Primary Key. What I need to be able to do is on the first of every month is to automatically create a record for the 1st day of the previous month for each of the related...

I have designed a few databases for my work. I have been recently assigned a new one that has me a little stumped. I am looking for some suggestions as to how to go about this. Essentially, we have a training department that does training in the various aspects of the job. In the various...

Solution The issue ended up being caused by a setting on one of our Novell Netware servers. Novell has a feature called OPLOCKS (Opportunistic Locking) which conflicts with certain programs, Microsoft Access databases being one of them. Before the IT department began looking into the issue, I...

I was actually working with another person overnight on another MS Access Support site. We had already established that I had imported all objects into a new Access Database and recompiled. No change. We check security settings, and all is well. I was then searching via Google, and it appears...

I am receiving the message "The table 'MSysAccessStorage' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically." I searched the Knowledgebase yesterday, and thought that perhaps this was related to Database...

I have a database that has some tables joined via relationships. The main table is a customer table, for gathering the first name, last name, address, etc. Then there are others are linked to it. I have worked up a DLookup command On Error GoTo ErrorHandler Dim varFound As Variant varFound =...