Search results
-
P
"Record is deleted" and "Could not update, currently locked"
Hi I have a problem with multiple user access. I am simply adding a few measures to an existing database used my people in another office. The problem is that when I test it with a colleague in my office when we scroll through records/add dummy data she gets the above error messages. I... -
P
password bypass
Hi I have an issue where I have enabled the access security using the wizard which is fine as users use a shortcut which takes them through the password macro. But then if they quit > open access they can select the database through the 4 most recently opened which bypasses the password. Any... -
P
multiple reports from one button
Hi I have looked through past posts but can't quite match what I am looking for. I have a set of existing reports (4 in total) that asks for the same criteria (a specific date) in each report. Currently I have a form with one button per report. Is it possible to have one button that will... -
P
Entering 2 text values in the criteria field
Hi I am trying to write a query where it requests two values from a Month field. So for instance [Enter month 1] (i.e. January) and [Enter month 2] (i.e. July), and then to list the data (member, claim date, etc) in one line for both the two month values (so you wouldn't have January on one... -
P
Creating an Expression which return text from a check box result
Hi I have built a query which simply displays a few checks boxes based on a specific date criteria search. Because the associated report will not export the check boxes into Word I was thinking if I could have another field in the query which will return a text value based on a check box... -
P
Two forms writing to one record????
Hi I have a problem where I have one table that is split into two forms (one main and one as a pop up). I am also using autonumber ID (as the primary key). Basically the problem I have is that I can fill out data in the main form which on selecting a response will trigger the pop up form with... -
P
Updating an event procedure when switching between records
Hi I am a novice to access but have written a case statement which grays out other check boxes when a value is selected from a drop down list. Thats fine but then when you switch back to old records with the value typed in I needs the case statement to apply to these as well. Private Sub...