I have set my margins in a report, but when I open the report the margins default to their original settings. This cause a line to print on a second page. Each...

I have the following which runs on the click event of a command button in a form. The SQL part of it doesn't run at all. If I place this code into a query,...

How do I keep a query from just returning the column headings. I have a query that is returning just the column headings if one of the fields has a null...

When i try to use the Sum(abs) in a report it works great on my system on the network But on some when it prints some totals are correcr but the grand total...

Hello: I created a checkbook application that goes back several years so it has a lot of transactions. I only want to print transactions within the last 30...

I want to display a report which is coming from a criteria query. I want to give the criteria from a form (combo box selection. for example: company name). I...

I have 3 group headers on a report. Repeat Section is set to Yes for all 3 sections. When I preview the report it just hangs. I changed the repeat section...

Hi, All I have a customer contact info database, "Customer Name" & "Spause Name", address, city..., when i am printing a report i like to combine "Customer...

Hi, I am getting this error msg when i try to sum market values in a report. It is very strange as i understand the query has the market values data type as...

Hello, I am trying to have a report run from a form. The user enters information into the form and then, based on that information a report will run when...

I have a table that is generated from a make table query that queries client stay history to calculate daily occupancy. I need to generate a report that will...

Greetings**** Why the associated label will not grow/shrink stimulatingly as the text does? I have several text boxes that grow/shrink based on the amount of...

I am able to add a graph that produces a chart for me on a report with no problem. The type of graph I am using is line a multiple layer (with each...

Just to give you a little history...I enter my date into a form I created which also puts the information into a table which is called 2006. One of the...

Hi, For the following line of code I keep getting a mismatch error and I am not sure why I am trying to set up a button so that it previews a progress...

Hi all, is there any way i can insert a line break inside the text field on a report? i want to inset it instead of " - " (but only in case there is one in...

Hi, I work for an agency that is responible for funding certain public health programs in several states. I have designed a form in access with several...

I need to put the following code in a form, if the report shows a PrdtID= that starts with ssh then.... If Reports!! = Like "*" & "ssh" & "*" Then

I have a query which is not having any facility surgery count for current month or previous month from table. I currently run the query which will ask me for...

My database is set up to track the traffic that visit the model homes in several new housing developments. Daily I keep track of how many are potential home...