mdommer1
Last Activity: Jan 6 '10, 09:06 PM
Joined: Oct 3 '09
Location:
-
Has anybody out there incorporated credit card processing into VBA code?
Some credit card companies offer server side ActiveX controls for the processing of credit card applications and claim that their libraries work in any language that supports ActiveX controls, but I have not been able to make them work succesfully in Microsoft Access code. Has anybody out there been down this road?
If a specific approach is needed please see:
*Edit* Link Removed as per site rules.
I am attempting... -
Adezii,
I was looking for more of how the outside world sees from the other side of a router, but thanks. Your routine is helpful to me on another project.Leave a comment:
-
I almost forgot.. also the reference to the "Microsoft Internet Controls" type library needs to be there.
Thanks again everybodyLeave a comment:
-
Helpers:
Thanks to your suggestions here is the function that will return your current External IP Address:
...Code:Function GetExternalIPAddress() As String On Error GoTo GetExternalIPAddress_Error Dim iebrowser As InternetExplorer Dim dtStartTime As Date Dim sDocHTML As String Dim strIPAddress As String 'Create a browser object SetLeave a comment:
-
NeoPa and Delerna,
Your suggested techniques were a success for me!
Further time on whatismyip.com suggested this site for 'scraping':
http://www.whatismyip.com/automation/n09230945.asp
Thanks again. Do you consider active participation on this site as a valid form of compenstation for your time?...Leave a comment:
-
The address that http://www.whatismypic.com/ provides is close enough for my needs. I'll try your suggestions and piece together a function. I realize that what lies between any given PC and what the rest of the internet sees as it's IP Address may be a lot of smoke and mirrors. If writing Microsoft Access Database applications wasn't so much fun I'd consider getting really deep with that IP routing stuff. Thanks for your suggestions. There...Leave a comment:
-
I saw an example of obtaining your current external ip address using vb.net but shame on me for not saving the link. If I there was a way to stream the html of a site (that rarely changes) of my choosing into a text file I could pick thru the text file to get my address. In a way I'm happy that a bytes administrator with 15000 posts is perplexed. I'd hate to ask a question that had too obvious an answer. So is there a way to capture the html...Leave a comment:
-
sites like http://www.whatismyip.com/ display my external ip address. It is this address that I am interested in grabbing via vba code in access.Leave a comment:
-
Anyone out there have a clean Get_External_IP_Address function?
I need a function that returns the external ip address as a string for use inside a Microsoft Access application. My efforts to find one thru searching google and bing produce answers that do not work in Access/VBA.
Thanks. -
How can I tell if more than one person has a .mdb file open concurrently?
How in code can I determine if the current front end .mdb file is being used by more than one person?
Can I determine how many people?
Can I determine who?
Can I determine who and how many are using a back end .mdb file?
Thanks in advance for sharing your experience. -
I'd suggest googling 'using functions and expressions in access' and then revisiting all of the above suggestions.Leave a comment:
-
BTW, the above post was not really intended to measure time precisely beyond the WEEK unit due to the variations in length of month and year. But it was an entertaining attempt to mimick the Time Remaining messages seen in so many places.Leave a comment:
-
Here's a fun way to do it:
...Code:Function ShowDuration(StartTime As Date, EndTime As Date) As String 'added 1/23/08 by MJD Dim lngSeconds As Long Dim strDuration As String Dim FoundIntValue As Long strDuration = "" lngSeconds = CDbl(EndTime - StartTime) * 60 * 24 * 60 If lngSeconds = 0 Then strDuration = "0 seconds"Leave a comment:
No activity results to display
Leave a comment: