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 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....

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...

Hi All, My report is showing its name on the top of every page which is what I wanted it to do. but....it's also showing it eventhough there is no data on the...

I have a report that is supposed to substitude a standard form of the social insurance department. This form has a predefined number of lines (say 20). If the...

I would like to get 3 row with grey backround and next 3 rows transperent/non background or a line/underline every 3rd row

I am using a Form to imput data into a Table and for each Record I enter I want to send an E-Mail of only that record. Is it possible? When I use SendObject, I...

Is there something that can help me print a text box on the left side which is in the center (within 1 record) of a format grouping?? I could print the first...

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. ...

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...

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...

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...

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...

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...

I can set a scale and draw lines and points on a report by building "on format" code. But how do I the the "on format" event to read the data from a table or...