Search results

On my report, one of my subreports keeps growing and pushing everything down the report. How do I get this to stay the same size as it is on the Report in design view?

I built a database and the user enters a customer number and a report generates for that customer. The issue I have is that after the user enters the customer number, Access displays a parameter request for the text box on the Form the user enters the customer number in/on. (Please see...

Good morning everyone...I am just about done with a large project for someone of my limited skillset with Access. The last thing I have to figure out is how to stop Access from prompting a user for a customer number for each subreport (i.e. parameter). :mad: It also asks me to enter my...

I created a report that generates via several queries after a user enters a customer number and clicks a button. The problem I am having is that instead of just running, Access asks for each parameter to be entered individually by the user. I set the queries up with criteria so that just the...

Hi everyone...I am making GREAT progress. Thanks for all your help so far. I am trying to load my last table of data into my report via a subreport. I attached my data source (Excel sheet) and also a screenshot of what the error message is (Application-Defined or Object-Defined Error). The...

Hi everyone, have a sample table that I want to create a form for so that user's can enter a customer number. After the user has entered the number, I want them to click a button that automatically generates a report showing just that customer's data. I have the form, query and report all...

I just got the following error... "Cannot Record Changes Because A Value You Entered Violates the Settings Defined For This Table" I just have a one table report that is taking an account number entered by a user and running it through a query that generates a report. Any help would by great!

I am relatively new to database design but VERY interested! I have a new project I am working on and am trying to figure out joins. In my attachment I have the tables joined with type 2 and 3 joins. Each of my tables contains data I need for a report. I keep getting an error message about...

I have a Form >>> Query >>> Report setup and when I run the query it won't populate my Report and display that to the user, rather it just shows its' own query output. What do I need to do to have the form pass the criteria to the query and the query to pass the appropriate data to the report...

Hi, I just got off the phone with Microsoft Technical Support and the tech said he didn't know how to get my issue solved. All I want to do is have a form that a user enters a customer number into and from that a report generates showing just the information about that customer. I have...

I made a report that pulls data from many tables and, for each list in my report, Access asks me for criteria in a box. How do I set it up so that it only asks for one criteria (since all are the same - customer number) and assumes it is the same for all the other criteria?

I made a report that I want to only show data on a particular customer (based on a customer number that a user enters). How do I do that?

How do you make a text box display a value from a table?

Hi everyone...i'm stumped! I go to create a list in a report using an Access table and one of the columns (The MEMO Column) isn't available. How do I get it so that the missing column is available for population into my report? Please see attachments so you can see what I'm seeing... :)

I have a Form that users enter a customer number into and a Report is generated based off the customer's information in a Table. The problem is, when the report generates, it just puts that customer's data on the top row, but shows all the other customers data below it. I need it to only show...