You all have been so wonderful and extremely helpful. May I borrow upon your expertise again? In a report I would like to create a text box that checks to...

I'm trying to create a publication with 11 subreports. However, the subreports kept duplicating themselves over and over again. Any idea how to turn off the...

I have some trouble setting the size of the footer section and the details section. My header section contains order information (i.e. name, adress etc)....

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

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

I have a report that is filtered by a form. I need to be able to get a count of the total amount of items in the table including what is being...

I have a table that assigns a number to different phone types, i.e. cell, e-mail, etc. I wrote an expression to place each into its own column (=IIf(="5",). ...

I keep creating Column charts in Access but I can't adjust the width of the bars if I have more than about 10 data elements on the x axis (horizontal axis). I...

I require a report that will give me a weekly/monthly printout of events that happen both weekly, fortnightly and monthly - by date order ie: giving a schedule...

I am running into problems with the best way to design a report in the format I need it in. I created a query that shows a listing of providers,...

Hi I can not figure out how too get ot of a simple problem: In a footer of a report I have a formula in a text box that work ok when there are values to...

Hi, I have an application which needs a number of reports to open either with both the modal and popup properties set, or with neither modal nor...

I can no longer preview, design or create reports in databases that I have created. Even if I build a database from scratch, Access does not respond in the...

I have a database which includes a form where you can view and print various date ranges of data buy pressing coded command buttons. Well one user got a new PC...

I created a report that is a purchase order. There is a subform on the input form where you enter the product information. When I enter the information and...

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