Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm new to MS Access. I have a web app that needs to interact with an Access database. I want Access to get the affected row's data after the form is updated, and pass it to a script that will url-encode the values and make a POST request to a remote server.

Once I have the data, I know how to process it. The part I don't understand is how to get all the columns and values from the updated row. My understanding is that I can define a callback on a form event as follows:

 formIdentifier.AfterInsert = "callbackFunction";

But my question is, how do I access all the form fields of the inserted row within callbackFunction? Do I need to pass it the form object? I've been crawling through the documentation but can't find what I'm looking for. Is this the wrong approach? Should I be doing an XML dump instead?

Thanks in advance!

share|improve this question
Do you know how to pull the PK from the inserted/updated record? If yes, you can create a query to pull the specific record you want, then pass it to a recordset object in VBA. Once your recordset object is created, you can access each field by name. – gangreen Aug 28 '12 at 6:10
Is this an MS Access webapp hosted on Sharepoint? If not, what is it? Please add some more tags. – Remou Aug 28 '12 at 10:05
I don't know how to get anything from the updated record, that's what I'm asking. Yes the PK would be exactly what I want. – matthewdavidson Aug 29 '12 at 16:26
And no, it's not Sharepoint, and I don't see why that would matter. – matthewdavidson Aug 29 '12 at 16:27
When you say access form, do you mean an html form for data from an Access database, or an Access form object contained in that database? – HansUp Aug 29 '12 at 17:13
show 1 more comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.