Help needed please.

[jtperry]

I'm looking for charity here. I need a simple database that will "clock in" and "clock out" emergency responders when they respond to station for a call and get back from a call by simply typing in their 4 digit number or something and clicking a button/Enter. We're a small rural ambulance service on a very low budget so I'm basically begging here so I'm sorry if this isn't appropriate for this forum. I've been trying to do it myself for weeks now to no avail. I'm not computer or programming savy so if someone would simply like to advice me, any help would be greatly appreciated. Thank you!

 

[Beetle]

If you want to post back with more detail as to what the specific requirements of the application are, or if you currently have some type of functional example that you've created (even if it doesn't function the way you want) and you can upload a sample of it here with some dummy data, someone may be willing to help. We need to get a better idea of what exactly it is that you need though.

 

[Steve C]

In your table of ResponderInsAndOuts (or whatever you call your table for that) you need two Fields called TimeOut and TimeIn. Format for the fields is Date/Time.

On a form you need 2 buttons (don't use the Wizard to make them) Button1 is called "TimeOutCmd" Button 2 is "TimeInCmd" You also need TextBoxes for TimeIn and TimeOut.

In the OnCLick event of TimeOutCmd, in between the two lines Access adds for you when you choose Code Builder, add the following code

TimeOut=Now()

What'll happen is; when you click the Button, the TimeOut field will now have the time now.

Do the same with Time in

You will get a much better answer when you put in your example. But When I started on here I didn't know how to do that (still don't).

 

[jdoathout]

I have a medical Dispatch system that I can send to you if it would help. The system tracks the drivers, their status, time in time out, their qualifications, Vehicles and Maintenance, Passengers, and all sort of statistical data in reports for grant justifications.

Just let me know.