Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Visual Basic - Public db As Databas
Name: sillyman Date: July 2, 2004 at 01:55:37 Pacific OS: Win XP + Win 98 CPU/Ram: 1GB
Comment:
I am using the below to declar a database in Visual Basic
Option Explicit Public db As Database Public rstInfo As Recordset
But the problem I get is that when I run it it says Database is not a predefined object even though it changes the lower case d to upper case D
Make sure that you have the appropriate references to either ADO or DAO loaded in your project.
VB6 defaults to use dao which if you don't have the reference will not work. When declaring use Public dB as DAO.Database or Public db as ADODB.database.
Likewise with the recordset, if you have the references loaded it will prompt you in VB with a dropdown list as you enter code...
Summary: Compile Error: User-defined type, not defined... The reason you are getting this compile error is because you are trying to execute types that are not yet defined, for instance: Public db As Databas...
Summary: I want to search a database from visual basic and pull as record which fit the criteria but when I use: set rs = ds.openrecordset(SELECT * FROM accountInfoTable") I gets only the first relevant record...
Summary: Can anyone tell me if there is a visual basic function or ocx that can let a programmer to measure db and pitch form microphone or any sound file ...
0 
Comboboxes in VBA for Wor...
