Search results for query: *

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;

TheAceMan1 - kkalin didnt reply, but I need the same thing. The example is below: Firearms qualification database. The main form has the personnel information (name, address, etc) a subform has their weapon information (make, model ,serial number, etc). I would like to be able to search for a...

I had tried the direct import to table approach and had numerous problems. Since going back to the TransferTBL and then apphending to the main table method, everything has worked great for the last 3+ years. I dont recall the problems specificly, but I have none since the change back.

Changing the Caption based on the presence of data worked great. Thanks for the different point of view on this.

dhookum, good idea...I hadnt thought of that. Focused in to much on the Caption I guess. I will five it a shot. missinglinq, I may try yours as well to see which works/looks better. Thanks

Hello, I have a request form a user to modify an existing form that contains 7 pages (tabs) with something that will change when there is data present on each page.Each page has a Caption that needs to remain visible so that users can go to it to enter data. The request is so that users dont...