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!

  • Congratulations SkipVought 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: Gurk
  • Order by date
  1. Gurk

    Query with calculations slow

    Thank you for the comment - I had not thought of that before, guess that's what you get for learning as you go. I replaced all the DFirst with global variables which I set with my switchboard form. That alone reduced the report from about 40s to load to under 10. I appreciate your advice, I...
  2. Gurk

    Query with calculations slow

    Sorry - not thinking clearly. The query SQL: SELECT tblUsers.StaffUserID, tblOT.otDate, tblOT.otStart, tblOT.otStop, Round(Hour([otStop]-[otStart])+Minute([otStop]-[otStart])/60,2) AS otActualHours, Round(CalculateOT([otDate],[otStop],[otStart],[Callback],[HolidayDay],[Travel]),2) AS...
  3. Gurk

    Query with calculations slow

    I am building a small database to track overtime claims - I am only saving userid, date and start / stop times. The dollar amounts I am calculating at the time the report is generated so that no personal financial information is stored which eliminates any security concerns. I am running a...
  4. Gurk

    è turns ? when inputting in Db

    I have a similar problem though I am typing in Vietnamese using UNICODE. The characters that get are displayed on the intranet must use the ũ notation. When these characters are entered through the intranet - the UNICODE code is saved in the database, not the visual representation. Again...
  5. Gurk

    Contacts are empty in Outlook 2002

    I have a similar problem after moving Contacts to a new HP P4 - but the option to use the Contacts folder as an Address Book is greyed out and I can't choose it.
  6. Gurk

    SAV Corporate 8 - Liveupdate fails

    Everytime I run LiveUpdate, it fails updating the Symantec AntiVirus Corporate Server with error LU1847., but the definitions download fine (manually, they appear to fail when scheduled). I looked this up on the Symantec KB, and it says to delete all the downloaded updates from "...\All...
  7. Gurk

    Migrate W2K from P2P to AD

    Thanks Mark, that is about what I thought. Since I don't have a test environment - is it possible to upgrade to AD - while still leaving the users functioning in a peer environment until accounts and permissions are established - or can this be done in advance? If they plan to host their own...
  8. Gurk

    Migrate W2K from P2P to AD

    I have recently started consulting for a company with a W2K server and approx. 15 XP Pro WS. The initial installation of the server was basically as a suped up workstation. Permissions are everywhere and users save everything locally. I am planning to upgrade them to AD, the wizard in 2000...

Part and Inventory Search

Back
Top