Search results

This may....or may not help..? :(

To open a blank word doc use this (minus the greetings and salutations part of course).: Dim oApp As Object Dim strFileName As String Dim strFilePath As String Dim objDOC As Object Dim objCurs As Object 'create the blank doc --> also shows how you can add some text there. Set oApp =...

The object doesn't support .filter. You have used msoFileDialogSaveAs which doesn't allow the filter. If you were selecting a file with msoFileDialogFilePicker THEN you can use .filter.

What is the error message?

I don't have Access 07 yet, but I would imagine that you use the file dialog to assign a string of the requested filepath to a string variable (e.g. strPath). Then use this code: DoCmd.OutputTo acOutputReport, "MyReprot", acFormatPDF, strPath, True

Do you have admin rights on the Server where the file resides?

Well said DCrake

DJKarl is right. What is your pos?

Use this demo to get some ideas:

Dont do this Optional OutputPDFname As String = "c:\Reports\Daily.pdf", _ this information is sent when you call the function. Check out this demo fresh from the Spent Geezers Association. Dll files must be stored at same location as the mdb for the print to work. Thanks Lebans.

sup dawg!!!!!

Hi Guys, Is there anybody out there who can help me to design an exciting new database with fantastic commercial potential. This is a genuine opportunity for somebody with time on their hands. Philip I have time on my hands

Yo in the textbox or control's "After Update" event add this code: if [yourtextboxName].value > [your value here] then Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("C:\location\yourSPREDDY.xls") end if

I believe the only way is by changing their default printer settings.

Can you post the code for the function please?

The table needs to be in a form as a subform. Create a form. Use the Subform / Subreport tool to add a subform. Use the wizard to set it up for you. In design mode view the properties of the sizable textbox on the new subform. Create an event for the "After Update" event that does this...

Quit your desk job and get a job involving physical work. Then you are exercising all day (and most likely getting paid far less so it is harder to indulge ones self).

Re: Report as a Excel File Greetings, This will get you started... Dim strFilePath as string strFilePath replace(NOW," ","") strFilePath replace(strFilePath,":","") strFilePath replace(strFilePath,"/","") strfilepath = "c:\Bank\" & strfilepath & "_Cheque_Issued_But_Not_Reconciled.xls...

On XP that returns "C:\Documents and Settings\<username>\Desktop"

It is a text field, not Boolean (Yes/No).