Recent content by Countymnca

I understand this is the nature of dealing with time and rounding. This is a display/human problem. The darn timesheet doesnt even total the hours by the day, but people still look at it and then report a bug when .33+.33+.33 doesnt add to 1.00. I also think it is a timesheet report item and...

Below is an example of what the timesheet looks like: The total time for each project on each day is summed and displayed on one row. There is no daily total for the day, displayed on the timesheet or in the data. Wed Thur Fri Total Project...

Hello, I have a tough one that I cant seem to solve. Below are the details: We have a 3rd party vendor SQL app that does time and attendance (among other things) and our employees track their time via project codes depending on what they are working on. The problem I am having is that when an...

That did it! Thanks!

Hello, I am having a very hard time trying to get a problem resolved. I am pretty sure a CASE Statement is what I need to use in the WHERE clause of my Query, but I am not getting it to work. Below is an explaination of what I need to the query to do. I work for a pretty large organization and...

Majp that did it. Thanks!!!

AceMan, I am aware of that problem, but am not really concerned about it. Checks are required every 10 minutes, so even if it resets at midnight, it only takes 10 minutes before they are out of compliance anyway. I will fight with it a bit more later today. I will try to get it working with...

Either I am missing something or I didnt give you the entire story. The text boxes display times retrieved from a table but they are not bound (=DMax("[Room1]","[LogTable]","[Date]=Date()") is what I use to pull the last time). The form is set to refresh every 5 minutes now since more than...

Hello, I need to change the forecolor of a box that displays the last time an entry was made if the time is greater than 10 minutes ago. I have changed form and text box properties before with a timer and have gotten the Datediff function calculating the difference in time (minutes) between...

The reason I am looking at 2007 is because all the other departments have 2007. I am willing to consider 2010, but I really doubt this will happen. I have seen migration models that others have done with a 1 for 1 server change out that will be in the 4-5 million range. Even if I could go with...

Hello, Tek-tips has come through before (other forums) so I figured I would give this a shot while searching for more information. I have been tasked with looking at migrating our existing 36 site/server Groupwise network to Exchange 2007. Most sites have only T1 connection and we are moving...

Duane, Thanks for the reply and solution. Works as it should.

Hello, A request has come in to modify an existing and working function that generates a report based on one text field on the form. Occasionally, there are 2 or more records that have the same text value [CustNumber]in this field, so multiple reports are created. I have been attempting to add...

Works Perfect...thanks!!! I will read up on what you did so I understand it. A star for the help.

TheAceMan1 - Here is the info you requested and thanks for the help! 1. WeaponSFRM 2. cboWPNsnSearch 3. EmpID Text 4. WSerialNumber Text 5. SELECT [WeaponTBL].[EmpID], [WeaponTBL].[WSerialNumber] FROM WeaponTBL;