Search results for query: *

I have non access users who will update and edit data in a access database stored on a shared drive using form menu's (navigation) I create. I don't want them to see the back end or use those items and would also like to hide the side navigation panel. Is this possible with access 2010 and if...

Yes that syntax works great. I see I need to learn some VB enough to get through this. Your help is greatly appreciated. I did not want to go this route unless I was sure I could send the form data through email upon entry since that was a requirement. Thank you again.

i see now. I put the field in the body statement and it show up. How can I add more than one field my syntax is wrong. OMG thank you so much!

I wanted to send the firstname and lastname fields. I am trying to figure this at a very elementary level before I try to use it with a real project.

Yes that worked and it's sending the email and it is updating the table but it's not sending the form data in the email. Here is my code. Private Sub AddRecordButton_Click() Dim firstname, lastname As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem '**gathers...

i am using the code from a prior thread and I am running into a problem with the .To = email part of the code. It gives me an error message that says there must be at least one email address in the To field. I don't want to pull this from a field I would like to just hard code an email ID into...