Recent content by hefly

I have a field in table tblInstruments called ModDate. I want to record the date that a record is modified. I have tried two things on my input form but neither are working. First solution I tried is: Private Sub Form_AfterUpdate() Docmd.RunSQL UPDATE tblInstruments SET...

I would like to create a macro using Dcount. All I get is syntex error. Macro begins: If =DCount("[ContactId]","qryAppendimportContacts")=0 Then CancelEvent I have tried every iteration I can think of, I am following examples I find on the web.. Nothing works. I have several access book...

Thank you pbaldy. I have to say I am in awe of people who have mastered vba. Each advance I make has been hard earned and any advance I have made has not been without help from the community of coders who graciously devote time to helping fledglings like me understand it. I often feel like this...

Hello. Hefly here from Colorado. I know some of the basics of Access but am a beginner with most things and new to VBA. I am interested in all that Access can do and would like to learn more about VBA... but I'm still stuggling with the basics. A big thank you to those who take the time...