I have a question regarding generation of ACCESS reports and converting them to .pdf documents. I have a function in an ACCESS database that loops through records in a table and creates a rep...
I have an export that works in another database and so I figured i could use it in my current project so I did the copy and paste and then just edited the areas i thought needed changed but no...
Hi all,
I have an access table which stores the daywise prices of some 1000 shares such that any row in the table gives the price of the share in that row as on a particular date (Please see...
I wish to export a report to a Word doc. I know the formatting won't export, thats fine.
Here's my code:
stCriteria = "Tran_ID = " & lTranID
stReport = "rptFleet_Deletion"
stPath =...
I have a label and 6 related fields on a report that do not always have data. When there is no data I can force the label not to show but it still displays a blank line. I have can grow and ...
I have a number of snapshot (.snp) files created from MS Access that I need to convert to PDF. I have Adobe Acrobat 7.0 Standard and Adobe Distiller 7.0. I can right-click any of the snapshot ...
I have a Access report that is a "Customer Account Statement"
The report lists Invoice Number and Dates along with the Amounts for invoices that are still outstanding.
At the bottom of t...
I have an Access 2003 database that I want a report to sub total by month and within that month subtotal certain parts
This is how the table set up
These are the fiels - Month, Plan, Amo...
I have changed the query name that is used by a report. How do I get the report to look at the new query. I don't want to re create the report.
Hi Experts
I have got a Contact/Sales DB, with tables, forms, queries and reports already configured and setup.
I would like to set up either a query, which I can in return use in reports, o...
Hi Experts
I am busy creating a Access 2003 DB. I have manage to create drop down boxes and check boxes with a lot of help from a expert from this site.
A bit of background, I a have create...
I have an Access 2003 database with two separate fields for last and first name. These fields are combined as one "full name" field and shown on Access reports The customer exports these rep...
Hi,
Currently I'm creating Access Report (Attached), but want to make it similar with Excel style (Attached). I create this reports using wizard (Block layout), and set the Can Grow setting...
I have a report based on a crosstab query. The crosstab query performs a count function. Occasionally, the count will return null if no records exist. For the values that are null, I would ...
I've been working on a database that has a form that contains data that I need for other applications. I have a word template that has merge fields in it, and I've created merge documents util...
I have a series of yes/no check boxes in my database. On a report, I would like to count only the records that are checked. I have used this code in the Control Source of an unbound text box...
I have a report that is similar to this question except it has to to with fees. I already have four levels of groupings and have a count of the records in each group. I need to count only the ...
I need to print a single record on a 1 page report, each time I enter a new record.
I will enter Job details (on repair of equipment), then want to click a print button to print a separate...
I am creating a PDF from access 2007 using DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, strPath, , , , acExportQualityPrint
I am using microsofts office 2007 pdf generator and wor...
Hello,
I am trying to print three receipts in one page in ms access. The report is divided in three and has to be populated with three different records from a table. Can anybody help me wit...
I am working in a report in Access 2003. I am attempting to insert a text box into the report and then link it to a control source that will populate the text box with data from a table. Aft...
I need assistance with getting my filter to work. I am fairly new to coding so please work with me. I have tried to research my answer with no luck. So, please take patience with me. With ...
I have a large table that I have selected data from th by use of queries, totaling 15 different queries. I want to take those queries and sum the totals of one of the fields within the query ...
I am sure this is a no-brainer, but I am stuck. How do you pass the value of a variable (set in vba code) to a report?
In the page footer of my report I need to display the beginning time(...
I have a database that was created in Access 2007 by a co-worker. It is a simple tape log database. What he wants me to do is to create a report based on a query that initially asks for user...
