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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JakeNL

  1. JakeNL

    SQL UPDATE currency field problem

    Thanks PHV, I only had to adjust one thing like : Replace(CStr(totaal), ",", ".") and now it is running. case closed and Thanks for your help and time !!! Jack
  2. JakeNL

    SQL UPDATE currency field problem

    Nope, No result it comes up with a syntaxis error.
  3. JakeNL

    SQL UPDATE currency field problem

    I try to update a currency field in my ms acess db from a program in VB6 (sp5). Herefor I execute a SQL string-command over the active connection. The variable total is also declared a currency type variable. The error message tells me that there is an error in the command and that it is about...
  4. JakeNL

    Date Insert results in erroneous date

    Yep, That works resulting in m-d-y correctly and that also triggered some other tries, now i also tried to put the date inbetween accents and that had not yet occurred to me before. So problem solved Thanks David
  5. JakeNL

    Date Insert results in erroneous date

    I Have a huge problem trying to insert a date in a date/time field of a jet db. Firstly I create a SQL string to perform the operation and later on I execute this SQL string on the connection. Afterwards some very weird data can be found in the real field if I look in it with the Visual data...
See more

Part and Inventory Search

Back
Top