INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

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

(OP)
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.

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

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.

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

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close