Recent content by Cindy

hi could someone please tell me what is wrong here? I have an unbound OptionGroup of checkboxes. I set the group to Null in the double click event and to update the table fields using texts instead of numbers, I used this code: Me!ASAWhy = Choose(Me.Frame23, "Allergy", "UGIB", "GCS<8")...

Hi tad0075. I did but it gave me an error which I have only just figured out. I removed the ".Text" and replaced it with ".value". Thanks to you.

I tried to adapt John Big Booty's code but it didn't work for me. I have the below code in the OnChange event of my search box. It uses a continuous subform to search the database. It searches as I type and double clicking on the record populates the main form. Before I complete typing in the...

Yes I just had that discussion with a colleague and decided that it would be insecure since the userID is a combo box and some of the users (in remote locations) might at some point need to use a public machine to send in data. Many thanks Pbaldy

Pbaldy my login form is unbound and the UserID has a query as rowsource but there is no option to create a rowsource for the chkRemember checkbox. Also, since the form is unbound, the table fields are not listed in the control source drop-down-arrow. Could you advise please? My thots were to...

Hi Pbaldy. Yes THAT is what I want. I'll try that. Hopefully my code works. Thanks.

hi, many thanks Paul. I have the below code for my login form. After confirming that the Password is correct, I assigned it to the public variable but could you advise on the code to utilise this public variable? Public strRemember As String Private Sub Command1_Click() If...

Hi, my VB skills are still beginner and I need help with this please. On my Login form, I have a check box to Remember Password. How can I code this?

hey! I didn't say that. Well, I guess my actions said so:o. I'm juggling many balls in the air and I think I'm too saturated to absorb new knowledge right now. I tried to code it but kept getting a compiler error. That is why I shifted to using a table validation - less hassle:(

hi vbaInet, in the database which I uploaded yesterday, opening a record in the subform (by double clicking on TripID) will populate a tab page. I am only concerned with the Preeclampsia page. My validation rule says that if [More Magnesium given?] = "Yes" then the dose should be provided in the...

Just trying to test/break it before the users wreck it irreparably:) I uploaded it in a new thread but here it is again. Your help is greatly appreciated:) http://www.access-programmers.co.uk/forums/showthread.php?t=267361

vbaInet - The validation rule worked (the only measure of success I've had with this particular constraint) until I needed to correct or violate a previously saved record...sigh!

It did not work so I'm going with the table validation rule IIf([More MgSO4?]="Yes",Not IsNull([extra dosage]),IsNull([extra dosage])) And IIf([anti HyperT agent?]="Yes",Not IsNull([anti HyperT dosage]),IsNull([anti HyperT dosage]))

For the attached Database, I have the table validation rule: IIf([More MgSO4?]="Yes",Not IsNull([extra dosage]),IsNull([extra dosage])) And IIf([anti HyperT agent?]="Yes",Not IsNull([anti HyperT dosage]),IsNull([anti HyperT dosage])) This works until you try to make a correction on a...

hey Rookie, no curses on my thread :mad::) I will try the nested IF statement and send out an SOS if it still doesn't work. I really hope it does. thanks y'all:)