473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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 1872
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
9
by: rick cameron | last post by:
TimeZone - the only instance you can get is one representing the local time zone DateTime - cannot represent a time before 00:00:00 1 Jan 1 CE What were they thinking? This is a serious question...
121
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...
2
by: Lauren Wilson | last post by:
Hi folks, Just "upgraded" from A2K to A2K3. Everything is just hunky dory (so far) -- EXCEPT that the Add-in I had with A2K that auto inserts error code is no longer available in the Add-in...
1
by: JS | last post by:
Hello, I am using ASP .Net to create my own web controls and I have noticed that there is one too many requirements that forces the developer to be aware of and get involved with. In the past...
9
by: Jay | last post by:
Everywhere I go (read/browse) I see these parameters.... ByVal sender As Object, ByVal e As System.EventArgs Yet I never see them used within the function/method. Could someone tell me what they...
0
by: han zhiyang | last post by:
I've just studied the "how to" web service and the async pattern in donnet.I make a test with these knowledges,but I got a strange result. Here is my test. 1.Write a simple "Add" service named...
3
by: =?Utf-8?B?RWFnbGVSZWRASGlnaEZseWluZ0JpcmRzLmNvbQ== | last post by:
I am writing an application using VS2005 and I am using javascript on the client side. I have a table that contains textboxes and I want to set the contents of all of them to the empty string in...
1
by: =?Utf-8?B?d2lsbGlhbQ==?= | last post by:
Hi, My question is about assembly binding. Here is the senario: I coded a sample web service application which consumes a dll named abc.dll. I used codebase in the web.config file to indicate...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.