Automate XML Import to Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a PDF form that emails XML data to a specified account.
When that data arrives, I save it to a folder and import the individual file
to Access 2003 via the Get External Data menu command. The form is set up to
identify the same table name as in the DB.

Since this DB will be deployed as an application to a limited number of
individuals who are not advanced users, can anyone suggest an automation
technique or approach? I have investigated both macros and modules without
success (I'm not a VB developer).

I would like to avoid a web application because the environment I intend to
install on is Apache using PHP. I suppose I could make a MySQL version of the
Access DB, but that kind of defeats the purpose at this level... Having said
this, I am willing to entertain all reasonable suggestions.
 
Ok, I think I've found some VB that will let me do bits of the import, but
I'm not sure how to apply it to a button's OnClick event. When I go to the
properties of the button, it doesn't recognize the module's function name.
I've tried embedding a call to the function from within the button's own
script (e.g., the script that comes up for editing when clicking on the "..."
in properties window).

Still stuck, though. Thanks for any help/advice!
 
Back
Top