Search results

If you found a way please share. I have this on every form and have to maintain a form access table. I have no issues with form.close, but might change to cancel=true. Is there any advantage to it?

Hi Gasman, I found an issue with the last code (one my loop didn't work, and even though it was adding values it was still causing problems). I've pasted the new version in my edited comment above. I had to adjust my brackets for If (fld.Type > 100) Or ((fld.Attributes And dbAutoIncrField) >...

I ended up figuring it out since the If statement i think wasn't checking properly. so i move the i = i + 1 to the area where 'nothing was listed. Private Sub EmailTemplateWithMergeFields_Click() Dim objOutlook As Object Dim objOutlookMsg As Object Dim ds As DAO.Database Dim rs As...

i suppose you can't. I've changed it to (0 to i) but the same error occurs. I didn't originally produce the code as it was provided as an option for my initial question. I'll try and break it up into a small database later and upload it without any important information. I don't think it's...

yes i = 0

Thanks arnelgp for this. I'm having a subscript out of range error on the line "ReDim Preserve arrFields(1 to i)" I've copied my existing code below for reference. Private Sub Command150_Click() Dim objOutlook As Object Dim objOutlookMsg As Object Dim ds As DAO.Database Dim rs...

Thanks. Ill post the code for my email that replaces the merge fields. I'm thinking of looking through the tblMergeFields which has the naming convention of what should be found that needs to be replaced. I was also thinking it would be a function that has a loop to replace the text but was...

Hi there, I'm working on a Email Template maker for part of my contact database. I have a working prototype that will work but for any additional merge fields will involve a lot of editing in multiple places. Right now users can create a new Email Body which they can add merge fields (using a...

Hi everyone, I've been using this forum to search on issues I've had with some success. Maybe I should just start to post my questions! I've been working with access for about 7 years, but only been using VBA the past 3 for work. I'm still fairly new, and love when I figure out something new...