MS Access Gurus - Need your expertise so do help!

[thereds]

Ignore Modeps' comment below - it was an earlier question that was resolved.

On to the new bit...

I have form that that has multple fields on it. If I click the 'x' to close the form, I want the form to check if all the required fields have been filled in. What is the easiest way to go about doing this?

Also, is there any way to disable the min/max/close buttons on the top right corner of every form in access?

Thx fellas

 

[Modeps]

your query looks off:
"UPDATE LoggedIn SET User = 'XYZ1234' WHERE ID = 1"

I dont think you need the LoggedIn prefix before your column names, at least I never do in php or coldfusion... other than that it should work.

(obligatory Access sux use MySQL or Microsoft SQL server comment 🙂)

 

[thereds]

bump

 

[Transition]

View > Code

You'll want to use the Form_Unload and put your code there. I'm playing with this at the moment to see how i can prompt a user if a dialog box is not filled out.

I tested the Form_Unload function by doing this....

Private Sub Form_Unload(Cancel As Integer)
MsgBox ("Bye.", )
End Sub

 

[Transition]

Actually, now looking at Access again i'd use the ValidationRule property available within the Text boxes.

So, use something like 'Is Not Null' for the validation rule, and the appropriate Validation Text

 

[Splitfyre]

First suggestion, get a real database... like Oracle 🙂 --- (sarcasm)