Search results

Hi all, I have a situation that has me puzzled, and I'd like to see if anyone has any suggestions. I have an Access database that runs daily, and periodically needs to archive certain tables. I'm trying to write the vba code to do so, but I'm getting Run-time error 2507 - "The type isn't an...

I wrote VBA code to pull email messages from Outlook in order to create an alert if a message with a specific subject line is not received. I have the system coded to send the alert if the message isn't found before the system encounters a message with a SentOn date/time more than two hours old...

Hi all, I'm new to the forum, at least as a registered member. I've used the forum many times in the past, but have finally decided to register and start posting questions. I've been coding in Access for about ten years, but I'm definitely not an expert, so I anticipate asking more than I...

Has anyone encountered a situation where the Date and Time functions in VBA are not using current data? I have VBA code that uses Time to determine certain actions. A new associate took a copy of that code and started tinkering with it to complete a project I assigned. Now, his copy of the...