Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by CaptainRon
-
Converting "short time" to minutes
Lots of ways! If you are just interested in minutes, I'd do this: timeused=Int(([EndTime]-[StartTime])*24*60) or rather timeused=Int(([EndTime]-[StartTime])*1440) Jeffrey Bell jbell@westlakegrp.com- CaptainRon
- Post #4
- Forum: Microsoft: Access Other topics
-
Break Apart Name Field
Here's some code I threw together if you want to eliminate a few steps! (Always backup the table before trying it) Open a new form and paste this into a command button. Change the names of the table and fields and run it. Hope this helps! Dim dbs As Database Dim rst As Recordset Dim FirstBlank...- CaptainRon
- Post #6
- Forum: Microsoft: Access Other topics
-
Right click
No prob! Try this in the text box MouseDown event: DoCmd.OpenForm ("Name of my form") DoCmd.CancelEvent (The CancelEvent prevents the normal right-click menu from popping up)- CaptainRon
- Post #2
- Forum: Microsoft: Access Other topics
