I have looked and tried everything I could find in the books, but I can't find any way to pass a VB6 variable to a SQL statement. I'm getting a lot of syntax errors.
Example: "SELECT Name, Address FROM Customers WHERE PhoneNum =" "'"Text1.Text"'""
I'm hoping to fill some other Textboxes on...
I have VB6, and am working on a business program where I need to use databases. I also have Access 2000 which I am trying to use. Why is it when I build a database in Access 2000, my VB6 refuses to open it? The Data Manager gives me an "Unrecognized Format" error.
Sorry to bother, but I'm a beginner in programming, and I can not find how to add all records of a single field to form a total, and display it in a text box.
Example: record1.myfield + record2.myfield + record3.myfield etc.
Thanks
Mike
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.