Search results

Evan, Thanks that worked perfectly once I sorted my logic out. All I had to do was to change the = to > to make it work the way I wanted it to. Thanks a bunch for the explanation of what I was doing wrong. Filed away under "Knowledge of VBA" - a VERY small file right now but gettting larger...

I searched the forum here and found what I thought was just the answer I was looking for in an earlier thread. However when I try and paste the code from the post I keep getting a compile error "Expected seprator or )". Being the nooby that I am I have tried putting () around just about...

Here is the code to trap the standard error message and display a custom one. Private Sub[YOUR CONTROL NAME]AfterUpdate() Const conErrRequiredData = 3022 If DataErr = conErrRequiredData Then MsgBox ("Serial number already exists. Please check your entry and try again.")...

You would have to run two queries to do this. The first query would get the list of students that are enrolled in this class, then the second query would be an update query to update the checkbox for enrolled to NO. I would display the results of the first query in a form and then run the second...

Thanks for the response scalextric59. Got it figured out from that. Bit of a blonde moment I think :)

I have searched for an answer to this question without any sucess, so any help would be appreciated. I have a report that is linked to a command button on a form. I have the following VBA code on the button: Private Sub cboRMAComplete_Click() DoCmd.Close DoCmd.OpenReport "RMA Label"...

Hi all, Basically I have what is probably some sort of brain blockage on my part but I could use some assistance. I have a form which contains an unbound combo box and two unbound date boxes that provide inout to a select query and a command button to run the query. No issues there, form...