Recent content by Jack58

I am using the Code listed below in Access 2000 with a Command Button to Open Word, Open a Document and then run a Word Macro. Private Sub Command7_Click() On Error GoTo Err_OpenGuide Dim Oapp As Object Set Oapp = CreateObject("Word.Application") Oapp.Documents.Add...

Perfect Thanks SO Much Jack

Here is the error, The Expression on Click you enteredas the event property setting produced the following error, Procedure declaration does not match description of event or procedure having the same name. * the Expression may not result in the name of a macro, the name of a used-defined...

When I enter the above code , then invoke the command button I am getting a long error message, stateing that the procedure does not match. Not to sure what to do with this. I am awarding you a star for all your help, and hoping you will continue to help on this project. Jack

I have even tryed the following with no luck, Private Sub Command6_Click(SetSh As Variant) Dim SetSh As Variant SetSh = CreateObject("WScript.Shell") sh.Run """X:\Purchasing\Unfilled Report""" End Sub Jack

When I got the following code entered, Private Sub Command6_Click() Set sh = CreateObject("WScript.Shell") sh.Run """X:\Purchasing\Unfilled Report""" End Sub I received a Compile Error Variable Not Defined, Hope you can help me out Thanks Again!!! Jack

I am in Microsoft Access 2000 not the Script Editor. I am not to sure what you are referancing here. I have tryed both codes and either work. Could it be that I need to enter the entire network address to the folder? epsrv1\Purchasing\General Thanks Jack

I used the following code on a command Button, CreateObject("WScript.Shell").Run "X:\Purchasing\Unfilled Report", Received the following error, Methodd "Run" of Object IWshSheel3' Failed Hope this helps solve this problem. Thanks again Jack

Is it possible to create a link to Open a Folder?. Example; c:/Download/Help and display the contents in explorer? I have found that a Hyperlink will only work linked directly to a file. Thanks Jack

I am using the code listed below to automatically set my print ranges on my reports. The problem I am having is that if the document has no page breaks, the code works great, however if the report is Sub-Totaled and placing a page break in the document the code below will only print the first...

I have a PowerPoint Sheet that has a command button on it. I would like to make it not visable when printing. I have looked all through the Code and can not find where or how I would use this option, or the code for it. Thanks in Advance Jack J.

Sorrry that did not work. Looked at the link and it does not apply to this problem. Jack

I have a database that is converting text files into a Microsoft Word 2000 File. The problem that I am having is that WINWORD.EXE is not closing. I have used the following code to close the Text files, however I still have the problem of WINWORD remaining in my Taskbar and not allowing me to...

I have a Microsoft Access Database with a command Button that I need to be able to a Open Microsoft Word document and then Run a Word Macro. So what I would need is the code to Open Word, Open the File then Execuite the Macro, then return the Word document to normal. Sure Hope someone can...

Is it possible to create an Outlook 2000 message form that will allow me to set a Task automatically to remind myself of an important event that the e-mail is pertaining to. I send MANY e-mails daily, which require some type of a follow-up. I get so busy with many other tasks and have a hard...