Recent content by Jason Dinnell

After some research on error handling and error trapping things are making more sense, but I was wondering if using “Return Next” wouldn’t be better in the above case. Return next would ignore the error and start at the next line which in this case exits the procedure. The error handler...

Thanks for the help. You put me on the right track. My mind was working this problem all wrong. I was trying to filter it in the form and then pass the data to the report, like how it is when I print. This is a little more work since I have to generate more queries but it sure solves allot...

I have searched but I can’t find what I am looking for. Can someone please point me in the right direction? From a command button I am looking for a way to email the current record from a form using a report as an attachment. Thanks Jason Dinnell

Thanks a lot. It works but I still do not understand exactly why. I did try the code as written several times but I never saved it so when I replied I accidentally left out those two lines. Something I noticed is that if I copy and past the new lines of code into my original or just type...

Here is the code. i have tried using the same error handling that access puts on my other command buttons but nothing works. I pulled the code for printing one record at a time off the net. I am sure the solution is simple but this is my first time with any programming language. Private Sub...

Thanks for the Help.. when i added the code i get a compile error "Lable not defined"

Is there code that turns off the error msg when you cancel a view report or send object command button. “Run time error 2501:” The OpenReport action was canceled Thanks