I would like to loop through a list of employees and print (print to pdf) individual reports. I don't want one large report, I need a separate report for each person.
I currently have the...
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 report COMMUNICATION BY LOCATION that uses the query CommLine, which is based on the dialog box SelComTypeLoc.
The criteria for the query is [Forms]![SelComTypeLoc]![cLoc]
When ...
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 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 ...
Simple form design but detail runs to several pages. Every other page is blank i.e. the continuation of the data on page 1 is on page 3
Cant see where to prevent this, have looked in
File-...
In my MS Access 2007 application, I have a report (ReportMain) & a sub report (ReportSub) embedded in the footer of MainReport. ReportSub has 2 Unbound OLE Objects that are MS Graph, OLEGraph1...
So I have been working on this Access Report that essentially lays out a schedule of events for various activities at my company. We currently generate these things using Excel spreadsheets a...
I need to rotate text on my report to read sideways, bottom-to-top. I'm having trouble with the Stephen Lebans approach which I will describe below but first I'd like to ask the Microsoft reps...
Hello, I am a new user of Access 2007 using databases I have developed off of templates, but now need more functionality. I am not familiar with VB or macros, so please treat me as though I'm...
I have a report with a Report Footer but I want to not have the Page Header print on that final page because it looks really tacky.
I would need to insert a page break after the final page...
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 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 have a report that prints a list of employees in a particular status.
Ive been asked to add the department (which I did) and then to page break on each change in department. (which I can...
I am attempting to reuse a basic report by dynamically modifying it using user inputted values from a form.
This eliminates the need to create multiple reports that vary only slightly for a s...
I have an access report built off a query. I simply want to display the number of records that are returned by the query
something like "=RecordCount" or something like that? I know how to ...
I want to open a report using the [ENTER] prompt for the underlying query to filter the returned data by a value greater or less than (ie: not equal to) the text supplied. EG: if 2007 is ent...
Hi Expert,
I have a quick question.
I am seeking a function that can change words into bold format in a textbox.
for example,
="Today Date is " & Boldfunction(Date()) & "."
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 have created a query that brings through a company name (companyname), job title (title), the date (date), the month (date by month) and a rep name (CSR).
To execute the query, the user m...
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...
I have created an Access 2007 database that captures employee clock in and clock out times. What I would like to do is generate a report that calculates their daily, weekly, and monthly total ...
How to export an Access report to a pdf file.
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 MS Access report on which I would like to have a sequential number assigned to each record that appears on it and in addition a total for the total number of records. Is this possible?
