docmd Code in report

C

Crazyhorse

Cancel on a Make Table query w Code


Private Sub Report_Open(Cancel As Integer)

DoCmd.SetWarnings False
DoCmd.OpenQuery "mk_totalTimeWorked", acViewNormal, acEdit

End Sub


make table query when the person has to put in the dates. but if someone
cancels the date then I get a debug message.

Please help thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Docmd.openquery causes error 4
Form Code HELP ?? 4
Status Bar 0
Error 20 Resume without Error 2
Rollback doesn't work! 0
MAYDAY! MADAY! - Run time error 8
Append Query problem 2
Not happening in order?? 2

Top