Search results

Bob, Worked a treat. Thanks.

Same problem I'm having exactly the same problem. The code just churns straight through breakpoints or "Stop" lines as if they weren't there. This problem is frustrating the hell out of me, because there are lots of DoCmd.RunSQL commands in the procedure, and I'm getting a type mismatch...

Code is exactly the same as Webbenstein's, except with my forms' names substituted in. It stops executing on the line: Forms!frmMyForm!subfrmMySubForm.Form.GoToLastRecord

Can't get it to work Webbenstein, I'm trying to do something similar, except that I want the subform to go to a new record (to save the user scrolling down). When I try to start out by applying your code, I get the following error message: Run-time error '2445': You entered an expression...

Got it working in Access 2000 I happened to get it to work in Access 2000. Here's the code: Dim stDocName As String stDocName = "(YourReportName)" 'Open and hide the report DoCmd.OpenReport stDocName, acPreview Reports(stDocName).Visible = False...

access 2000? I happen to work for one of those companies who knows how important it is to keep their systems up-to-date...NOT! Can anyone tell me what the same code would be in Access 2000? Namely, there are too many arguments in the "DoCmd.OpenReport" lines (so I don't know how to hide the...