Search results

I'll take a look. The analysis of activity is interesting. It is also nice to know of the potential to report from AutoCAD. I've done some automation with other VBA programs as well. At the end of the day, at least for now, I just wanted to see if there were other programming methods...

@MarkK - Yes - Autodesk AutoCAD. I just had a discussion with one of our drafters. She said she mostly uses model space, not Viewport. So I am trying to wrap my head around how to insert a time based on the use of the active Viewport. I'm going to guess I could probably trigger a code from...

@MarkK - I like the user activity suggestion. However, a lot of the users log in and minimize while they work on other things. Most of them are CAD drafters. So the database is minimized, clocking time while they work. They occasionally pop in to the database key in the job number they...

@JLCantara - Really good idea - I already have the setup you suggest - a blank logout record created on login. The code finds the login record for the user on the date and inserts the logout time via SQL from the hidden sign-on form Close Event. So you suggest using the timer to update the...

Again, I appreciate the ideas you suggest. Recently a user stay logged in overnight and I was unable to perform exclusive functions after hours because of this so closing the database with a timer event is a nice suggestion for some users. The reason the database captures the user's logout...

Thank you for the reply. You are suggesting I adjust my code to handle a proper shutdown in the case of forced shutdown? That's a good thought. Thank you.:) A sudden loss of power causing computer shutdown wouldn't give programs a chance to close properly. However, I was thinking about the...

When users successfully sign into our database, the sign-on form is hidden in the background. This sign-on form contains a code that executes with the On Close Event. (This code logs a time in a table to capture the time the user logged out.) Previously, the Log Out button on the main form...

Actually, I have found my answer in the meantime. Thank you for being willing to help. This is what I used: SELECT OD.CalYear, OD.[Employee Name], OD.ID, OD.WorkDate, OD.ContractNo, OD.TotalTaxableWages, OD.TotalTaxableWages (SELECT Sum([TotalTaxableWages]) FROM qryWagesOnly WHERE [Employee...

As far as the minutes the Dsum option takes, I needed to walk away from my PC and come back to see results. To me, this would not be optimal for an on-the-fly report I need to run by either employee or job number. Others will be using it, as well. Other times, the Dsum query locked up...

I need help creating a query with a running sum (cumulative total) across two categories. I need to accumulate Wages by employee, by calendar year for every day/every job worked. I have a table containing over 33,000 records, the years span from 2009 to 2014 with multiple employees. The Dsum...