Marie Floury
asked on
How to create a report from unbound form values
Hi everyone,
I am using Microsoft Access 2016 on Windows 10.
I have an unbound form which gets data from various tables and queries and does calculations on that data. The results of these calculations are then used to populate text boxes on the unbound form. I would like to print this calculated data, from what I have read so far I think I should be creating a report and then printing that? Assuming that creating a report for printing is the correct way to proceed (if there is a better way, suggestions gratefully received)...
My question is, how do I create a report that is not based on a table or query, but instead uses selected values from my form.
Thank you in advance :)
I am using Microsoft Access 2016 on Windows 10.
I have an unbound form which gets data from various tables and queries and does calculations on that data. The results of these calculations are then used to populate text boxes on the unbound form. I would like to print this calculated data, from what I have read so far I think I should be creating a report and then printing that? Assuming that creating a report for printing is the correct way to proceed (if there is a better way, suggestions gratefully received)...
My question is, how do I create a report that is not based on a table or query, but instead uses selected values from my form.
Thank you in advance :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, I am back to work!
It is just a single page report, in fact there are only 9 fields of data. (See attached screenshot)
I am using a form as I have a command button used to initiate an import of a csv file, allowing the user to select the file and location. Then use combo boxes to select the month and year used to query data from the csv and do a USD to EUR fx, calculate fees etc...
I have decided to launch the form from a "Print" button on the original form.
I saved my form as a report, but it was blank (may have been me clicking the wrong option, I am working in a French version of Access!). Anyway, I added fields and set the Control Source to point to the original form and that works for the text boxes. Unfortunately I can't seem to get the listbox to show data from my original form. It is probably something silly but do you have any ideas as to what I could check to get this listbox to show my data?
Scott, I was also interesting in your suggestion, which if I understand is to bind my report to a table or dataset I create from my calculated data? I don't think a table would work well as the number of columns and the data types are not the same? I don't know much about datasets, would a dataset work well in this situation?
Thank you
ScreenShot.jpg
It is just a single page report, in fact there are only 9 fields of data. (See attached screenshot)
I am using a form as I have a command button used to initiate an import of a csv file, allowing the user to select the file and location. Then use combo boxes to select the month and year used to query data from the csv and do a USD to EUR fx, calculate fees etc...
I have decided to launch the form from a "Print" button on the original form.
I saved my form as a report, but it was blank (may have been me clicking the wrong option, I am working in a French version of Access!). Anyway, I added fields and set the Control Source to point to the original form and that works for the text boxes. Unfortunately I can't seem to get the listbox to show data from my original form. It is probably something silly but do you have any ideas as to what I could check to get this listbox to show my data?
Scott, I was also interesting in your suggestion, which if I understand is to bind my report to a table or dataset I create from my calculated data? I don't think a table would work well as the number of columns and the data types are not the same? I don't know much about datasets, would a dataset work well in this situation?
Thank you
ScreenShot.jpg
ASKER