473,484 Members | 1,590 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Convert a filled in form into report

10 New Member
Hi there,

I have a form that I want users to fill in and then on a button click have that information entered in the active form turned into a report. I can only find ways to export entire sections of data into reports not individual active form windows! Help anyone!
Mar 5 '14 #1
2 1932
topher23
234 Recognized Expert New Member
The best way to do this is to have your form fill in a table with a unique record ID, then when the user clicks the button, save the record and pass the record's ID number from the form as filter criteria to the report, which is also pulling its data from the same table the user just entered the data into. Forms and reports don't actually "hold" the data, the data should always be held in one or more tables. If you don't want the data saved, use a temporary table that is deleted after it is used. This is a very basic answer, but from your question it appears you might be at pre- Access 101 level. Feel free to correct me if I'm wrong on that.
Mar 5 '14 #2
NeoPa
32,556 Recognized Expert Moderator MVP
That sounds spot on to me. Well explained Topher.
Mar 5 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1300
by: William Bradley | last post by:
On the form which contains the record, I can print a single report from that form. What I would like to do now is do the same thing but select the report from any one of a dozen choices of report....
1
2150
by: Scott Sabo | last post by:
I have a form & report based on a query which shows details about employees performance reviews (hire date, review date, review submital date, etc). We do 90 day probation reviews as well and I...
2
2404
by: Gt394 | last post by:
I have a form called frm_quote and a report called rpt_quote. I want to be able to view the form on a particular quote number (field: QuoteNo - autonumber) and then go to the report where the the...
2
4340
by: BikeToWork | last post by:
I found code online which uses Windows API's to save Access reports to pdf format files. I'm using the full version of Adobe Acrobat Professional 7.0. The problem is that regardless of what I put...
0
5343
by: ghadley_00 | last post by:
MS Access Create form / report with multiple pages using different background images Hi, Would like to have users fill out a multipage form, and then click a print button, which pulls up the...
3
5889
by: Mac Campbell | last post by:
For some unknown reason my mdb seemed to drop a module I had named "Utilities". I tried to copy the module back in from a backup copy and got the error message "<<MyProject>> is currently unable to...
0
1174
by: goldxr | last post by:
Hi I'm pretty new to access and have very little VBA experience, so I apolgise if its a stupid question but I can't seem to figure this one out. I have constructed a main form with different pivot...
3
10860
by: MyWaterloo | last post by:
I am trying to open my purchase orders form and go to the last record. In the on open command I do: DoCmd.GoToRecord , , acLast Seems straight forward enough...but I keep getting this message...
3
13959
beacon
by: beacon | last post by:
Hi everybody, I'm using Access 2010, but the format for the database is .mdb because I'm not ready to fully convert it to Access 2010 and the .accdb format. I've been reading up on how to...
15
2430
topher23
by: topher23 | last post by:
Greetings all! It's been a while since I've been around - I went out and got a degree (double-concentration in English Ed and Creative Writing of all things), then went right back into a job in RAD...
0
7082
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6953
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7105
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6813
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5407
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4529
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3046
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3041
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
592
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.