Search results

Hello. I'm wondering if I can use conditional formatting on a form when I'm looking for only partial text in a single unbound textbox. I can do this with VBA but was wondering if it can be done via Conditional Formatting, in case I want to do it that way in the future or in other instances...

Hello, I'll try to make this clear, but I'm not sure if I'll be able to. Maybe I've got too much background, but I don't know how else to get an answer without giving the context. I hope it helps. I'm using Category, Product and Type as my data buckets, but that's for simplicity of explanation...

Hello, I've got a workaround for my problem, but I'm trying to learn about what it is that I'm missing. Here's what I ended up with, and it works just fine: Private Sub CheckAndProceed(bytRequest As Byte) ...Stuff happens to get the the select statement... Select Case bytPreCheck Case 1...

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...

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...

:confused: Well, I'm flummoxed here. I'm trying to execute an append query in which I use an input box to get a date I'm adding to the data. When I run the query outside of VBA, I am prompted for the date and it works as expected. Not so much when trying to execute it through VBA. I'm trying...