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 IamaSherpa 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: *

  1. KAJTPY

    Data Environment Parameters with ?

    Now it is giving me this error when I attempt to open the data report. [TCX][MyODBC]SQLBindParameter not used for all parameters.
  2. KAJTPY

    Data Environment Parameters with ?

    This is in the SQL Statement box of my Command. It work the first time I put it in there and ran the program, and then it erased the parameters. I can't figure out why. SELECT * FROM rental_inventory_list WHERE Description = ?
  3. KAJTPY

    Data Environment Parameters with ?

    Help, I am using a sql statement that uses a ? in it, but it does not show up in the parameters. It worked the first time I used it and now the parameters are gone.
  4. KAJTPY

    Adding function to DataReport for items from two different tables

    I am creating the sales report function for a rental program. Items are bought once on the first invoice they were every used on and then rented out multiple times on additional invoices. Right now my data report shows like this. Invoice # Item #1 Description Rental Rate...
  5. KAJTPY

    RS. Close and Set RS = nothing

    I don't know particularly why either, but I know when I use the getrows method after opening a recordset, that I cannot open another recordset in the same procedure without closing the first one as well as setting it = nothing. Just a thought.

Part and Inventory Search

Back
Top