469,894 Members | 2,209 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,894 developers. It's quick & easy.

What happened? Non of VB code works

Access 2003

After my app is finished I'd like to create an mde file. Therefore my db has
to be made in the 2002-2003 format. So I've created a new mdb (default in
2000 format), I converted this empty mdb to the 2002-2003 format. I've
started to add code but discovered that non of my VB code works. Even a
simple <<msgbox "test">doesn't work. I constantly get the message about
miscommunication between Access and OLE souce program or Active X element.
Can someone please explain why this is happening??? I tried to check some
references but no luck.
Help!
thanks,
john
Jun 21 '07 #1
11 1735
Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If it is,
uncheck it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message news:f5**********@textnews.wanadoo.nl...
Access 2003

After my app is finished I'd like to create an mde file. Therefore my db
has to be made in the 2002-2003 format. So I've created a new mdb (default
in 2000 format), I converted this empty mdb to the 2002-2003 format. I've
started to add code but discovered that non of my VB code works. Even a
simple <<msgbox "test">doesn't work. I constantly get the message about
miscommunication between Access and OLE souce program or Active X element.
Can someone please explain why this is happening??? I tried to check some
references but no luck.
Help!
thanks,
john

Jun 21 '07 #2
Thanks Steve.

Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain

I can't find Microsoft Data Access Objects though.

Still it's not working.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.earthl ink.net...
Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If it
is, uncheck it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>Access 2003

After my app is finished I'd like to create an mde file. Therefore my db
has to be made in the 2002-2003 format. So I've created a new mdb
(default in 2000 format), I converted this empty mdb to the 2002-2003
format. I've started to add code but discovered that non of my VB code
works. Even a simple <<msgbox "test">doesn't work. I constantly get the
message about miscommunication between Access and OLE souce program or
Active X element.
Can someone please explain why this is happening??? I tried to check some
references but no luck.
Help!
thanks,
john


Jun 21 '07 #3
Look for Microsoft DAO.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message news:f5**********@textnews.wanadoo.nl...
Thanks Steve.

Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain

I can't find Microsoft Data Access Objects though.

Still it's not working.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.earthl ink.net...
>Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If it
is, uncheck it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>>Access 2003

After my app is finished I'd like to create an mde file. Therefore my db
has to be made in the 2002-2003 format. So I've created a new mdb
(default in 2000 format), I converted this empty mdb to the 2002-2003
format. I've started to add code but discovered that non of my VB code
works. Even a simple <<msgbox "test">doesn't work. I constantly get
the message about miscommunication between Access and OLE souce program
or Active X element.
Can someone please explain why this is happening??? I tried to check
some references but no luck.
Help!
thanks,
john



Jun 21 '07 #4
On Thu, 21 Jun 2007 21:50:13 +0200, John wrote:
Thanks Steve.

Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain

I can't find Microsoft Data Access Objects though.

Still it's not working.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.earthl ink.net...
>Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If it
is, uncheck it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>>Access 2003

After my app is finished I'd like to create an mde file. Therefore my db
has to be made in the 2002-2003 format. So I've created a new mdb
(default in 2000 format), I converted this empty mdb to the 2002-2003
format. I've started to add code but discovered that non of my VB code
works. Even a simple <<msgbox "test">doesn't work. I constantly get the
message about miscommunication between Access and OLE souce program or
Active X element.
Can someone please explain why this is happening??? I tried to check some
references but no luck.
Help!
thanks,
john

Look down the list for
Microsoft 3.6 DAO Object Library

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jun 21 '07 #5
DAO 3.6 is in the list and it's not checked, still same behavior.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:xJ*****************@newsread3.news.pas.earthl ink.net...
Look for Microsoft DAO.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>Thanks Steve.

Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain

I can't find Microsoft Data Access Objects though.

Still it's not working.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.earth link.net...
>>Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If it
is, uncheck it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
Access 2003

After my app is finished I'd like to create an mde file. Therefore my
db has to be made in the 2002-2003 format. So I've created a new mdb
(default in 2000 format), I converted this empty mdb to the 2002-2003
format. I've started to add code but discovered that non of my VB code
works. Even a simple <<msgbox "test">doesn't work. I constantly get
the message about miscommunication between Access and OLE souce program
or Active X element.
Can someone please explain why this is happening??? I tried to check
some references but no luck.
Help!
thanks,
john



Jun 21 '07 #6
Did you check DAO 3.6 and try it?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message news:f5**********@textnews.wanadoo.nl...
DAO 3.6 is in the list and it's not checked, still same behavior.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:xJ*****************@newsread3.news.pas.earthl ink.net...
>Look for Microsoft DAO.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>>Thanks Steve.

Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain

I can't find Microsoft Data Access Objects though.

Still it's not working.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.eart hlink.net...
Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If
it is, uncheck it.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
Access 2003
>
After my app is finished I'd like to create an mde file. Therefore my
db has to be made in the 2002-2003 format. So I've created a new mdb
(default in 2000 format), I converted this empty mdb to the 2002-2003
format. I've started to add code but discovered that non of my VB code
works. Even a simple <<msgbox "test">doesn't work. I constantly get
the message about miscommunication between Access and OLE souce
program or Active X element.
Can someone please explain why this is happening??? I tried to check
some references but no luck.
Help!
thanks,
john
>




Jun 22 '07 #7
Yes, same behavior.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:Wg****************@newsread1.news.pas.earthli nk.net...
Did you check DAO 3.6 and try it?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>DAO 3.6 is in the list and it's not checked, still same behavior.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:xJ*****************@newsread3.news.pas.earth link.net...
>>Look for Microsoft DAO.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
Thanks Steve.

Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain

I can't find Microsoft Data Access Objects though.

Still it's not working.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.ear thlink.net...
Check your references again. Be sure Microsoft Data Access Objects is
checked. Watch to be sure Microsoft ADO is not in your references. If
it is, uncheck it.
>
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
>
>
>
"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>Access 2003
>>
>After my app is finished I'd like to create an mde file. Therefore my
>db has to be made in the 2002-2003 format. So I've created a new mdb
>(default in 2000 format), I converted this empty mdb to the 2002-2003
>format. I've started to add code but discovered that non of my VB
>code works. Even a simple <<msgbox "test">doesn't work. I
>constantly get the message about miscommunication between Access and
>OLE souce program or Active X element.
>Can someone please explain why this is happening??? I tried to check
>some references but no luck.
>Help!
>thanks,
>john
>>
>
>




Jun 22 '07 #8

"Steve" <so***@private.emailaddressschreef in bericht news:Wg****************@newsread1.news.pas.earthli nk.net...
Did you check DAO 3.6 and try it?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
--
You are *not* a resource at all !!
Stop advertising here, or get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html

ArnoR
Jun 22 '07 #9
Arno, can you explain what steve has done that has started you to respond
in this manner to all his posts?

John... Visio MVP

"StopThisAdvertising" <StopThisAdvertising@DataShitwrote in message
news:46***********************@text.nova.planet.nl ...

"Steve" <so***@private.emailaddressschreef in bericht
news:Wg****************@newsread1.news.pas.earthli nk.net...
Did you check DAO 3.6 and try it?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
You are *not* a resource at all !!
Stop advertising here, or get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html

ArnoR
Jun 22 '07 #10

"John Marshall, MVP" <la******@stonehenge.caschreef in bericht news:92***************************@PRIMUS.CA...
Arno, can you explain what steve has done that has started you to respond
in this manner to all his posts?

John... Visio MVP
Hi John,
Well, I see, you mean I need to explain this to the newbees here ???

Well, It is not something that Steve has done...
It's more like something that he did *not* do ...

He did *not* respond to all our warnings and plee's here...
He did *not* give a shit about what you and I and others said....
He did *not* stop being an a$$hole...
He did *not* even respond when people call him "an oily snake.."

In short: he did *not* stop advertising...

ArnoR
Jun 22 '07 #11
John,

I really don't have an answer but if you would, try something ----
Find a simple subroutine with only a few lines in your application. Rename
the subroutine by putting a couple of Xs in front of the name such as:
XXMyControl_AfterUpdate

Now go to the event property that launched that subroutine and delete [Event
Procedure}. Next recreate the event property by clicking in the white area
and then clicking on the button with the three dots. Copy your old code into
the new subroutine. Delete the old subroutine that you renamed. Now run the
subroutine and let us know what happens.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message news:f5**********@textnews.wanadoo.nl...
Yes, same behavior.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:Wg****************@newsread1.news.pas.earthli nk.net...
>Did you check DAO 3.6 and try it?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
>>DAO 3.6 is in the list and it's not checked, still same behavior.
john

"Steve" <so***@private.emailaddressschreef in bericht
news:xJ*****************@newsread3.news.pas.eart hlink.net...
Look for Microsoft DAO.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"John" <jo@hn.comwrote in message
news:f5**********@textnews.wanadoo.nl...
Thanks Steve.
>
Checked are:
VB for applications
MS Access 11.0 object library
OLE automation
MS Data Access Components Installed Version
acwzmain
>
I can't find Microsoft Data Access Objects though.
>
Still it's not working.
john
>
"Steve" <so***@private.emailaddressschreef in bericht
news:pf*****************@newsread2.news.pas.ea rthlink.net...
>Check your references again. Be sure Microsoft Data Access Objects is
>checked. Watch to be sure Microsoft ADO is not in your references. If
>it is, uncheck it.
>>
>PC Datasheet
>Providing Customers A Resource For Help With Access, Excel And Word
>Applications
>re******@pcdatasheet.com
>>
>>
>>
>"John" <jo@hn.comwrote in message
>news:f5**********@textnews.wanadoo.nl...
>>Access 2003
>>>
>>After my app is finished I'd like to create an mde file. Therefore
>>my db has to be made in the 2002-2003 format. So I've created a new
>>mdb (default in 2000 format), I converted this empty mdb to the
>>2002-2003 format. I've started to add code but discovered that non
>>of my VB code works. Even a simple <<msgbox "test">doesn't work. I
>>constantly get the message about miscommunication between Access and
>>OLE souce program or Active X element.
>>Can someone please explain why this is happening??? I tried to check
>>some references but no luck.
>>Help!
>>thanks,
>>john
>>>
>>
>>
>
>




Jun 22 '07 #12

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

121 posts views Thread by typingcat | last post: by
9 posts views Thread by Jay | last post: by
3 posts views Thread by =?Utf-8?B?RWFnbGVSZWRASGlnaEZseWluZ0JpcmRzLmNvbQ== | last post: by
1 post views Thread by =?Utf-8?B?d2lsbGlhbQ==?= | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.