A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

VB to Access via DDE



 
 
Thread Tools Display Modes
  #21  
Old August 1st, 2006, 06:06 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Terry Kreft
external usenet poster
 
Posts: 213
Default VB to Access via DDE

Nothing wrong with the Robin Reliant, what other car can you do a 3 point
turn in by asking your granny to get out and lift the front end up? g


--

Terry Kreft


"Brendan Reynolds" wrote in message
...
Where do you think they got the design for the Robin Reliant, Terry? :-)

--
Brendan Reynolds
Access MVP

"Terry Kreft" wrote in message
...
That's a bit like saying the travois is a predecessor to the automobile.



--

Terry Kreft


"Pieter Wijnen"

it.isi.llegal.to.send.unsollicited.mail.wijnen.no
.with.norway wrote in message
...
not really, it's the predecessor
and still AFAIK the core/origin of automation (?)
that said, automating Notus Lotes/ms word et al was flaky as hell back

in
Access 1.1/2.0 when there was no other way g

Pieter


"Terry Kreft" wrote in message
...
Graham,
DDE is a separate technology to automation.

--

Terry Kreft


"Graham R Seach" wrote in message
...
Jonathan,

Yes, the process is called "automation". The following is referred

to
as
"early binding". It is the easiest, and most functional because it

gives
you
access to Intellisense, but it is version-dependent. If you want

version
independence, you have to use "late binding".

SNIP

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Jonathan" wrote in message
...
Hello all,

Is there any way for a VB application to communicate with an

Access
application via DDE? I want to be able to send text box data to

Access
forms, click buttons and menu bars from an external application.



Thanks in advance,

Jonathan








-------------------------------------------------------------------------

-
------
I am using the free version of SPAMfighter for private users.
It has removed 4388 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!








  #22  
Old August 1st, 2006, 07:00 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Ralph
external usenet poster
 
Posts: 27
Default VB to Access via DDE


"Terry Kreft" wrote in message
...
Nothing wrong with the Robin Reliant, what other car can you do a 3 point
turn in by asking your granny to get out and lift the front end up? g



Now I get it!!!! lol

For years I have run across "Robin" jokes and references from british
colleagues that made no sense. I just chaulked it up to their usual
gibberish.

There is one reference concerning a lame project that I particularly
remember. I just gave a chuckle... That has to be longest delayed laugh in
history.

g
-ralph


  #23  
Old August 1st, 2006, 07:28 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default VB to Access via DDE


While the car itself was pretty funny, part of the reason that any mention
of it raises a chuckle in this part of the world is down to the central part
it played in a long-running TV comedy series ...

http://www.bbc.co.uk/comedy/onlyfools/

--
Brendan Reynolds
Access MVP

"Ralph" wrote in message
...

"Terry Kreft" wrote in message
...
Nothing wrong with the Robin Reliant, what other car can you do a 3 point
turn in by asking your granny to get out and lift the front end up? g



Now I get it!!!! lol

For years I have run across "Robin" jokes and references from british
colleagues that made no sense. I just chaulked it up to their usual
gibberish.

There is one reference concerning a lame project that I particularly
remember. I just gave a chuckle... That has to be longest delayed laugh
in
history.

g
-ralph




  #24  
Old August 1st, 2006, 09:26 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Terry Kreft
external usenet poster
 
Posts: 213
Default VB to Access via DDE


We've got the local main dealer for these just round the corner, you know
how most dealers take up a few acres to display the wares, this one is in a
corner shop and they've still got room for a workshop at the back.

http://pages.zoom.co.uk/elvis/robin.html


--

Terry Kreft


"Brendan Reynolds" wrote in message
...

While the car itself was pretty funny, part of the reason that any mention
of it raises a chuckle in this part of the world is down to the central

part
it played in a long-running TV comedy series ...

http://www.bbc.co.uk/comedy/onlyfools/

--
Brendan Reynolds
Access MVP

"Ralph" wrote in message
...

"Terry Kreft" wrote in message
...
Nothing wrong with the Robin Reliant, what other car can you do a 3

point
turn in by asking your granny to get out and lift the front end up? g



Now I get it!!!! lol

For years I have run across "Robin" jokes and references from british
colleagues that made no sense. I just chaulked it up to their usual
gibberish.

There is one reference concerning a lame project that I particularly
remember. I just gave a chuckle... That has to be longest delayed laugh
in
history.

g
-ralph






  #25  
Old August 2nd, 2006, 03:15 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Graham R Seach
external usenet poster
 
Posts: 261
Default VB to Access via DDE

Thanks Terry,

I've never used DDE (never even seen it), but I did know it was different to
OLE automation. I just figured automation was what the OP actually wanted.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Terry Kreft" wrote in message
...
Graham,
DDE is a separate technology to automation.

--

Terry Kreft


"Graham R Seach" wrote in message
...
Jonathan,

Yes, the process is called "automation". The following is referred to as
"early binding". It is the easiest, and most functional because it gives

you
access to Intellisense, but it is version-dependent. If you want version
independence, you have to use "late binding".

SNIP

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Jonathan" wrote in message
...
Hello all,

Is there any way for a VB application to communicate with an Access
application via DDE? I want to be able to send text box data to Access
forms, click buttons and menu bars from an external application.



Thanks in advance,

Jonathan








  #26  
Old August 2nd, 2006, 07:52 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Terry Kreft
external usenet poster
 
Posts: 213
Default VB to Access via DDE

"I've never used DDE ..."

You're just trying to make me really, really jealous now !

I had to write a DDE client module, using the Win API, for a VB dll, all
because the 3rd party program I had to communicate with professed to use
automation but it was broken meaning I had to revert at short notice to
using DDE. That was painful. I actually emulated the DDE functions that we
use in Access in order to simplify the process as it at least gave me a
coherent structure.


--

Terry Kreft


"Graham R Seach" wrote in message
...
Thanks Terry,

I've never used DDE (never even seen it), but I did know it was different

to
OLE automation. I just figured automation was what the OP actually wanted.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Terry Kreft" wrote in message
...
Graham,
DDE is a separate technology to automation.

--

Terry Kreft


"Graham R Seach" wrote in message
...
Jonathan,

Yes, the process is called "automation". The following is referred to

as
"early binding". It is the easiest, and most functional because it

gives
you
access to Intellisense, but it is version-dependent. If you want

version
independence, you have to use "late binding".

SNIP

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Jonathan" wrote in message
...
Hello all,

Is there any way for a VB application to communicate with an Access
application via DDE? I want to be able to send text box data to

Access
forms, click buttons and menu bars from an external application.



Thanks in advance,

Jonathan










  #27  
Old August 3rd, 2006, 10:50 AM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Graham R Seach
external usenet poster
 
Posts: 261
Default VB to Access via DDE

Sounds painful Terry. I guess I should be glad, huh!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Terry Kreft" wrote in message
...
"I've never used DDE ..."

You're just trying to make me really, really jealous now !

I had to write a DDE client module, using the Win API, for a VB dll, all
because the 3rd party program I had to communicate with professed to use
automation but it was broken meaning I had to revert at short notice to
using DDE. That was painful. I actually emulated the DDE functions that
we
use in Access in order to simplify the process as it at least gave me a
coherent structure.


--

Terry Kreft


"Graham R Seach" wrote in message
...
Thanks Terry,

I've never used DDE (never even seen it), but I did know it was different

to
OLE automation. I just figured automation was what the OP actually
wanted.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Terry Kreft" wrote in message
...
Graham,
DDE is a separate technology to automation.

--

Terry Kreft


"Graham R Seach" wrote in message
...
Jonathan,

Yes, the process is called "automation". The following is referred to

as
"early binding". It is the easiest, and most functional because it

gives
you
access to Intellisense, but it is version-dependent. If you want

version
independence, you have to use "late binding".

SNIP

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Jonathan" wrote in message
...
Hello all,

Is there any way for a VB application to communicate with an Access
application via DDE? I want to be able to send text box data to

Access
forms, click buttons and menu bars from an external application.



Thanks in advance,

Jonathan












  #28  
Old August 3rd, 2006, 02:47 PM posted to microsoft.public.access,microsoft.public.vb.general.discussion
Terry Kreft
external usenet poster
 
Posts: 213
Default VB to Access via DDE

Oh, yeh! g.

--

Terry Kreft


"Graham R Seach" wrote in message
...
Sounds painful Terry. I guess I should be glad, huh!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Terry Kreft" wrote in message
...
"I've never used DDE ..."

You're just trying to make me really, really jealous now !

I had to write a DDE client module, using the Win API, for a VB dll, all
because the 3rd party program I had to communicate with professed to use
automation but it was broken meaning I had to revert at short notice to
using DDE. That was painful. I actually emulated the DDE functions

that
we
use in Access in order to simplify the process as it at least gave me a
coherent structure.


--

Terry Kreft


"Graham R Seach" wrote in message
...
Thanks Terry,

I've never used DDE (never even seen it), but I did know it was

different
to
OLE automation. I just figured automation was what the OP actually
wanted.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Terry Kreft" wrote in message
...
Graham,
DDE is a separate technology to automation.

--

Terry Kreft


"Graham R Seach" wrote in message
...
Jonathan,

Yes, the process is called "automation". The following is referred

to
as
"early binding". It is the easiest, and most functional because it

gives
you
access to Intellisense, but it is version-dependent. If you want

version
independence, you have to use "late binding".

SNIP

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Jonathan" wrote in message
...
Hello all,

Is there any way for a VB application to communicate with an

Access
application via DDE? I want to be able to send text box data to

Access
forms, click buttons and menu bars from an external application.



Thanks in advance,

Jonathan














 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.