Recent content by cmmd2003

how can you reference a particular button

Private Sub Report_Open(Cancel As Integer) DoCmd.OpenReport "RptItem" End Sub

when i use his code i get the same error. And f1 attempts to install some form of help that i dont have and it fails.

That doesnt help. From the switchboard, i want to click a button that will open the report, and the report prints automatically. I tried using the code DoCmd.PrintOut acPrintAll In the On open event to no success. Im getting the error message This action cannot be carried out while...

How do you print

Well basically, from a switchboard, i want to print a report without having to open it, go to filed and then click print. Ideally i just want it to open and print on its own.

Can anybody explain why this does not work Private Sub Report_Open(Cancel As Integer) DoCmd.PrintOut acPrintAll End Sub Im getting the error message This action cannot be carried out while processing a form or report event.

Thanks.. your a legend. Would it work the same with On Mouse Move

Nothing seems to happen. The Timer Interval event is left at 0. Not sure if that makes any differnce

I havent tried anything apart from using the timer interval. But that just runs the DoCmd consistently over an interval

However setting the allow additions property to no prevents any records being added at all

Thanks for all your help. Your a wiseman. That made sense, but is there a way i can set it so that if the computer has been left in the same state for, lets jus say 30 seconds, then something happens.

IS there a way of making a form close automatically after a period of inactivity.

The resource i need for that is apparently unavailable, prob cos i got a dodgey copy

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Could someone explain to me what acFormBar, acRecordsMenu and acMenuVer70 refer to please.