Recent content by mjcaestecker

Greetings all. I need to send a programatical "click" onto an active x web control. For some reason, when I load the webpage into the control and then swipe a credit card to send the webpage data, the page will not accept the swipe unless I click on the control before swiping the card. Any...

Greetings All, A little background first: I have a program built with VBA and Access that sends an xml command to a credit card terminal for processing. when the command is sent to the credit card terminal, another database opens which gives the user the option to close the connection between...

Greetings all, This is a simple question, but i cannot seem to find an understandable answer anywhere... How do you parse a responseXML after you get the response from a webserver? Here's the code i have so far to get the response. Dim Execute As New MSXML2.ServerXMLHTTP Dim Response...

This is a great online tutorial that I used. Gives you a good background on the basics with a peek into more complex operations of Access VBA http://www.functionx.com/vbaccess/index.htm hope this helps, -Martin

Greetings all, Is it possible to insert a picture into a word document from Access like you can with text and bookmarked fields in a template? thanks, -Martin

Constant contact specifies that you use Put instead of Post for contact update. I did manage to solve the problem, however. Just needed to create an MSXML2.DOMDocument with a loadXML (str) command. I sent that and it worked. Thanks for the suggestions, though!

Returns the same error message. Is it possible that the Object.send command does not like a string as input?

greetings all, I've encountered this runtime error when trying to put an xml file to constant contact's encrypted file server. I'm relatively sure it is an access issue, but really have no clue how to fix it. Below is the code i'm using with an xml 6.0 reference. The line the error occurs on...

Spikepl, could I use GetContactInfo.responseXML to get a single node from the document?

I gave what you posted a try, but didn't quite solve the problem. I did some more research and found a solution (shown below). This allows me to convert the xml into a string (note the authentification credentials) and then manipulate the string with some more code to extract the info I...

Greetings All, I've got this code to try and access some information from an XML file on Contant Contact's server. I can open the xml file in my internet browser, but only after i input the username and password. is it possible to modify what's below to include a username and password? I've...

Greetings all, I have a project where I'd like to try and sync contact records (stored in access) with constant contact's api stuff. I can't seem to find any VBA to do this on their support websites. Does anyone even know where a good place to go looking for code would be? Would there be a...

Greetings all, Here's some background on the issue: I have a form with 2 combo boxes. Each combo box has a list of cities in it. I have a query (MilesQry) that looks up the number of miles between the cities from a table. the form is continuous, so you can add multiple records to see how...

What I'm trying to do is somewhat strange, yes... There's a table with the names of our company's staff and another table with a list of the owners of the company. i was just trying to merge the two into one dropdown box so any of their names could be selected from one place - without much...

Hey Everyone, I solved the problem by using a filtered Dsum on the query that fills the form to fill the Amount variable and it worked. Amount = Nz(DSum("Amount", "MyQuery", "TransactionDetails.ID = " & Me!ID & ""), 0) Thanks for your help. This was a puzzler...