Search results for query: *

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...

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...

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...

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...

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...

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...

Hello, I am sure this is easy, but my brain is fried today. What I need to do is insert a 0 into the following text string 3 places in from the right. CCNNNNNNNN C= Character N= Number The new format will be CCNNNNN0NNN. I will only be inserting 0's as we are converting from the old layout...

Hello, I have a db that tracks employee movement (promotion, demotion, transfer, resign, rehire, etc) within a large organization. Each movement is recorded by the employee number, date, type of movement, and new position number. Initally I created a query that is supposed to pull the Last...

Hello I am looking for some opinions of those more advanced than I prior to jumping into a possible solution. A db (Access 2003) exists on one server within my dept. It is accessed by a group of remote users 80 miles away via an intranet as well as users in the same building as the server. As...

Hello, I am having trouble getting the following to work on a report. Unit is a text field and I need the max value in the Ending column from the query to link with the unit number in the report. =DMax("Ending","EndingMilesQry","'Unit' = '" & Reports!AvgMileagePerMonthByUnit.Unit & "'") The...

Hello, I frequently import data from Excel using transferSpreadsheet and then process it using several queries. The primary key field comes in as A-01001001 or AA01001001 and then has the - removed if it exists before the data is apphended to the main table. The problem is that occasionally, the...

Hello, I have seen several threads (thread701-1167093) that have me pretty close to fixing my problem, however, something is still not correct. I need to total the number of training hours per person by the current fiscal year (one query) and for the last 2 fiscal years (2nd query). I used...