Access Auto dialler VBA

[Neilster]

Hi

Does anyone know how to set up Auto dialler in Access or know of a link where I can be pointed to. (I assume this will help me set it up with a modem dialler?)

I know you can use the wizard to set in up, however when clicking the button it doesn't pick up the number form the number field in access.

Also is there a way of recording calls numbers made, call time and call length in say a table or form in Access?

All of the above by using VBA

Cheers for anyone how can help.

 

[Uncle Gizmo]

I can't see how VBA would be able to tell you how long a call lasted unless you have some other hardware attached to the phone? Is that what you have? Or will you have your operator press a button at the start and end of the call? If none of the above, then more information is required.

 

[AccessBlaster]

It's fairly easy to dial and log calls see example I made for my brother a few years back.

 

[Neilster]

That looks like what I need AccessBlaster, therefore how would I go about achieving this? I it just a case of using the wizard when creating the dail button?

Many thanks

 

[CJ_London]

you might also want to investigate smart tags

http://accessdatabasetutorial.com/2013/07/01/how-to-use-smart-tags-in-microsoft-access-2010/

although they disappear in 2013 so if you are expecting to head in that direction at some point, probably not worth considering

 

[Neilster]

Hi CJ

Thanks for that, however I am running 2013.

Cheers

 

[AccessBlaster]

That looks like what I need AccessBlaster, therefore how would I go about achieving this? I it just a case of using the wizard when creating the dail button?

Many thanks

Hi Neilster,

PM me a email address and I will send you a copy of my application. BTW you need a computer that still has a telephone jack, and Windows needs to know about your dialing preferences.

 

[marlan]

Hi,

If we are here, does anyone know of a way to send an SMS in Access?
That is providing a connected modem ("telephone jack").

 

[vbaInet]

Hi,

If we are here, does anyone know of a way to send an SMS in Access?
That is providing a connected modem ("telephone jack").

Not quite a related question though marlan, but I think that there's a sample SMS db in the Sample Databases or Code Repository section of the site.

If that fails, find an add-in that does it and write your routines to handle the process.

 

[CJ_London]

does anyone know of a way to send an SMS in Access?

you'll need a subscription with a provider such as twilio or clickatel to use one of their api's. I think thethread uses Twilio - links here http://www.access-programmers.co.uk/forums/showthread.php?t=226921&highlight=twilio
http://www.access-programmers.co.uk/forums/showthread.php?t=231541&highlight=twilio
http://www.access-programmers.co.uk/forums/showthread.php?t=247046&highlight=twilio

Not particularly expensive - typically around 4c (USD) per text, minimum purchase around $20, gets a lot cheaper if you purchase $5000 worth at a time

 

[Uncle Gizmo]

Regarding SMS, I've used Text Magic, you just send an email.

 

[marlan]

Hi,
Back from weekend...

VBAInet, just went through entire code repository, couldn't find...

I'me locking some API for directly accessing my land-phone company, and sending SMS on my simple prepaid line.

any ideas pls?

TIA

 

[vbaInet]

I thought there was marlan, my bad!

You could try looking for a command line utility that allows you to send free text messages, and from there fire off the command using VBA's Shell() function (or other alternatives). But I'm sure that there would be a daily limit and they may charge you if you go over the threshold. Or try what CJ_London and Uncle G advised.

Maybe ask AccessBlaster to send you his project.

 

[marlan]

Yup, I guess its time to learn HTTP and use it in Access. Its Quite a few year they say in the future, time to enter it! guis here lined some nice code

Thanks for your advice!

 

[vbaInet]

Yup, I guess its time to learn HTTP

It is

Happy HTTPing!