Search results

Good catch !! i'm used to my personal laptop where I can turn the Function Lock on and off so I don't even think about have to hold the Fn key. That was the exact issue here as my work laptop doesn't have the Function Lock !!

I figured it out, .SendOnBehalfOfName ="email address"

Is there anyway to specify a "From" line in the email code? This will use the individuals email to send it, however I would like any replies to go to a group email address. Any thoughts?

Thanks for the feed back and I get not using reserved words as Field Names, this was just one of those things I threw together to get it working. I will rename the table columns on my Production DB. Also a good idea to state that the process is completed !! Thanks again !!

dumb da dumb dumb dummmmmmmmb. first round s = 4th Friday second round s = 4th Friday4th Friday third round s = 4th Friday4th Friday4th Friday Reset the values each round and bingo I usually set a message box to display these types of things, but didn't this time for some reason!! thanks for...

Got it, so now the question is why does the IF value not hold true for any other records....

i'm aware of F8 and setting breakpoints, but for some reason its not playing nice and when I hit F8 it brings up my monitor settings, even though i'm in the VB window, so I tried to just click Debug > Step into which isn't doing anything either

Guess i'm lost on the corrective actions. Apparently i'm not aware of how to do it as neither the Step Into or Run to Cursor is working....

The outlook object closure is only there because I copied the code from another section where I am sending an email only to 1 person and then closing it. I did forget to remove that from here, but I did try that and still the same result. I was wondering on the outlook thing too, but if that...

not letting me upload a .accdb file, so its in a zip. I commented out the query and just made the table that it is looking at

same results, just the first record

There is no .Send currently as I want to make sure it works so I am only displaying the emails

same result, generates an email for just the 1st record

I have a query that builds a table called FacilityMXEmail and then I search for day/week validation and if that is true, I need to send an email to all contacts that match. What I currently have is only generating an email for the first record. Private Sub EmailTest_Click() Dim rs As Recordset...

On one of my forms, I have a report that is generated from 3 queries, which are based off of a couple fields from the form, then displays in print preview and saves to the network as a PDF. After this is completed the form closes. This all works fine, but when trying to print the report from...

All thanks for the responses, I posted this question and then had something come up so I'm just getting back to it. Arnel's post is exactly what I was looking for, I will try to implement it sometime this week and if I run into any issues, i'll be back !!. thank you

I'm stepping outside of my comfort zone on this one, and would like for my database to kick off some alerts based on the day of the Week/Month when the main form is opened. The alerts would be set based on the 1st Monday, 1st Tuesday, 2nd Wednesday, 2nd, Thursday, etc. I found the following...

Works perfect !! thanks for your help

I am trying to add a few new reports to my DB and am running into some issues with my count query below on one of them SELECT FacilityNames.[Facility Name],COUNT (FacilityTickets.TicketID) as TotalTickets,COUNT (FacilityTickets.Resolved=1) as ClosedTickets FROM FacilityTickets JOIN...