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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Countymnca
  • Content: Threads
  • Order by date
  1. Countymnca

    The missing .01 (rounding time)

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

    CASE Statement or ?

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

    DateDiff and timer like functioning event

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

    Exchange Basics and Advice

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

    Multiple fields on StLinkCriteria

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

    Page Changes

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

    Insert 0 into text string

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

    Dmax with dates less than 2000

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

    Duplicate db apphend/update

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

    Dmax

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

    Excel Import Problem at 476 records

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

    Fiscal Year to Now () Totals

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

Part and Inventory Search

Back
Top