If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simple database with a simple form
Hello all. I'm new to the board, and fairly inexperienced with Access. I am trying to build a simple database that tracks the time it takes to start an order, and finish it.
Simply put, I have a database with the following: Order Part Start Stop I'm trying to build a form that has the following Order - Manual entry Part - Manual engry Start - Date and time stamped into this field when button is clicked. Stop - (this can be a day or so later) Date and time stamped when button is clicked. Like I said before, I'm pretty inexperienced at access and dont have any experience in Coding. I have a little understanding in SQL. I know this is such a simple chore to someone with experience and wonder if anyone would take the time to lend a helping hand. Thanks in advance, j0ker21m. |
#2
|
|||
|
|||
Simple database with a simple form
"j0ker21m" wrote in message
... Hello all. I'm new to the board, and fairly inexperienced with Access. I am trying to build a simple database that tracks the time it takes to start an order, and finish it. Simply put, I have a database with the following: Order Part Start Stop I'm trying to build a form that has the following Order - Manual entry Part - Manual engry Start - Date and time stamped into this field when button is clicked. Stop - (this can be a day or so later) Date and time stamped when button is clicked. Like I said before, I'm pretty inexperienced at access and dont have any experience in Coding. I have a little understanding in SQL. I know this is such a simple chore to someone with experience and wonder if anyone would take the time to lend a helping hand. Your "start" command button would need the following code in its Click event: Me.txtMyStartTextBox = Now() where txtMyStartTextBox is the name of the appropriate text box on the form. You can duplicate functionality for this the "stop" button with name changes. You'd probably need some code to make sure that the user clicks the buttons in the right order in your form's Current event. HTH - Keith. www.keithwilby.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form, Subform, Tab key | 2nd_Stage_User | Using Forms | 17 | August 25th, 2006 12:30 AM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |