We are using Access 2002 and Windows XP
I have a table in a back-end database that is being updated by a form in a front-end (.mde) database.
The "Intial Entry" form has four fields - Originator, Type of Request, Department, Comments
Six of the fields in the linked table should be populated when the Initial Entry is submitted
Date: defaulting to Date(), the four fields they entered into the form, and Status: defaulting to "OPEN"
This works for most users/computers
There are two specific computers that accept the entry, but do not populate the Date field or the Status field with the default values.
Sometimes, the two users in question get an error message when they input the Type of Request, but I don't understand that either because it's just a lookup combobox (source: type id and type). They close the error and it lets them input the type the second time they choose it, then they can finish and submit the entry.
The Windows date on the computers is set. There are no subforms or complicated structures. The *,mde files were put on their computer at the same time as everyone else's....
I'm at a loss as to what to even check
Does anyone have any ideas?
Thanks
Christine
Table Default not populating
-
- 4StarLounger
- Posts: 482
- Joined: 24 Jan 2010, 15:02
- Location: Colorado, USA
Re: Table Default not populating
Several possibilities to look at:
- is your database split with the frontend .mde with forms, reports, queries and such on the workstations?
- how are you setting the default value - at the table level, or on the form?
- if the database is indeed split, is it an access back-end, or is it SQL Server, or Oracle or????
- if it is an access backend, do those users have full file permissions on the file and on the folder that contains the backend?
With answers to those questions, we may be able to suggest some other things to check.
- is your database split with the frontend .mde with forms, reports, queries and such on the workstations?
- how are you setting the default value - at the table level, or on the form?
- if the database is indeed split, is it an access back-end, or is it SQL Server, or Oracle or????
- if it is an access backend, do those users have full file permissions on the file and on the folder that contains the backend?
With answers to those questions, we may be able to suggest some other things to check.
Wendell
You can't see the view if you don't climb the mountain!
You can't see the view if you don't climb the mountain!
-
- 3StarLounger
- Posts: 390
- Joined: 26 Jan 2010, 16:02
- Location: Las Vegas, NV
Re: Table Default not populating
It would be helpful to know the details of the error message these two users get. That could be a big clue.Sometimes, the two users in question get an error message when they input the Type of Request
Carol W.