Report Header Information 1

[RMForlenza]

I have a report that lists repetative information on each page, Author, drawing no., revision no., project no. and date.

I currently have them configured as parameters that are prompted individually during report creation.

I would like to configure one of two solutions that will make this more user friendly. The first would be a single form to enter the parameters that are used on the report. The second method be to import the parameters from a separate file. Can anyone assist with this?

The form being is a parts list generated from data exported from autocad.

 

[dhookom]

Check this link

http://www.fontstuff.com/access/acctut08.htm

to find out how to use controls from forms.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

I have a form created to generate the report.

The report pulls data from a table, tblAppList.

The header information, is listed in a table, tblProjData, that contains one record.

I select the project record based on a combobox that looks at a query of the project table. Then I have a command box that generates a report, but I can't seem to configure the project data to print on the form.

Initially I had the text box listed as '=[MadeBy]' which resulted in a parameter prompt for MadeBy. I then tried to build an expression as '=tblProjData!DRAWN', but that resulted in a parameter prompt for 'tblProjData'. What am I doing wrong?

 

[dhookom]

1) forms don't "generate the report". A control on a form can be used to filter the records in the report
2) Reports should pull data/records from queries
3) I don't understand what you mean by "header information"
4) "print on the form"... are you not printing a report?
5) I am lost with "text box listed as '=[MadeBy]'
Text boxes have many properties. Was this text box on the form or report?

Do you have a form with controls to provide criteria for your report? What are the names of the form and controls?

What is the SQL of the record source of your report?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

I am using a control on a form to create the report, as was suggested by other posts.

The report pulls the 'listed data' from a query, queAppList.

Header information is 'record independent information' or header information, that is used to populate the page format, as described in my initial post.

Currently we have the data entered into the text boxes as parameters, =[MadeBy] and when the report was run answered multiple individual "parameter value dialog pop-ups".

I am attempting to automate that process. I have generated a second table, tblProjData, that has a single record with a number of columns that contain the 'header information'. I can't seem to pull this information onto the report.

 

[dhookom]

Do you want values entered into controls on the form to filter/limit the records in your report?

To get data from your one record table to appear in your report, just add the table to your report's record source.

I get a little retentive so please excuse my corrections/misunderstandings:
1) "a control on a form" can't "create the report"
2) "=[MadeBy]" might be a control source on a report or form but will not limit records.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

I want the values entered on the form to complete 'text fields', parameters in access verbage, on my report 'header'. They are not filtering or limiting the report.

I am attempting to get 'dumb' information onto the report that will be the same for each page of the report, normally 5 to 6 pages.

We are using the database repeatedly, changing the databases records with each project. The 'front end' is always the same. I export data from autocad and import the data into access. This creates a parts list. That data does not contain project information, customer name, project number, date, revision, document number, etc. that is independent of the dataset.

I can enter the project in one of two ways, 1) manually on a form or 2) as a second table conisting of one record with multiple fields. My difficulty is getting this information to appear on the report that is generated from the other table of records.

 

[dhookom]

Did you understand and try: To get data from your one record table to appear in your report, just add the table to your report's record source?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

Honestly, I was not clear on that but was attempting to research it.

Can a report have two record sources?

 

[dhookom]

A report can have only one record source. If your "header" table has only one record then you can simply add it to the existing record source query for your report.

There are other ways of including information from other tables/queries including subreports, row sources of combo or list boxes, domain aggregate functions, and code.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

I imagine that to be the reason that I can't seem to accomplish it then.

My issue stems from the fact that 90% of the report is generated off one record source and the remaining 10% is from a second source. I have no real way of creating a relationship between them.

I toyed a little with subreports, but didn't have much success. Is there any way to get you the files for review?

Thank you for your attempts to find resolution to this.

 

[dhookom]

Isn't one of your record sources only one record or limited to only one record?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

One table/query has 1 record with 13 fields and the other table/query has 100 records with 10 fields.

 

[dhookom]

Then, it doesn't make any difference if they are related or not. You can create a query with both of these without any join lines.

Select tablequery1.*, tableWithOneRecord.*
FROM tablequery1, tableWithOneRecord


Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

I guess that I'm a bit ignorant as to how to decipher your instruction here.

I have two tables tblCompList (150 records) and tblProjData (1 record). I currently have two queries queAppList (100 records) and queProjData (1 record). My report is rptAppList primarily based on queAppList.

How do I create the query with both tables? Do I do it from the design view?

 

[dhookom]

Change the Record Source property of your report to:
[tt][blue]
SELECT queAppList.*, queProjData.* FROM queAppList, queProjData[/blue][/tt]

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[RMForlenza]

That worked perfectly. Thank you for all your effort. You have been extremely helpful.

 

[dhookom]

Glad to hear you have this working. Keep in mind that this only works if one table has only one record.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]