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 code to Access 2000 code



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 06:00 PM posted to microsoft.public.access
Jim Bunton
external usenet poster
 
Posts: 72
Default VB code to Access 2000 code

I have a vb project which sends emails.
[This is on the site http://www.jsware.net/jsware/vbcode.php5
Ref Email Sending UserControl]

The Project has a form (Form1) which provides the relevant info

eg. recipient, sender, content, smtp provider etc

This data is processed by a "User Control" Module (MailUC)

The control consists of a simple form with one textbox on it and a good deal
of code.

The control is on Form1 and named MUC

The code for Form1 can reference the control like:-

ThisVariable = MUC.SomeFunction()
or
MUC.some_MUCvariable = "this"

The vb project file for the User Control is MailUC.ctl

?? how can I get this control into my Access2000 database and place it on a
form there??
--
Jim Bunton


  #2  
Old June 2nd, 2010, 12:32 AM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default VB code to Access 2000 code

Jim,

Look at the SendObject function in Access Help to see if that helps you.

Steve



"Jim Bunton" wrote in message
...
I have a vb project which sends emails.
[This is on the site
http://www.jsware.net/jsware/vbcode.php5
Ref Email Sending UserControl]

The Project has a form (Form1) which provides the relevant info

eg. recipient, sender, content, smtp provider etc

This data is processed by a "User Control" Module (MailUC)

The control consists of a simple form with one textbox on it and a good
deal of code.

The control is on Form1 and named MUC

The code for Form1 can reference the control like:-

ThisVariable = MUC.SomeFunction()
or
MUC.some_MUCvariable = "this"

The vb project file for the User Control is MailUC.ctl

?? how can I get this control into my Access2000 database and place it on
a form there??
--
Jim Bunton




  #3  
Old June 2nd, 2010, 01:12 PM posted to microsoft.public.access
Jim Bunton
external usenet poster
 
Posts: 72
Default VB code to Access 2000 code

Dear Steve,
Thank you for your response to my posting.

had a look at the send objects function - I can't see that it will do what I
am looking for.

The object is one that is currently in a VB application and I am looking to
use it in an Access application.

Seems more like an 'import object' scenario - had alook at that and don't
find anything that seems to do what I need.

Jim


"Steve" wrote in message
...
Jim,

Look at the SendObject function in Access Help to see if that helps you.

Steve



"Jim Bunton" wrote in message
...
I have a vb project which sends emails.
[This is on the site
http://www.jsware.net/jsware/vbcode.php5
Ref Email Sending UserControl]

The Project has a form (Form1) which provides the relevant info

eg. recipient, sender, content, smtp provider etc

This data is processed by a "User Control" Module (MailUC)

The control consists of a simple form with one textbox on it and a good
deal of code.

The control is on Form1 and named MUC

The code for Form1 can reference the control like:-

ThisVariable = MUC.SomeFunction()
or
MUC.some_MUCvariable = "this"

The vb project file for the User Control is MailUC.ctl

?? how can I get this control into my Access2000 database and place it on
a form there??
--
Jim Bunton






  #4  
Old June 2nd, 2010, 03:09 PM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default VB code to Access 2000 code

Hi Jim,

Why don't you describe in fetail what you are looking for and we'll see if
we can come up with a way to do it in Access.

Steve


"Jim Bunton" wrote in message
...
Dear Steve,
Thank you for your response to my posting.

had a look at the send objects function - I can't see that it will do what
I
am looking for.

The object is one that is currently in a VB application and I am looking
to
use it in an Access application.

Seems more like an 'import object' scenario - had alook at that and don't
find anything that seems to do what I need.

Jim


"Steve" wrote in message
...
Jim,

Look at the SendObject function in Access Help to see if that helps you.

Steve



"Jim Bunton" wrote in message
...
I have a vb project which sends emails.
[This is on the site
http://www.jsware.net/jsware/vbcode.php5
Ref Email Sending UserControl]

The Project has a form (Form1) which provides the relevant info

eg. recipient, sender, content, smtp provider etc

This data is processed by a "User Control" Module (MailUC)

The control consists of a simple form with one textbox on it and a good
deal of code.

The control is on Form1 and named MUC

The code for Form1 can reference the control like:-

ThisVariable = MUC.SomeFunction()
or
MUC.some_MUCvariable = "this"

The vb project file for the User Control is MailUC.ctl

?? how can I get this control into my Access2000 database and place it
on a form there??
--
Jim Bunton








 




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 09:49 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.