I'm writing a report in Access 2003. I have a field [esstatuste] that will contain one of three options: supervised, unsupervised or null. I'm trying to create a text box that will show eith...
What I have is a report that works off off a Query. I have something called a branch in the query and I break them into differnet sections on the reports. What I need to do is count the two ...
I have an MS Access Report with Unbound Text Boxes. I have code that creates SQL Queries, stores them in array arguments (such as arr(1) as seen below) and then assigns the RESULT of that que...
One of the fields in an Access 2007 database (which is actually a link to an Excel CSV file, the CSV file being exported from an accounting program) contains text which can be a variable lengt...
I am attempting to set an Access Report Filter via my Visual basic Code.
I have some variables, arr(0), arr(2) which hold some values that are being compared
When I have the line:
Me.Fi...
Hello All- I have a VBA program that creates a Graph Report in Access. I would like to see some code that will export this Report to a PDF and place it in a folder. Thank you for your help ...
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...
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 have a rather odd report. I use queries to collect the data I need into a make table. The report shows multiple stores within multiple counties. One of the criteria that I append repeats ...
hi, i need to compare two tables in ACCESS 2003.
There is a master memebership table1 that i need to compare with membership table2. I need to find the missing members in table2 that are act...
I have a report that is Has a page header, detail section and page footer. None of these have any starnge vba, or calculations just some simple addition and multiplication. There are only 3 re...
OK, searched all over for this one, with no luck, hoping some experts can help me. Setup a main form with 2 subforms, where if certain criteria was met one subform shows up, otherwise the oth...
I am needing to export data from a table in access to word in an outline format. Is this possible to create a template in word and export the data to the template from access?
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 about 250+ text boxes on a report that contain DLOOKUP or DSUM which reference the report name. Sample:
=IIf(DLookUp("[DTyp]","[Date_t]","[Date] = #" & Format(Reports!rptSched45Days...
I am trying to figure out the elapsed time for two date/time fields I am keeping track of. The process works well when I do this:
ElapsedTime =[delivered]-[released]
The field format is se...
I have a report in Access and I have a field in my table that lists a value. In this case it is a year.
there are about 6000 records but only not all of them have the "year" filled in. I ...
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 ...
Hello i have a table with 2 dates (format d-m-yyyy h:mm:s, example: 3-12-2007 9:05:03)
Is it possible to get the days between those dates?
I have the following table:
date1 ...
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 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 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 a text box on a MS Access report.
The source is a memo field in a table that I have imported from a SQL Server database.
When I display the field in a report none of the formatting ...
I've been creating reports in Access for 6 years, and only now, in Access 2007, I can not do some simple things. I'm trying to create a report in Access 2007 running on XP. Using the report ...
Hello,
I am building a report of daily total quantities delivered to customers by week
I want to format the report such that it reads across the page rather than down
IE
Week Numbe...
