Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Using time stamps


Recommended Posts

When I set up my time stamp how do i get it to automatically enter te date and time when someone opens the program. I have gone to the auto enter screen but it does not perform the task (I am using Vista) ..any suggestions?

Thanks NormanE

Link to comment
Share on other sites

File Options. You can select a script to run whenever the file is opened.


I have no idea what "the auto enter screen" might be.

Link to comment
Share on other sites

once you enter it as a container field then go up to file and click on define you will open a screen with all your fields, then to the right is a button that says specify, if you click on that you open to another screen with three tabs on top, the first is auto and that is what i clicked... but if you don't know how to get to this screen I guess you don't know how to make it work automatically do you... Norman

Link to comment
Share on other sites

Oh, I thought you meant some screen YOU had designed, sorry!


There is no auto-enter option for "auto-enter last opened". You need to script the setting of a field to Get (CurrentHostTimeStamp) and run that script whenever someone opens the file.


If you want to know the last time Joe Blow or Susie Enduser opened the file, the field should be in a "joe Blow" record and the same field, different record, for Susie Enduser has her last logon timestamp. Trap for Get(AccountName) at logon and go to that person's record and record that value.


If you want "last time any person opened the database", have a single-record file somewhere and punch Get(CurrentHostTimeStamp) into that single record each time anyone opens the file.


If you want a log of who logged in when, make a new record at each logon, and set User to Get(AccountName) and logon datetime to Get(CurrentHostTimeStamp)

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use