Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / February 2007

Tip: Looking for answers? Try searching our database.

Timestamp Entry

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brianelowry@gmail.com - 26 Feb 2007 22:33 GMT
This may be the wrong place, but I was thinking this could be done
with access.

I want to create an entry log that automatically time/date stamps each
entry to be used in an emergency response situation specifically for a
hazardous materials incident.

What I want is for a text box to be available for me to type in:
"Entry team A enters hotzone", I hit enter, and it creates a "log" an
automatically places a time/date stamp in that entry. It would
continue to add to the log each time I made a new entry.
If this is possible, I'd like to expand it slightly to have tabs like
you can do in an excel workbook.

Is access the right tool for this? I have little experience with
Access, so I'd have to fumble my way through it, but I need to know if
this is the right place to start.

Thanks in advance
Damian S - 26 Feb 2007 22:51 GMT
Hi Brian,

Access is definitely a good tool to handle this.  You could have a date/time
field that autopopulates using =now() as the default value, with a text box.  
Have it on a continuous form so that you can see all the entries for that
Incident.

Use tables like this:

tblIncident
IncidentID autonumber
IncidentName text
etc

tblIncidentLog
IncidentLogID autonumber
IncidentID number (maps to IncidentID above)
IncidentLogDateTime date/time
IncidentLogEntry text
etc

Hope this helps.

Damian.

> This may be the wrong place, but I was thinking this could be done
> with access.
[quoted text clipped - 15 lines]
>
> Thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.