Search results for query: *

The problem with this is the part I want to run is a Private Sub. I have been reading and haven't found the proper way to assign a macro to run a private sub. Here is my code which I want to run from an icon: Private Sub Output_Composite_Sto_Click() On Error GoTo...

Yes, Instead of opening up the data base, clicking on the command buttons to do the job, I would like to make an ICON on my desktop that has this run command attached to it...one click, and job is done.

I have been trying to figure out a way to run a Private Sub through the command line. For instance, I have a command button that is linked to an event procedure. I would like to run that procedure from the command line, like: c:\databases\mydatabase.mdb /[command to run private sub] This...

THANKS EVERYONE! I got it to work prefectly. I didn't have to do the HTML thing because I changed the OutputTo format to RTF, changed the file extension to .DOC, then changed the WITH > .HTMLBody to just .Body It simply pastes the document with rich text features in the email body. Here is...

Hi, 1st post here. I am trying to automate a morning story report for my company. Before I took this position, someone had made code to do it, but it isn't totally automated and the code is long. I think it could be simplified. Here's the old code: Private Sub Output_Composite_Sto_Click() On...

If you open your mail client before running the sendobject code. For instance, before the sendobject code, type: TaskID = Shell("C:\program files\Microsoft Office\Office\Outlook.exe", vbMaximizedFocus That should open up the client before trying to send the object to it.