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!

Search results for query: *

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

    Access strings and sort problems. need pad-like function?

    Help! I have an alphanumeric, 10-character text field defined. It contains bond numbers which may be anywhere from 1 to 10 characters in length. The problem is the sort order. If I have bond numbers A1, A2, A11,A32, and A200 I would expect them to sort in this fashion. However, Access...
  2. kdre

    Checking SQL INSERT INTO return or error code

    Hi, I want to check the success/failure of an INSERT INTO statement. I've checked 'ERR' but this does not pick up the status of the SQL statement itself. I have done this against other databases using different languages, but cannot find the code or reserved word to check this. Below is the...
  3. kdre

    3065 run time error ...cannot execute a SELECT query

    Hi, I'm new to VBA and cannot figure this one out. I'm sure it's quite simple and is probably a rookie error, so I'd appreciate any help. I'm executing the following code and get the 3065 run time error when I attempt it. The text of the error is "cannot execute a SELECT query&quot...

Part and Inventory Search

Back
Top