Search results for query: *

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

...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 fuction, or [Event prodedure] *there may have been a error...

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...

Is it possible to create an outlook message form that will allow me to set a Task Atomically 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 time...

I downloaded the program, however can not figure how to get to the program itself. Does Outlook have an add in manager? Please Help Jack

If you are using Outlook 2000 try this, Go to Tools, Options, Delegates. You can add users from just about any type of list or server here. You can also go to Tools, Service and create a Personal Address Book for each person or Group you want to have access to the files on the mail server...

You can set a Rule for this purpose. Go to Organize, Highlight the message you want moved, Click on the “Move Button”. When you do, a sub form will be displayed, next click on Other Folders and select what Server or Folder you would like this message to be forwarded to. Hope this helps Jack

I am on a Microsoft Exchange E-Mail system(I am using Outlook 2000). When I choose Forms, Choose a Form I am defaulted to the "Organizational Forms". I must then click on the drop down box and choose "Personal Form" to select my custom forms. Does anyone know how to allow...