Phone Link Win 11 Automation

Thales750

Formerly Jsanders
Local time
Today, 18:21
Joined
Dec 20, 2007
Messages
3,729
Is there some undocumented way to control the Phone Link in Win 11 from Ms Access?
Or to create live SQL or even Excel data from the phone?
 
If your home phone is VOIP through a router, it is possible using software (though I've never done it.) IF this is what you are asking, do a web search on "Connect VOIP through my computer" or "Connect VOIP through router to computer". Some articles I noted named one or the other type of downloadable software. If I post the link, it might be mistaken as me recommending this software, but I have no experience. It would be better for you to do the evaluation.

IF, on the other hand, you are looking at RS-232-C connections, this is your serial port which should have a built-in modem. There is a "ZMODEM protocol" that you can look up. Again, I cannot tell you much about it because it has been a bunch of years since I had to play with that and time has marched on considerably since I have had to do that. But yes, the serial port (if modern computers still have them) should be able to dink around with phone company land-line connections.
 
Good Morning All.
I'm revisiting this.
This project is about connecting an Access Database with an Android or Apple Phone or tablet.
Windows 11 has a basic connection which works extremely well for Text Messaging.


Remote Phone Call has had a dialer for both systems for a decade or so. It works great for phone calls, and it has integration with 32 bit version of Access.

There is the dilemma. I'm trying to add these functions to Access 64bit because I keep getting system resources issues. Part of me says to abandon this and build a phone app that talks to a cloud SQL source and move on.

What are y'alls thought?
 
This is actually kind of amazing that I seem to be the only one interested in this subject.
I would think that managing communications would be a high priority for many people.
 
Remote Phone Call has had a dialer for both systems for a decade or so. It works great for phone calls, and it has integration with 32 bit version of Access.

There is the dilemma. I'm trying to add these functions to Access 64bit because I keep getting system resources issues.
Does the .Net API of Remote Phone Call work on 64bit? If yes, you could use that instead of the COM API for your Access/VBA integration.
 
Does the .Net API of Remote Phone Call work on 64bit? If yes, you could use that instead of the COM API for your Access/VBA integration.
That's interesting that you mention that. I had that same question, I didn't mention it because I was hoping someone would. Thanks for that.
I know Nex to mothing when if comes to programming in .NET.
Do you think I could get the Chat GPT tp write that?
 
I know Nex to mothing when if comes to programming in .NET.
Do you think I could get the Chat GPT tp write that?
Well, first thing to check would be whether the classes of the .NET API are COM Visible. If yes, you can use them directly in Access/VBA without even writing a single line of code in .Net.
Unfortunately, as the vendor had a dedicated COM API, it is unlikely that they also exposed the .NET API to COM. Then you would need to write a shallow, COM Visible wrapper around the required functionality, to make their .NET API accessible from Access/VBA.

I cannot comment on ChatGPT's abilities, but given the right context, ChatGPT can do some quite impressive things.
 

Users who are viewing this thread

Back
Top Bottom