Hello All,
I have a form that is half autofilled and half filled out by manually typing information in. I have a print button that generates the form into a report and gives the option to print. The manually information is not showing in the report view and is not printing. The manually boxes are typed into an "Unbound" box.
--hopefully I will not have to create a complicated table that will draw info from another table as well as hold new information thats entered in the form.
**Need information to print, do not need manually typed info saved in access.
Thanks in advance!
Rob,
Please take a look at the attached DB. I created a very simple table with a few fields and a few records. A form based on that table, with a couple unbound text boxes. A query based on the record currently being shown in the form, with the unbound fields included. A report with the same fields as found on the form. Just remember to set the unbound text boxes to the field names in the query. Clicking the print button will bring up the report.
Does this get you pointed in the right direction?
8 2351
Rob,
Is this "report" just printing the form, or is it an actual report created in Access? If it is a Report, then it will need a record source, whether that is a table or a query or something else. It might be possible to create a query based on all the unbound controls on the form, but it may be simpler to create a table underneath that form.
I don't think your solution will be too very complicated, as manually entered data on a form CAN be used in queries and then on reports. I would just hav eto see how the data is being kept on the form....
Twinnyfo,
The printing button is linked to a report. When the print button is pressed a report opens up in access and the information that was in the form is supposed to be what's printing. Everything except for the manually entered data is printing (showing in the report).
The record source of the form is linked to a query which is populating the automated fields out of my "tblMaster" (as we discussed in the past).
The manually entered data is always going to be temporary, because it is not "saved" anywhere in the database. What is the recordsource for the report? The same query used for the form? You will need to marry up the query underlying the form with the data entered on the form.
Again, this is typically not the best practice when building tables, forms and reports.
The record source in the report is the tblMaster and the record source in the form is a query that just references the tblMaster. I honestly don't know why I have it set up like this but looking at it and telling you this makes me feel like an idiot because there is no way that can be right. Can you please advise on what it should be...
With Appreciation,
Rob
Rob,
Based on your description, your report should be based a query built on the table AND the form. When you are building your query, you will be able to declare one (or more) of your output fields as controls on the form. Use this Syntax below for your output field: -
OutputName: Forms![frmFormName]![txtControlName]
-
This will give you an output field in your query called "OutputField", but its value will be based on the control "txtControlName" on your form called "frmFormName"
Hope this helps.
Twinny,
Could you provide a bit more detail? I have the query somewhat set up but I am not sure exactly what the SQL should look like and the correct way to incorporate the code you sent.
Where is the output field in the query?
Thank you for your patience and help!
Rob,
Please take a look at the attached DB. I created a very simple table with a few fields and a few records. A form based on that table, with a couple unbound text boxes. A query based on the record currently being shown in the form, with the unbound fields included. A report with the same fields as found on the form. Just remember to set the unbound text boxes to the field names in the query. Clicking the print button will bring up the report.
Does this get you pointed in the right direction?
GOT IT! The code worked like a charm.
THANK YOU!!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Support4John |
last post by:
a2k (9.0.6926) SP-3 Jet 4.0 SP-7
Does anybody have US Accounts Payable Miscellaneous Income Form
1099-Misc report object they want to share?
Thanks, John
|
by: RC |
last post by:
I can't quite grasp the concept of creating custom reports depending
upon what options a user picks on a Form. For example, the user
clicks on a "Print Reports" button and a Form pops up. On the...
|
by: Mike |
last post by:
I have to pass a date from a form to a report query. I have written a
query that works fine when I execute from SQL view, But I dont know
how to pass a value from the form to this query.
SELECT...
|
by: Apple |
last post by:
May anyone can teach me how to use form to set report parameter, my
design in FORM is :
From to ,
Customer ID from ,
Index on
|
by: Louly |
last post by:
Create a form to enter report criteria? Anyone can help me with this?
I don't want to do it using the Macros method. Is there a way to do it
using VBA?
Thanks for your cooperation.
Louly
|
by: Brian Tkatch |
last post by:
Been trying to figure out how to show borderless forms indside an MDI
Form, without showing the border at all.
Given that (in our case) only one such form needs to show at a time, we
were able...
|
by: timgeitz |
last post by:
I have a church database set up with multiple forms and reports. I would like to have the user input their own church name, address, etc. into a form which is stored in an underlying table and which...
|
by: Dave |
last post by:
On my form I have combo boxes. These combo boxes, after updating
them, populate respective listboxes that are located below the combo
boxes on the same form. I am trying to use a "generate...
|
by: PotatoChip |
last post by:
I am working in Access 2002 and I have been asked to create a form for a report based on a paramter query so that the user selects the department from a drop down list on the form, query runs and...
|
by: fartash |
last post by:
i have a command button on a form which opens report maximizeed form is also maximized with which i dont want
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
| |