Register Blogs FAQ Awards Members List Calendar Search Today's Posts Mark Forums Read

Go Back   DeveloperBarn Forums > Databases > Microsoft Access
Reload this Page keep time and date

Sponsored Links

Discuss "keep time and date" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.


Reply « Previous Thread | Next Thread »  
 
LinkBack Thread Tools Display Modes
  #1  
Old August 14th, 2008, 05:33 PM
Barn Newbie
  
Join Date: Jul 2008
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 1
javier_83 is an unknown quantity at this point
Default keep time and date
Hi people i need all your help!!

i have a login form, that i enter my username and password, and then i enter to my main menu!!

well my question is, how cabn i create a history table, so i can have wich person enter to the sistem

i make another table

- id_user
- username
- time
- date

so if someone can help me please!

thanks to all!
Reply With Quote
Sponsored Links
  #2  
Old August 14th, 2008, 05:53 PM
jmurrayhead's Avatar
The Barnfather

  
Join Date: Mar 2008
Location: Reston, VA, USA
Posts: 820
Thanks: 20
Thanked 74 Times in 71 Posts
Blog Entries: 5
Rep Power: 3
jmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura about

Awards Showcase
Microsoft SQL Server Microsoft Windows Microsoft .Net Classic ASP 
Total Awards: 4

Default
What exactly do you need to know how to do? This is done easily via an INSERT SQL statement. Simply run the statement when the user logs in and you have a history of each time.
__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

Join our Folding team: DeveloperBarn Folding
Reply With Quote
  #3  
Old August 14th, 2008, 06:16 PM
Barn Newbie
  
Join Date: Jul 2008
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 1
javier_83 is an unknown quantity at this point
Default
Quote:
Originally Posted by jmurrayhead View Post
What exactly do you need to know how to do? This is done easily via an INSERT SQL statement. Simply run the statement when the user logs in and you have a history of each time.

im really bad for coding, because im a rookie on this

do you have an example???

or some page i can read to learn how to do this??
Reply With Quote
  #4  
Old August 14th, 2008, 07:39 PM
jmurrayhead's Avatar
The Barnfather

  
Join Date: Mar 2008
Location: Reston, VA, USA
Posts: 820
Thanks: 20
Thanked 74 Times in 71 Posts
Blog Entries: 5
Rep Power: 3
jmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura about

Awards Showcase
Microsoft SQL Server Microsoft Windows Microsoft .Net Classic ASP 
Total Awards: 4

Default
Here's a great place to start: Insert Into Query
Reply With Quote
  #5  
Old August 15th, 2008, 05:49 PM
Barn Newbie
  
Join Date: Jul 2008
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 1
javier_83 is an unknown quantity at this point
Default
i finally did it!!

thanks i use this cod

Quote:
ok i did it

i use this


Quote:
Private Sub cmdEnter_Click()
On Error GoTo Err_cmdEnter_Click
Dim rst As DAO.Recordset
Set rst = CurrentDb.TableDefs("historialacceso").OpenRecords et
rst.AddNew
rst!Username = Me.cmbLogin
rst!Fecha = Now()
rst!Hora = Now()
rst.Update
rst.Close
Set rst = Nothing

Exit_cmdEnter_Click:
Exit Sub
Err_cmdEnter_Click:
MsgBox Err.Description
Resume Exit_cmdEnter_Click
End Sub
Reply With Quote
  #6  
Old August 15th, 2008, 06:00 PM
jmurrayhead's Avatar
The Barnfather

  
Join Date: Mar 2008
Location: Reston, VA, USA
Posts: 820
Thanks: 20
Thanked 74 Times in 71 Posts
Blog Entries: 5
Rep Power: 3
jmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura aboutjmurrayhead has a spectacular aura about

Awards Showcase
Microsoft SQL Server Microsoft Windows Microsoft .Net Classic ASP 
Total Awards: 4

Default
Glad I could help point you in the right direction

We encourage members to click these icons after being helped: and
Reply With Quote
The Following User Says Thank You to jmurrayhead For This Useful Post:
javier_83 (August 15th, 2008)
  #7  
Old August 15th, 2008, 06:03 PM
Barn Newbie
  
Join Date: Jul 2008
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 1
javier_83 is an unknown quantity at this point
Default
just did it, thanks!
Reply With Quote
Reply

  DeveloperBarn Forums > Databases > Microsoft Access

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[JavaScript] JavaScript Date & Time Display jmurrayhead Code Samples 0 August 13th, 2008 08:46 PM
Time Entry Form sbenj69 Microsoft Access 2 July 14th, 2008 02:11 PM
[ASP.Net/C#] Display Assembly File Date And Time Wolffy Code Samples 0 April 9th, 2008 11:57 AM
Site Down Time jmurrayhead Announcements 0 March 30th, 2008 09:42 AM


All times are GMT -4. The time now is 05:18 PM.

Contact Us - DeveloperBarn.com - Top


Content Relevant URLs by vBSEO 3.2.0