Search results

So the address isn't getting updated. The purposed of the activity driven by the Sub is to send an email to someone with instructions and documentation on reimbursing some expenses. The email includes: who, what, where, why and how. Every single one of the fields in the Query are required to...

So, interesting development: Changing the query from Dynaset to Dynaset (Inconsistent Update) let me alter the field in datasheet view, but still gave me the 3027 runtime-error when trying to update the Recordset via the Sub. It's demoralizing to discover how little you know about things.

Per my original post, the problem was: I used to have one query that I used to create a recordset to generate an email and then could UPDATE a field in that recordset to show the email had been sent. When I added in the address join (that is now needed in order to get an address as part of the...

This is what I did to find that the tblSubjectAddresses join was the issue. I had removed the tables joined to that table (Countries and Regions) and that didn't fix the issue. Once I removed that join, I was able to edit the field in datasheet view. Not that I found, but maybe I'm missing...

Makes sense. I just couldn't find it.

Sorry, I just copy and pasted from Access' SQL view. I didn't know there was a SQL formatter. It could be that one of my joins isn't a PK, but I looked and couldn't identify one that wasn't.

I'm not sure what you mean by using criteria instead of a join for the addresses. The table was added because I needed data from it for my recordset, but that table isn't edited. I'm a self-taught, moderate user, so my apologies for not understanding your comment. I've been learning by...

I have a query from which I create a recordset which I then use to build an email (requesting payments be sent). If the email is confirmed sent, I use rs.edit / .update in VBA to mark the needed changes which will then remove the record from the request queue. This has been working well for...

Update: Based on further searches, I got to here: https://stackoverflow.com/questions/1927799/iterating-quickly-through-outlook-appointment-items which links to here...

Can you also state how it was moderated, so that I know what is offending?

This is my 10th post, so here's the link to the original code used to find Outlook Calendar Items: https://www.mrexcel.com/board/threads/vba-macro-to-check-for-calendar-items-in-outlook-and-update-if-details-changed.832092/

So I found this at another site: Cannot post link as I only have 9 of the 10+ posts needed. I've adapted it to run after my item is Saved or Cancelled. It takes some time because it searches through all the calendar items, but it works. I just wish I had something more efficient or easier...

Yes. Cross posted. Thank you for putting the links cross-post links in each thread. I meant no offense. I tried your suggestion of checking for AllDayEvent, since I'd set that for True. On Error Resume Next CreateCalendarItem = .AllDayEvent If Err = 0 Then...

Yes, same post, different site. Are these sites the same? If so, I didn't know that they are seen by all the same people and was trying to expand my audience to increase my chances of getting assistance.

Hello, I've got a function set up wherein I take HTML-formatted text that I've created in Access (it's a travel itinerary) and send it via Outlook. As a part of this function, the email is displayed for inspection, then, if sent, it captures that fact (boolean) so that I can acknowledge it in a...

That seems to have done the trick! Thank you so much. I was using code that I'd seen from another Access site on how to Execute a parameter query, and thought that the syntax was there to include the query name. Clearly I misunderstood something. That saves me putting together a mock database...

I altered that, too, but I still get the error.

I don't think that I can, as it's a pretty big database with with tons of private information in it, and this is only one small part. I think it would take me longer to figure out how to do that than it's worth my time or your time in going through it afterwards. Maybe I can create a simple...

I tried: qdf.Parameters(0) = "#" & dtClose & "#" and qdf.Parameters(0) = "#" & Format(dtClose, "mm/dd/yyyy") & "#" and plain qdf.Parameters(0) = CDate(dtClose) No joy.

Thanks for the reply. I did attempt that, or so I thought: qdf.Parameters(0) = "#" & dtClose & "#" Did I miss something? Actually I might have done it as: qdf.Parameters(0) = "#" & CDate(dtClose) & "#" So maybe that's where I went wrong? I thought I tried various combinations of the above...