Recent content by TLW

When I open a certain report, I would like to print that report and at the same time create a pdf file and save the pdf file in a specified directory. Does anyone know where to begin with this task. I have been told that VB code is the way to go. Can I create a macro that could accomplish...

I am using a subreport to display data for certain records. For a given subreport, I can have up to 4 entries in the underlying query. I would like to show the groups of data for the 4 entries side by side instead of a up and down. In other words, I have 4 groups, each group appears on a...

I need to the ability to export data from an Access query into a MS Excel spreadsheet template. I need certain fields in Access to be exported and placed in certain cells in MS Excel. Does anyone have any input on where to start looking for documentation on this procedure?? Thanks for any help!!!

Thanks for the help you provided.

Could you please elaborate on where the "#" symbols should be placed in the parameter. Thanks

Hello and Thanks for the response, I cannot get this mask to work with what I am trying to do. IF you or anyone else has any idea how to to do this please let me know. Thanks

I have created a query in which I prompt for the user to input a date and time. Here is the statement I have used in my query for the input parameter: "Between [Enter Production Start Date and Time:] And [Enter Production End Date Time:]" When the user runs the report it will prompt for the...

I have set up my query to specify for an input parameter when the report runs. The input parameter is as follows in the criteria for the query: "Between [Enter Shipping Beginning Date:] And [Enter Shipping End Date:]" How can I display what the user enters for the input parameter on the...

I cannot get a certain field to appear as currency format. I use an expression to calculat this field in my query. I have tried to format this field as currency in both the query and report but it always appears as 0.####### instead of appearing as $0.##. Any ideas would be appreciated.

Well I tried with that syntax and this did not work either. If you have any other ideas please let me know, if not thanks for your help.

Here is my criteria: "Between [Enter Shipping Dock Beginning Date:] And [Enter Shipping Dock End Date:]" for the input. I have the expression for this parameter formatted as following: "DateStamp: Max(Format([ccpTimeStamp],"mm\dd\yy"))" When I tried to insert the # into the criteria I received...

I have specified an input parameter to prompt for a date range when opening a report. Is there some way to allow the parameter to be passed as any date format. Hence, the user could type 02/01/02 or 2/1/02 or 2-1-02 or 02-01-02 ... Thanks for any help.

I am getting a data type mismatch error when attempting to open a report. The query the report is based on opens fine, but when I try to open the report is get this error. I have tried deleting controls on the report to determine which control is causing this. Can anyone help me with this...

Thanks for the explanation. I really appreciate your help on this and I will give it a try.

I need the fractions to the nearest 1/16 of an inch. I am assuming the reply you posted is a Module. So, which part of the module do I need to insert into my statement when building the query/report? Thanks for all of your help so far.