Prev: Two autonumber fields in one table possible?
Next: vba
From: Jim Bunton on 1 Jun 2010 13:00 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
From: Steve on 1 Jun 2010 19:32 Jim, Look at the SendObject function in Access Help to see if that helps you. Steve santus(a)penn.com "Jim Bunton" <jBunton(a)BlueYonder.co.uk> wrote in message news:4c053cb9$0$13730$426a74cc(a)news.free.fr... >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 > >
From: Jim Bunton on 2 Jun 2010 08:12 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" <notmyemail(a)address.com> wrote in message news:uqvvkKeALHA.3840(a)TK2MSFTNGP02.phx.gbl... > Jim, > > Look at the SendObject function in Access Help to see if that helps you. > > Steve > santus(a)penn.com > > > "Jim Bunton" <jBunton(a)BlueYonder.co.uk> wrote in message > news:4c053cb9$0$13730$426a74cc(a)news.free.fr... >>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 >> >> > >
From: Steve on 2 Jun 2010 10:09 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" <jBunton(a)BlueYonder.co.uk> wrote in message news:4c064acc$0$29099$426a74cc(a)news.free.fr... > 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" <notmyemail(a)address.com> wrote in message > news:uqvvkKeALHA.3840(a)TK2MSFTNGP02.phx.gbl... >> Jim, >> >> Look at the SendObject function in Access Help to see if that helps you. >> >> Steve >> santus(a)penn.com >> >> >> "Jim Bunton" <jBunton(a)BlueYonder.co.uk> wrote in message >> news:4c053cb9$0$13730$426a74cc(a)news.free.fr... >>>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 >>> >>> >> >> > >
|
Pages: 1 Prev: Two autonumber fields in one table possible? Next: vba |