DoCmd - Tilted Forum Project Discussion Community

Dilbert1234567 · 05-06-2004, 10:33 AM

my instructor was using the DoCmd in Visual Basic, and i cant seem to find it in mine. im running visual basic 6.0 with SP 4,

is it a plugin? only with .Net or what.

Dilbert1234567 · 05-06-2004, 10:34 AM

oh yeah he was using it to do SQL commands, and that is what i want to use it for.

Stompy · 05-07-2004, 12:53 PM

Sounds like he had a reference to the MS Access Object Library.

In VB6, you can add it by going to Project > References... > Microsoft Access [version] Object Library

To access a database, you'd create an Access.Application object

Code:

Dim app As New Access.Application

...and use the various methods within to open the database and do whatver you need.

If you're doing any type of Access stuff, I'd recommend that you use ADO instead.. much cleaner and easier. That can be found by adding the "Microsoft ActiveX Data Objects [version] Library"

Dilbert1234567 · 05-21-2004, 11:05 PM

bingo, thanks for the help

05-06-2004, 10:33 AM	#1 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	DoCmd my instructor was using the DoCmd in Visual Basic, and i cant seem to find it in mine. im running visual basic 6.0 with SP 4, is it a plugin? only with .Net or what. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-06-2004, 10:34 AM	#2 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	oh yeah he was using it to do SQL commands, and that is what i want to use it for. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-07-2004, 12:53 PM	#3 (permalink)
Stompy Banned from being Banned Location: Donkey	Sounds like he had a reference to the MS Access Object Library. In VB6, you can add it by going to Project > References... > Microsoft Access [version] Object Library To access a database, you'd create an Access.Application object Code: Dim app As New Access.Application ...and use the various methods within to open the database and do whatver you need. If you're doing any type of Access stuff, I'd recommend that you use ADO instead.. much cleaner and easier. That can be found by adding the "Microsoft ActiveX Data Objects [version] Library" __________________ I love lamp.

05-21-2004, 11:05 PM	#4 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	bingo, thanks for the help __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen