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 Rhinorhino 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: klaas01
  • Content: Threads
  • Order by date
  1. klaas01

    Access Multi user app, code runs slow when more users are logged in..

    Hello, I have made an access application which runs a vba update script every 1 minute. The code opens a foxpro database and updates the changed records to the access backend. The updating process is working fine, but the time needed for the updating is much longer when more than one user is...
  2. klaas01

    close odbc connection in access

    Hi, I'm dealing with the following problem: I have a Access database which is updating his data from a visual foxpro database every 30 seconds. That work fine till the visual foxpro database is being organized; access cannot retrieve data at that moment. In my error handling access is just...
  3. klaas01

    getting records from the last 4 weeks

    Hi, Since the new year has started i am dealing with this problem: to filter records from the last 4 weeks i use this formule: Format(Date();"yyyyww")-1 Or Format(Date();"yyyyww")-2 Or Format(Date();"yyyyww")-3 Or Format(Date();"yyyyww")-4 the problem is in week 2 of the new year this...
  4. klaas01

    Calculate multiple total from different tabels in one query

    Hi, I am building a scoreboard to show te results of the sales group in my company. There are 3 tables: - sales employees - Offertes - sales What i want is a query which calculates the total number of offertes and sales for each sales employee in a period (year/month / week) Is there a way...
  5. klaas01

    How to show date in 2 languages?

    Hello, I've got an access application which contains a report with the field birth date. The standard language is dutch, so the month of the birthdate is shown in dutch. the report is also translated to a english version, the problem is that the month of the birthdate is shown in dutch, like...
  6. klaas01

    How to split csv field, and get data from another able with those valu

    Hello, I have the following question: There are 2 tables: - employees - experiences a employee can have more than one experience, the keys of those experiences are being stored in the field experiences of the table employee like this: 1,2,3,4 What i want is to show the descriptions of each...

Part and Inventory Search

Back
Top