Is there a way to set the ,acPreview , to open in "Fit" mode?

Is there any reason why this formula wouldn't work? =(nz()+()+()+()) It works for all values of sumw, sumo, sumf, but not for sumh. sumw is the sum of all...

I'm making revisions to an access project on a computer that does not have a printer installed. It seems that a printer is required to preview or design a...

I have a field: tblPKCGPhysicalAttributes.Style Style is a combo box that queries: tblPKCGStyles.txtCodeID.CorrugatedStyles txtCodeID is the bound column and...

Hey guys, Here is a question for anyone who may be able to shed light on this. Is there a way to count specifically on certain values, but incorporating a...

Hi, I tried to create user security level in access 2003. for some reason, one of our administrator cannot access reports in database. Everyone else on the...

I am trying to figure out how to run a single customer listing report in access and have it break and email by each sales person. Any help would be appreciated.

Is it possible to have a field in the title of a report that the user can fill in before the report is printed? I am creating a switchboard as the user is...

I would like to control the background color of a field on a report during printing. I tried modifying the background with the following code on the OnFormat...

Hi, I want to highlight a date, so that when six months has elapsed the date would go red or any other colour. Any help would be appreciated, any actual...

I have a report that has a group heading. The report displays claims that companies have made. Each group heading display the company's info (address,...

I want my report to calculate the total of a group of cells. I have a report that shows a daily total but I want all the daily totals figured at the end of the...

I have a field that adds two other fields. When one or both of the other two fields are null I get an #Error in the block as Expected. I would like to trap for...

Hello, I came across the answer before but can't find it when I need it... I am trying to create a table in a report in which fields can grow and shrink. I...

I'm trying to make a bar chart (using the wizard) but I'm new to charts in Access and can't seem to have any luck. Can anyone help me get started with this? I...

Hello, I have a problem that I'm hoping someone can help me with. I'm not very experimented with reports in access so I need a step by step or example...

Hello All, Access 2003: I created a report for a table (by using the Wizard) and made a grouping level on my date field. I then set the group on property to...

I am trying to design a report that has four fields, city (text field), building name(text field), building area (number field), and leased or owned (logical...

I've created a report but want it to print only the record that's selected by the print preview button. Right now the report displays all records. Here's some...

Subject: CROSSTAB QUERY: Combining text across resulting columns into one text string. Any suggestions for method to combine text across columns in crosstab...