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 = ?
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.
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.