Recent content by Paddy1980
-
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
Ok so this is very hard but if you had to go this route how would you do so? Otherwise I suppose to do it the easier way may be my only option (which I suppose I will have to refer to other posts for help)... -
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
Ok, Firstly - Chill Secondly - I have done the search, couldn't find anything specific (in the topic name) Thirdly - If there is a topic you have in mind then can you not just tell me which one or paste a link so I can look at it? -
P
Entering 2 text values in the criteria field
Can you be a bit more specific please? -
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
Screens: IIf([FGC]=True,"FGC","") & IIf([FPT]=True,"FPT","") & IIf([FPO]=True,"FPO","") & IIf([FCD]=True,"FCD","") & IIf([FSL]=True,"FSL","") & IIf([FDD]=True,"FDD","") & IIf([FRR]=True,"FRR","") & IIf([FAD]=True,"FAD","") & IIf([FCC]=True,"FCC","") & IIf([FAT]=True,"FAT","") &... -
P
Creating an Expression which return text from a check box result
Ok, that works as well but I have 16 check boxes and I have a message box saying it's too complex -
P
Creating an Expression which return text from a check box result
Cool, thanks for that. Now If I wanted to expand to multiple check boxes with multiple retuen values. I.e. Checbox A will return A, Checbox B will return B etc so you may have the returned text "A B C"? -
P
Creating an Expression which return text from a check box result
Err...In Expression Builder? -
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????
No it was just the ME.Refresh Thanks very much -
P
Two forms writing to one record????
I think that may have helped. Thank you I also had set Data Entry to No on the popup and it seems to be working... -
P
Two forms writing to one record????
No, I have tried setting it to 'No' on the pop up form but then the check box fields don't show, it's just the window and back colour