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?

This post differs in that the other asks about parameters for a different subset of my database (i.e. lookup fields on a Report vs. input fields on a Form). I cannot figure out how to complete a thread, but take the time to thank each person who replies and increase their reputations so that I...

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 have several queries because the data is in different tables and is unrelated. The parameter I used is customer number and I did that for all the queries. When I run just the queries individually, they return just what is entered by the user...it is only when I run the report that the...

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!

If we do it as a subreport does that mean it won't all show up on one report? I will do the tutorials first thing tomorrow morning...thanks for being a great teacher and for your help

Does that mean I don't have to have joins and/or primary/foreign keys?

Table Name Description____________________________ Credit % to Sales Credit Data by Customer # Customer Database List by Customer # and Their Address Offenders by Group Type of Offender by Customer # Shipping...

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

Well that would explain many things! lol What is the purpose of joins? What data would you join together in the query? There is no Record Source in Access 2010 that I can find...only a "Control Source". Is that the same thing?

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

Ok, I made the query so that all the data from all the tables is queried...what's the best way to link it to the Form (where the user enters the customer number) and the report (that previews the data)?

AWESOME! I got it! Quick question, there are 7 tables pulling into this report...can I use the macro builder to include them all? In other words, data from each of these 7 different tables is populating into different parts of my report. How do I update the macro to make sure all the lists...

Like this? Private Sub Command5_Click() On Error GoTo Err_Command5_Click Dim stDocName As String stDocName = "Report1" 'DoCmd.OpenReport stDocName, acNormal, , "[ID] = " & Reports frmText7!ID DoCmd.OpenReport "Report1", acViewPreview, , "[Customer] = " & e.Text4 Exit_Command5_Click: Exit Sub...

Please see attached...