Search results

Bob, Thanks for all your advice. I'll try the subforms and see if I have more luck with that. Thanks, Doc

Let me take a look at that. The tab control event procedure looks like this: Private Sub TabCtlCommodities_Change() Dim stBatDocName As String Dim stGenDocName As String Select Case TabCtlCommodities Case 0 'First Page 'Code for Page 1 stBatDocName =...

No I am not using a subform. I just want to display the results of the query in each tab that corresponds to the matching controls.

I am using a unique query on each tab on a tab control and I want the results to display in the respective tab that the user clicks on. I hope that makes sense.

Bob, It is just a select query. Thanks, Doc

I have several queries that are associated with the tabs on a tab control. They work just fine but I do not want them to open after they run. Does anyone know a workaround for this? Thanks - Doc

Trevor - thanks for the reply. Let me try it and I'll let you know how it goes. I am using Access 2007. Does that make any difference?

Bob - we are getting real close. I no longer get error messages. As you can see by the attached screen shot of the macro I had to put the error handling in the macro that is giving us the problem. I tried to put it at the top of this macro but that did not work. The only problem I am having...

Bob - I am using Access 2007. Any suggestions on how to handle errors in the macro?

Bob - These macros are housed in another macro called mcrShortcutMenucommands. I use mcrShortcutMenucommands as a shortcut menu for a report. I can take each macro in mcrShortcutMenucommands and convert it to VB if that would help.

Bob, Here you go. I am only average experienced with VB so please let me know if there is a better way to do this. Thanks, Jeff

Bob - I think I have the module the way you want it (see below). However, I'm still getting the error messages (see attached in the order that they appear). I changed the error message to the error number referenced on the error message. I've also attached a screen shot of my macro. Again...

Bob - that makes sense. However, I'm calling this function directly from a RunCode command in a macro that is being used as a shortcut menu bar for a report. Would you have a recommendation on how to handle that? Thank you so much for the input.

Bob, Thank you so much for your reply. I tried your solution but am still getting the cancel sendobject message (see attached) when I cancel the email rather than sending it. The program goes back to the form I intended but the entire application is frozen at that time and I have to use task...

The following code works fine except when the email pops up to the user and the user closes the email without sending. I get the message "Run time error 2501; The sendobject action was cancelled. DoCmd.OutputTo acOutputReport, "rptQuotePrintedNew", "PDFFormat(*.pdf)"...

This is my first post in this forum and hopefully I can find someone who has a solution for this problem that is driving me to drink (more). The entire macro works as designed except when someone uses the sendobject a second time. For example, the user goes through and sends a quote via email...