Access 2K3 running a VB Express 2K5 Application

[Guest]

I'm trying to make Access 2003 run a VB application that I created in Visual
Basic Express 2005 when I press a button. I've created the VB application,
but I have no idea how to reference it. I've searched all over for people
trying to do this, but it seems everyone wants to run Access from VB Express,
which is just the opposite of what I'm trying to do.

Thanks,

Ben Loula

 

[Douglas J. Steele]

If you're talking about putting values into fields on a VB.Net form, I don't
believe it's possible from Access.

 

[Guest]

My ultimate goal is to make Access, when the appropriate button is clicked,
copy the contents of a Phone Number field to a text box, as the user is
viewing a form containing client information. This has the effect of making
this unbound text box reflect the phone number of the client the user is
currently looking at. Then a query references the number in this text box.

Now for the tricky part. I wrote a VB application in VB Express that starts
a Skype session to call a number that is taken in as a parameter. This
program works just fine with a sample number. I want to be able to send the
phone number from the database to the VB program so that a user can call a
client with one click.

There are probably more efficient ways of doing this, but everything works
except the sending of the phone number from Access to VB Express.

Thanks,

Ben Loula

 

['69 Camaro]

Hi, Ben.

PPMBI:

My ultimate goal is to make Access, when the appropriate button is
clicked,
copy the contents of a Phone Number field to a text box, as the user is
viewing a form containing client information. .. . .
Now for the tricky part. I wrote a VB application in VB Express that
starts
a Skype session to call a number that is taken in as a parameter. This
program works just fine with a sample number. I want to be able to send
the
phone number from the database to the VB program so that a user can call a
client with one click.

If you can use the auto-dialer, then this requires one line of code in
Access. In the command button's OnClick procedure, try:

Application.Run "utility.wlib_AutoDial", Me!txtPhoneNum.Value

If the text box is on another form, then it's still one line of code:

Application.Run "utility.wlib_AutoDial", Forms!Form2!txtPhoneNum.Value

There are probably more efficient ways of doing this, but everything works
except the sending of the phone number from Access to VB Express.

I hear it takes three to five times as long to develop the same application
in VB as in Access. I hear VB.Net takes even longer. If the above code
works, then you'll be able to determine whether or not that's true, because
you've already built the application in VB Express, . . . well, except for
the part that doesn't work yet. ;-)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.