ADO, DAO, Chairman MAO

Newbeee · Jul 17th, 2002, 08:12 AM

To any one who is reading this......HELLLLLLLPPPPP!! In the last 3 months, I've attempted to use DAO and ADO with Access 2000 but its always been one error message or another. Its either "...too few parameters" or some other message. Is there anyone that can provide me with an IDIOTS GUIDE to implementing ADO on a single table database i.e. retrieving data from the db using a form by passing an SQL query in which the WHERE parameter changes depending on the particular record being sought e.g. User Id. (am i making sense?). In addition, I dont understand the following...whatever they are; adLockOptimistic, adLockReadOnly, cmdTable etc.

To all you Gurus interested in saving a worthless peasant
I've tried to attached a copy of the db, in which you'll find the table, the form and my sorry attempt at using ADO (command button event)
Remember; AN IDIOTS GUIDE is what is needed. Nothing too complicated please

Wildec2 · Jul 17th, 2002, 10:20 PM

What attachment?

Newbeee · Jul 18th, 2002, 01:10 PM

Looks like the attachment was too large..... Can you help though?

barchetta · Jul 18th, 2002, 02:21 PM

If it's about learning Access I would stick to DAO in the first place and forget about ADO, although the latter is newer. Access works best with DAO because DAO is optimized for it. After that go learn some SQL. Then it's time to learn ADO IMHO. Trying two different techniques at the same time can be quite confusing. There are about a million books about Access VB so have a look in the local book shop.

Newbeee · Jul 31st, 2002, 05:47 AM

barchetta, note that I do know sql quite well, unfortunately having chosen to be an IT business analyst, my VB and sql skills have taken a bit of a dive. In addition, using VBA in MS Access is quite different from using VB. The need to always set focus is one thing that is quite traumatising. However I have been able to connect to the access db using ADO and passing a SELECT query successfully. The problem now is that in VB I have been able to pass SELECT and INSERT queries but VBA does not allow me to pass the INSERT query. It gives me an "Error 2185" ; cant reference a property or method unless blah, blah, blah, has focus..

When I press the debug button my SQL query is highlighted.

Can you help?

reznor · Jul 31st, 2002, 07:10 AM

First of all, in Access VBA, when referencing the values in text boxes, lose the .text, then it will stop jabbering about not having the focus.
Just to be sure, are you programming in VB or VBA right now?

barchetta · Jul 31st, 2002, 02:05 PM

Newbeee.
If I were you I would try to find a tutorial about DAO and use SQL queries to pass to the database.
Access handles SQL quite well IMHO and there's no instruction too difficult for Access. You also have the benefit of writing queries that the access wizard can't do for you like queries using UNION.
Date handling can be a mess sometimes but you can overcome those problems.

Newbeee · Aug 1st, 2002, 02:39 AM

Reznor

I'm using VBA right now...... I've been able to pass all the sql queries successfully using vb but vba seems to be a different beast.

Jul 17th, 2002, 08:12 AM	#1
Newbeee New Member Join Date: Jul 02 Posts: 4	ADO, DAO, Chairman MAO To any one who is reading this......HELLLLLLLPPPPP!! In the last 3 months, I've attempted to use DAO and ADO with Access 2000 but its always been one error message or another. Its either "...too few parameters" or some other message. Is there anyone that can provide me with an IDIOTS GUIDE to implementing ADO on a single table database i.e. retrieving data from the db using a form by passing an SQL query in which the WHERE parameter changes depending on the particular record being sought e.g. User Id. (am i making sense?). In addition, I dont understand the following...whatever they are; adLockOptimistic, adLockReadOnly, cmdTable etc. To all you Gurus interested in saving a worthless peasant I've tried to attached a copy of the db, in which you'll find the table, the form and my sorry attempt at using ADO (command button event) Remember; AN IDIOTS GUIDE is what is needed. Nothing too complicated please

Jul 17th, 2002, 10:20 PM	#2
Wildec2 New Member Join Date: Jul 02 Posts: 11	Attachment? What attachment?

Jul 18th, 2002, 01:10 PM	#3
Newbeee New Member Join Date: Jul 02 Posts: 4	ADO, DAO, Chairman MAO Looks like the attachment was too large..... Can you help though?

Jul 31st, 2002, 07:10 AM	#6
reznor Addicted Member Join Date: May 01 Location: Netherlands Posts: 151	First of all, in Access VBA, when referencing the values in text boxes, lose the .text, then it will stop jabbering about not having the focus. Just to be sure, are you programming in VB or VBA right now? __________________ "Computers are incredibly fast, accurate and stupid. Human beings are incredibly slow, inaccurate and brilliant. Together they are powerful beyond imagination." - Albert Einstein

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jul 18th, 2002, 02:21 PM	#4
barchetta New Member Join Date: Jul 02 Posts: 12	If it's about learning Access I would stick to DAO in the first place and forget about ADO, although the latter is newer. Access works best with DAO because DAO is optimized for it. After that go learn some SQL. Then it's time to learn ADO IMHO. Trying two different techniques at the same time can be quite confusing. There are about a million books about Access VB so have a look in the local book shop.

Jul 31st, 2002, 05:47 AM	#5
Newbeee New Member Join Date: Jul 02 Posts: 4	barchetta, note that I do know sql quite well, unfortunately having chosen to be an IT business analyst, my VB and sql skills have taken a bit of a dive. In addition, using VBA in MS Access is quite different from using VB. The need to always set focus is one thing that is quite traumatising. However I have been able to connect to the access db using ADO and passing a SELECT query successfully. The problem now is that in VB I have been able to pass SELECT and INSERT queries but VBA does not allow me to pass the INSERT query. It gives me an "Error 2185" ; cant reference a property or method unless blah, blah, blah, has focus.. When I press the debug button my SQL query is highlighted. Can you help?

Jul 31st, 2002, 02:05 PM	#7
barchetta New Member Join Date: Jul 02 Posts: 12	Newbeee. If I were you I would try to find a tutorial about DAO and use SQL queries to pass to the database. Access handles SQL quite well IMHO and there's no instruction too difficult for Access. You also have the benefit of writing queries that the access wizard can't do for you like queries using UNION. Date handling can be a mess sometimes but you can overcome those problems.

Aug 1st, 2002, 02:39 AM	#8
Newbeee New Member Join Date: Jul 02 Posts: 4	Reznor I'm using VBA right now...... I've been able to pass all the sql queries successfully using vb but vba seems to be a different beast.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)