Want to create a button in Access 2010 that will use VBA to populate fields in Notes Form

[mhshane]

Hello. I am in uncharted territory when it comes to Lotus Notes so please bear with me.

I do plenty of VBA programming in Access but it all pertains to data within that Access database.

In a particular database called WATS, I track every event that happens with company wireless devices. User loses a phone, or cracks the screen, etc. I enter a new event in the Events table in WATS.

I need a way to use that info to populate the fields on a form in Lotus Notes to create an official ticket.

Here is the Notes Form:

Any suggestions on the VBA necessary to populate the fields seen in this picture from a form in WATS would be greatly appreciated.

Thank you.

 

[pmonett]

I would like to be sure to clarify one thing : the form in Notes is just a viewport on the content of a document.

I say that because I know that in the SQL world the form defines the record (more or less). That is not true in Notes.

Therefor, I believe that what you need to do is gather the field names and the name of the Notes form you need to use, and in your code, create a document and populate those fields.

In practice, that means go to the database design, open the form that is used to display the ticket, write down the names and type of the fields and the name of the form.
In your code, you will then create the document object, give it a field named Form with the value of the name of the form, and proceed to create the fields and populate them with the proper values.

Save that document object and you are done.

That is how I would approach the problem.

I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[mhshane]

Thank you for the info. Very good info. Much appreciated. I will probably have more questions but I will gather the info you suggested and create my first try.

Thank you again.