473,548 Members | 2,716 Online
Bytes | Software Development & Data Engineering Community
+ 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 1936
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,564 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
1306
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. This is due to the variables in the manufacturing process that this database records. When I print the single report, it is simply a bin label...
1
2157
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 want to be able to indicate employees who have a hire date that is within 90 days of the current date and highlight their records in the form and...
2
2410
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 info on that particular quote no. is shown in the report. frm_quote is linked to query: qry_viewquote rpt_quote is linked to: ...
2
4352
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 in the code as a filename it automatically saves the report based on the report name instead of the string passed to the registry key. The code is...
0
5354
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 info just entered for a particular record and print out multiple pages of forms, each page having a different image as background.
3
5893
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 rename the form, report, or module to 'Utilities' ... Close the database, reopen it, and try the rename operation again." This didn't work. It seemed...
0
1181
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 tables and pivot charts which are inserted as sub forms. I made a report for each pivot chart form for printing purposes and inserted a command...
3
10868
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 "You entered an expression that has invalid reference to the property Form/Report" before the form opens. After I acknowledge the message the form opens...
3
13976
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 create Shortcut Menus in Access 2010 using VBA and I'm pretty confident I understand how most of it works...meaning that I can create a custom shortcut...
15
2448
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 development, cleaning up a pile of existing Access applications and massaging them into a custom ERP system. But enough about all that. I'm...
0
7518
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7444
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7711
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7954
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7467
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6039
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5367
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3497
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1054
muto222
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.