Recent content by GeminiG

Ok I see the problem, i need to put this on the new form. Thanks for the help!

Sorry, thanks for the help and your patience. I changed it to this: strSQL = "INSERT INTO tblEventException (OrigEventDate) VALUES (#" & Forms!frmEvent!frmEventSub!EventDate & "#);" The result in the immediate window looks correct, but I get the error unable to save record at this time.

Ok now I get an error that my syntax is not correct. What am I missing? strSQL = "INSERT INTO tblEventException " _ & "VALUES OrigEventDate = #" & Forms!frmEvent!frmEventSub!EventDate & "# " _ & "WHERE " & strWhere Debug.Print strSQL CurrentDb.Execute strSQL...

Ok so then the update won't work because there are no existing records. How do you write the Insert/append statement then?

Hello, I have a database and I can't figure out how to take a field from a subform and then add that date into an existing table. The frmEvent has a subform. (The subforms data is based on an un-updateable recordset from a query) When the user clicks the EDIT button I want the EventDate from...

Thanks Cronk I'm getting closer but I don't think I'm putting the code in the right place. Here is my code, i've also attached the database. Private Sub cmdSendTask_Click() Dim outlookApp As Outlook.Application Dim outlookTask As Outlook.TaskItem Set outlookApp =...

Sorry I do want to send just ONE email to only the selected email addresses in the listbox. The list box is based on a previous combo box query. All the code examples I can find only send to all email addresses in a table or distribution list. I want to specifically send only to emails the user...

Hi All, I'm assuming the above should be fairly simple but I can't seem to get the "TO:" in my VBA to populate the selections based on a list box. I'm a beginner user. Can somebody please post an example of how I can refer to the listbox results in code? Many thanks in advance for any help you...

Hi I'm a beginning level programmer mainly customizing Access databases at the moment. There so much to learn :eek: and so much Access can do now that I'm learning VBA. Hope I can also offer some assistance as I gain more knowledge. Looking forward to becoming part of the community! :p