Search results

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

UPDATE: if I put is null in the query instead of is not = "NA" then I get all the records that I had been testing (typed in NA and then deleted it). If I query for is not null, I get all the blank records that I have not tested (which should be nulls right?)

Hi, I have a large questionaire table. One column has yes/no/na as options. I was testing it and set some records to NA then went through and deleted the NA. Now I have a query --> Select * From Table where answer not = "NA". This query is leaving out the records where I had NA and then...

Greetings and Salutations, Access 2003. I have subform who's datasource is a query. I have a button on the parent form that deletes the query def and recreates it. THis all works fine, but the new query definition is not displayed in the subform (even though the datasource query has changed)...