Search results for query: *

Hello all... Here is my problem. I am trying to gather specific information from fields in my Paradox tables. When I execute the SQL statements in Access, they work beautifully... but when I copy them over to VB 6 I am getting: "too few parameters" error when I try to put it as the...

Johnwm... You are a GENUIS! Thanks much, much, much! ~Leah

johnwm, Quick question on your proposed solution... Can I do that using another field set up with user names? I believe that I could create a new table to hold the user data that the client could enter. In theory, I will not know all the user names and it is not feasible for me to program in...

Hello all, Here is my dilemma. I have to write a program to access data and run reports. The data is being held in Paradox tables that are generated by a seperate program. This program is not designed to access the information that one of our clients now wants (they want to know which sales...

Nevermind! I figured out how to do it. Actually, I kinda cheated hahahaha. Why re-invent the wheel when I have sample programs in my textbooks from school. I just changed some of the code around and Presto! I now have data population. I'm sure that I will have more problems down the line...

Hello, I'm back again with another problem. After some additonal research, I decided to just use the data-control object in VB. Easier, I thought, than trying to write a connection string. BUT, now I'm getting an error that i don't have an installable ISAM for Paradox 4.x. I've looked around...

I may be on the wrong track... but maybe you should try nesting your SQL statement inside a loop... Do while EEPROMCAMID = "camid" SQL = "Select * from Cards Set SubDB = OpenDatabase(App.Path & "\satsubs.mdb") Set rs = SubDB.OpenRecordset(SQL) Loop NOTE: my syntax may...

Thanks for the quick replies... one last question before I go and bang my head on my keyboard some more... WHERE do I put the connection string? Should it be under a command button to connect? on a form load? Or does it matter? Is there one way that works better than another?? Thanks again!

Hello, I am working on an application that will bring Paradox tables into a VB application that will then let the client query and run reports. Normally, I would have used MS Access and be done with it, however the data in the tables is being generated by another program, so I have to...