Search results

In Access 2010, have a form with a comand button that goes thru a range of recs and checks a field to see if that rec should be deleted. I had an identical button in an old system I wrote using Access 2002, so I copied the code but it just keeps going past the end of the records and adds new...

thank you very much toIsskint!! For your quick reply AND for your right on target answer!! Ofcourse...when I used isnul( ) and got the errormsg it was because I didn't have the full forms!formname.identifier. I corrected that, but htought the problem was with isnull Tahnk you so much! Jojo

I am working on a macro that should check to see if a field is blank, then close that form without saving the rec, and open another form. The field is text. The if statement has the full reference of forms!form name! etc, but i typed if [field] <>" ", and i'm getting a data mismatch error...

Thank you so much to Beetle, Duly registered boozer! Your suggestion including the code, I assume was meant to set as a property in property sheet, and it did not work, but I coded that as the textbox.value in the after update event of the combo box, and it works!!! I would NEVER have managed to...

Thank you so much to Beetle, Duly registered boozer! Your suggestion including the code, I assume was meant to set as a property in property sheet, and it did not work, but I coded that as the textbox.value in the after update event of the combo box, and it works!!! I would NEVER have managed...

I have a combo box on a form, and the control source is created by the query builder. When the user selects a value from the drop-down, I need text box elsewhere on the form to display a different field of the same record in the same query. This table was designed (not by me) with just the...

thank you so much to Big John Booty super Moderator, for your timely and exelllent answer to my rather dumb question, and for supplying an actual block of code. So helpful! However, I wasn't clear about my prob. I have a form with a print command btn. If clicked, the form closes, the report...

I am an Access newbie. I have a form with a command button that displays a report in print preview and a message box that asks the user if he wants to print now. If he clicks vbOK, the printdialog box displays, but if he cancels out of that, he should be able to preview the form to see if he...

thank you. That was VERY helpful-I wonder if that's why my form was freezing...I can't be sure b/c I deleted it after trying just about every possible event. Your comments re BeforeUpdate and AFterUpdate made it clear for me. thank you again.

thankyou! But do haave any examples? When is AFterUpdate the best, and what's the difference between AfterUpdate (runs after field is updated) and OnChange (runs after field is changed? Is it that OnChange fires after each single keypress? thnak you

hello all, I'm new to forum and pretty new to access. My question seems simple. What events are triggered by the forward and backward record selector keys? and by the new record key? On CHange? After Update? thank you jojo