home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Webmastering and Programming
Join TechIMO for Free!
Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
Reply Get bargains at  »  Dealighted.com
 
Thread Tools
Currently Active Users: 2888
Discussions: 188,379, Posts: 2,243,460, Members: 232,607
Old September 13th, 2002, 12:29 PM   Digg it!   #1 (permalink)
Member
 
Join Date: Nov 2001
Posts: 177
Access / Automatically generate a report from a form?

Is there anyway to automatically generate a report from a form? I'm trying to customize an app so whenever you enter a new record into a form, you can click on a button to save the new form and automatically generate a new report based on the info from the recently created form. I already have the layout of the form saved as a template, and I have all the current forms linked to the current reports. I don't, have a table created, is that what I'm missing?

Turnip12 is offline   Reply With Quote
Old September 13th, 2002, 12:54 PM     #2 (permalink)
Thaumaturge Member
 
howste's Avatar
 
Join Date: Oct 2001
Location: West Haven, Utah
Posts: 12,671
If I understand what you're doing, it seems like what you would want is one form and one report. When you enter data into the form, you would have a button open the report and filter the data to display only the record you just entered.

Am I close?

howste is offline   Reply With Quote
Old September 13th, 2002, 01:15 PM     #3 (permalink)
Thaumaturge Member
 
howste's Avatar
 
Join Date: Oct 2001
Location: West Haven, Utah
Posts: 12,671
Re: Access / Automatically generate a report from a form?

Quote:
Originally posted by Turnip12
I don't, have a table created, is that what I'm missing?
I must have missed that part the first time I read this. You would need a table to do what I was talking about. The form would be linked to the table. When you enter the information into the form, it's stored in the table. The button would open the report (also linked to the table) and display the information from the form.

howste is offline   Reply With Quote
Old September 13th, 2002, 01:54 PM     #4 (permalink)
Member
 
Join Date: Nov 2001
Posts: 177
Thanks for the replies, yes that's what I'm trying to do. So in order to do so, just create a table with the fields I want on the report/form and then link the the forms and reports to the table? For the button do I need to use VB to generate the reports, or is there an option somewhere. I stumbled across the autoreport option, but I'm new to Access and I wasn't sure if that's what I'm looking for.
Turnip12 is offline   Reply With Quote
Old September 13th, 2002, 02:11 PM     #5 (permalink)
Thaumaturge Member
 
howste's Avatar
 
Join Date: Oct 2001
Location: West Haven, Utah
Posts: 12,671
Once the table is there and the report is created, you should be able to use the wizard when you create the button. It should pull up a dialog box like the one attached (I'm using Access 2000). You'll then choose the report you want to display. The wizard will create the VBA code that will display the report. You'll probably have to tweak the report after that to get it to display only the record you want.

That should be enough to get you started. If you need more help, post back again. Good luck!
Attached Thumbnails
access-automatically-generate-report-form-access-button-wizard.gif  
howste is offline   Reply With Quote
Old September 18th, 2002, 02:08 PM     #6 (permalink)
Member
 
Join Date: Nov 2001
Posts: 177
Thanks for your help before, I'm hoping you'll stumble on this again (or anyone else who might be able to help for that matter) When creating the table for the forms and reports to link to, do I need to create a field for ever field on the report, or just for the text boxes? There are several text boxes on the form that I'll need to set up so the values can be changed monthly, but all of the rest; labels, logos, etc, will be constant.
Turnip12 is offline   Reply With Quote
Old September 18th, 2002, 02:37 PM     #7 (permalink)
Thaumaturge Member
 
howste's Avatar
 
Join Date: Oct 2001
Location: West Haven, Utah
Posts: 12,671
It sounds like you've figured it out. You only need to create fields in the table for the ones that will change. The rest will just be labels or pictures stored on the report.
howste is offline   Reply With Quote
Old October 16th, 2002, 02:19 PM     #8 (permalink)
Ultimate Member
 
ironforge's Avatar
 
Join Date: Oct 2001
Posts: 1,109
Send a message via ICQ to ironforge
Is there a way to make a report that draws off multiple tables?
ironforge is offline   Reply With Quote
Old October 16th, 2002, 02:40 PM     #9 (permalink)
addicted
 
DVNT1's Avatar
 
Join Date: Oct 2001
Location: Ohio
Posts: 6,103
Quote:
Originally posted by ironforge
Is there a way to make a report that draws off multiple tables?
yes, one way is to link the report to a query. Then inside the query add tables or other queries as needed
DVNT1 is offline   Reply With Quote
Old October 16th, 2002, 04:38 PM     #10 (permalink)
Ultimate Member
 
Join Date: Oct 2001
Posts: 21,019
yeah you'll need to JOIN the tables though or it'll get pretty messy.
vass0922 is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Most Active Discussions
Is It Just Me? (2885)
The United States Debt (20)
Looks like Burris will get his Sena.. (8)
I think I just killed my computer w.. (24)
Upgrading RAM (5)
Folderchat Weekday thread (439)
Antec 300 bulk purchase? (11)
Worth the upgrade?? (14)
Titan quest and Immortal Throne, an.. (17)
Recent Discussions
Help with an Ati Radeon HD 4850.. (24)
Install Problem for Windows Def.. (0)
New Build ( Finally ) (1)
dual monitors wont boot (0)
Folderchat Weekday thread (439)
MSN Hotmail Down??? (7)
Laptop waking up itself (0)
CPU wont boot (3)
Best digital camera for under 2.. (13)
Blackberry Storm, Gears of War .. (1)
Core 2 Quad Q9550 system (3)
COWBOOM Ripoff! Used Laptop w/$.. (4)


All times are GMT -4. The time now is 08:34 PM.
TechIMO Copyright 2008 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28