Greetings,
I am building an unbound form that will be used to collect data that will be appended to a table whose primary key is not an autonumber yet is incremented by one with each new record.
How can I determine the next valid Primary Key from VBA just prior to running an append query, or...
One way I have approached this is to create an action query (append query) that picks up the value in the unbound text box and appends it into the table.
In your case the query would be like this:
INSERT INTO tblHyp ( fldTime )
SELECT [Forms]![frmHyp]![txtTime] AS Expr1;
You create this query...
Okay, to find pretty good explanations:
1. go to www.microsoft.com
2. on left side of page under "Resources" select "Support"
3. in the "Search" dropdown, select your version of Access
4. in the input box directly beneath, type "database corruption" and...
I have faced this problem many times in the last 4 months. Microsoft has an excellent explanation for reasons why this occurs, what is actually occurring, and remedies. I'll try to find the article that helped me and get back with you.
I faced a similar problem with a networked Access database with 25 users. We found a very simple solution:
1) Split the database into a Front-end and a Back-end using the Access database splitter. Place both the Front-end and the Back-end on the server.
2) Create a folder on each user's C...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.