Transfer data from form to another form
Thank you for taking the time to report an issue.
What's wrong... Please write below.
So I have this form that I created and it has a list of textboxes for words and number data. I would like to transfer this data to a report. I want the report to pretty much look like an excel template with a table. I want the data from the form to be transferred to the report at a push of a button. However, I have no idea where to start. So where do I start? And is there any programing involved in this
A continuous Form has records of Loans Issued on a Date.
It includes how the funds were issued and this works fine where One transfer was done.
Where there may be two or more funds transfer records, it would be handy to have a 2nd or third row in the form (and report) that displayed the additional data. This would be like a sub form to a continuous form.
Is there any way to achieve this ?
If there was just one Loan Issued each day then a Main Form and numerous Sub Forms would achieve the result but with multiply loans then ?
This would be like a 2nd line of description in a price list
How can I capture data input from a scanner without displaying it into an actual text box. If a barcode with certain text in it is scanned, I want the form to transfer control to another form for further processing.
Or, must I enter the text into a hidden field for the purposes of capturing the data first and then using the Timer Event ot process it? I use the Form_KeyPress Event to see if that would capture the data input, but it does not do that. What event would capture data input from a barcode device without having to display it on a form?
1. SAVE the data upon click of button and CLEAR all fields for new data entry
2. I noticed that when I press the ENTER it will do same action as clicking my button. I tried the "on Enter event" and create a Message Box when Enter is pressed. it works, but when I press Enter again. it will proceed with the data transfer. I want to DISABLE the Enter command to transfer the data. I want the user to use the Button Only to transfer the record
I first add a new customer, giving him a unique CustomerID and his/her details. Then I press a button named Add Order to open up a form. My problem is on how I could transfer the current CustomerID to the second form
I am trying to use an old Excel form that I have in the computer currently. I need to transfer this form to Access. I want to be able to collect data on that form and revisit the collected data some time in the future.
The Excel form has the company logo on it and the layout is perfect for what we use it for.
I can't believe this a really difficult thing to do, I just am not familiar with this kind of computer stuff
So if a specific Employee takes out 4 aprons from a total of 50 and there are now 46 left, I would like the submit button to transfer that data over accordingly to Inventory control form in the correct text boxes.
Specific Example: If employee John Doe takes 4 aprons from a total of 50 which now leaves 46 how can I transfer that data into the other form showing specific information like 'Product ID' taken, 'Date' it was taken, 'Product Description', 'Employee' who took it, 'Amount Taken' and, 'total' left. I need the extended information to show up in the text boxes on form 2.
Is there a certain code that does this? Here are screen shots so you can get a visual
One important thing to note is that the receiving table will have existing records so I need to make sure these existing records stay intact and simply adds the query data as a new record.
Any advice on the best approach for this?
I have a feeling it's by using macros but I'm unsure.
If it is would it simply be the case of recording the copy and paste of data from the form to the table?