Search results for query: *

Sid: There's no practical way to send a parameter to a stored procedure and open it visually in a grid using the OpenStoreProcedure method. (BTW, global vars won't do a thing) What you need to do is revise your SP to output to a table and then open that object. If you want to use a temp table...

rob: The only way to do this, is to use the Shell command in Access and provide a command line with your db, the workgroup file, password and user name in the string. Look in the help file under Command line for the appropriate switchs to set, it would look something like...

Within Access you can use the SendObject Method to send an email to your default mail system. The problems however with SendObject in your situation are: 1.) Send Object doesn't support filtering a report to only output specific data for the target recipient. You can modify your reports...

You may want to check out our PDF and Mail library for Access. It can not only output the PDF files, but also merge multiple files into one file on the fly from within Access. HTH http://ourworld.compuserve.com/homepages/attac-cg

Take a look at our PDF and Mail Library which can automate output of Access reports including specifying the file name etc. http://ourworld.compuserve.com/homepages/attac-cg

If you'd like to automate the output of PDF files from Access reports, specifying the file name and location at run time, take a look at our PDF and Mail Library for Access at: http://ourworld.compuserve.com/homepages/attac-cg

To use a custom paper size you have to create the paper size before you can use it. In Windows NT/2000/Xp, you do this by creating what is called a form, by opening the printers folder and from the file menu choosing "server" properties and creating a new paper size. On 9.x platforms...

Use the chart's recordsource to specify a query or a sql string to select the records at run time.

To use a specific printer for a report, you can do it two ways: 1.) Select the report in the db window and from the File -> Page set up menu on the Page tab, select a "specific printer". The drawback to this approach is that if that specific printer is not on the other user's machine...

1.) Access reports will not support outputting Adobe Acrobat documents as embedded images in the report. Reports don't suppor the Acrobat OLE control. (You can try embedding the pdf on a form and using that as a sub report on the report, which will work in Access 2000 and 2002 but not 97...