Insert Data from Form

Emir_X

New member
Local time
Today, 15:11
Joined
Sep 17, 2012
Messages
2
I'm not using access very often.
I made one table and one form.
Form is made with all input boxes that are listed from the table.
So form and table are understanding each other.
I simply need to know when I save this database ass application how to save all input data in form to database (that one table).
I would like to have save button, clear button and print button in that form.
I would like that save button to work with query and bit less with vb coding.
Please help and thanks a lot. Btw I'm new here :)
 
First thing to know is that SAVE buttons are not required for Data Tables, unlike in WORD or EXCEL. Records are automatically 'saved' the moment you move onto any other record. So, in the event of a crash the most data you can lose is just one record. NB: Saving discipline does become more critical when designing Queries, Forms, and Reports.

PRINT button is a standard requirement, but you'll need first to create a REPORT based on the table data (or a QUERY based on the table) ... you can use the Query and/or Report WIZARDS to help you achieve this.

Good luck ...
 
PRINT button is a standard requirement, but you'll need first to create a REPORT based on the table data (or a QUERY based on the table) ... you can use the Query and/or Report WIZARDS to help you achieve this.

Good luck ...

Yea, thanks, but I figure that out myself today when I actually finished first version of this database interface.
I kept save button anyway so workers won't be confused.
I made query that uses record that is present in form interface and then report on that query so that solves my print button problem.
 

Users who are viewing this thread

Back
Top Bottom