Try a sub query in your where clause using IN
...dbo_p21_view _inv_loc.locati on_id NOT IN (10,11821)...
PeterDavis
Last Activity: Oct 20 '06, 02:18 PM
Joined: Oct 6 '06
Location:
-
In the OnOpen Event of the report, use conditional code to change the recordSource of the report to alternative queries determined by your form...Leave a comment:
-
You could have a lookup table containing 1) a formId, 2)the form name and 3) a boolean flag for 'locked"
When someone opens a form, the flag is updated to true (locked) and when closed, it is updated to false (available).
So, before opening, your command button would have to check the value of that flag (eg using DLookup)...Leave a comment:
-
There is an in built function for this in Access "currentUse r()"
eg:
MsgBox("The current user is: " & CurrentUser)...Leave a comment:
-
Unless you have an enormous database by Access standards, this is probably a red herring.
It is much more likely that there is a compile error somewhere in your code or a query. Also check for corrupt tables and rebuild indices...Leave a comment:
-
It is the back end mdb file which corrupts on the server. The front end mdb files are on the local workstation. The odd thing is that this configuration worked fine with Access 97. It was only when the backend was upgraded to 2000 that the problems started.
{Users can only exit by means of a command button but im any case, this is not when corruption occurs}....Leave a comment:
-
Database Corruption
Using Access 2002 on Windows xp
I have recently upgraded a database from Access 97 to Access 2002
I first upgraded the front-end databases, and everthing was fine. The back end would not convert so I imported all objects into a new Access 2002 shell.
Now it seems prone to corruption.
Any ideas what is causing it?
Thank you -
OpenCurrentDatabase causes immediate on-line crash
Using Access 2002 on Windows xp
I use the OpenCurrentData base method to open another database file.
The method works well on some workstations but on others, Access crashes immediately and the Microsoft on line reporting tool pops up.
I cannot see any missing references on these work-stations and due to the crash, I cannot trap an error.
Any ideas what might be causing it please?
...
No activity results to display
Leave a comment: