I am setting my group levels with code in the Open Event of my report. My Grouplevel(0) is a text field and I want to use the val() function when sorting this...

Intially I created a report grouped by truck# and sevice date (called Truck Info Grouped by Date). In the detail for each group it shows the truck hours,...

On a form called SFI Reports I have a textbox called BegDate and another one called EndDate, both with a Short Date format and =Now() as thier default values. ...

Just printed mailing labels for the first time on a printer I had to buy two months ago to replace the previous printer. The labels came out 9 by 3 instead of...

Hoping someone can help me!!!!! I have 4 queries which are needed to generate this one report. Query1 asks for users input for a number, Queries 2 and 3 then...

Hi, I've used a VBA coding I've found in a forum and decided to give it a try. What the coding do is to print the current record I'm seeing in my...

Is there a function that would show the time that a report was run? Here's what I mean.... I currently use the built-in "Date and Time" in the page footer. ...

I have a switchboard which, when the button for the report is clicked, will give me a pop up box asking which vendor I want the report for. Is there a way to...

I have somehow lost the title bar line of icons etc which has at the end the icon to change the print colour of the text in the document. Can anyone help....

Hey everyone... I have a table of data with a few columns...date, part A, part B, part C. The table has null values for days when no data is collected. I...

In the query, field name is "role". How do I populate the empty fields with a word. In the query or in the report is fine. The word to populate...

How do you get the orientation of a report(Portrait or Landscape) though code? I tried the code below but it always gives me zero. Thanks Don Dim rpt As...

I want to print a long text Report in Access it runs into over 10 pages. However, when I print it, it prints only the 1st page. What could be a problem? I...

I have a problem with page margins, if I change a margin on a report and save all. when the report is reopened the margins have reverted to default values. Any...

I am duplicating a form with an access report. The form is a half-page timesheet--I would like to print the first half of the ordered query recordset on the...

I have 3 cbos: Employee Name, Report Type and Report Instance. The user selects the Employee Name then the Report Type (this cbo is populated through a SQL...

Hi all, I have several queries that we run on a daily basis and afterwards manually type the query results into an Excel spreadsheet. I'm trying to figure out...

I have a report with almost 900 records. As you click from report 1, 2, 3, etc..all the dates are in chron order. Yet, February 2006 shows before December 05...

Hi, How can I display an ms access report on intranet? data access pages have navigation bars so they are not useful. I just want to display data from a report...

I have a report with a controls "minor" "balance" "debits'' and "credits" in "minor footer" . The control "debits" is an IIF statement: =IIf(0,,0) and the...