Search results

I may of misunderstood your question the first time. If you have the form open and the email address is in a field. This may work: Put Me.YourFiledName in the To part of the SendObject argument. Just use your field that holds the email address in place of the YourFieldName. In code you would...

I could be wrong but I don't think you can accomplish that with just a macro. See this thread for instructions of how to do it with code. Topic: Emailing System Help

I loved that! I think I am going to start with Ken's explanation and work my way toward Fornations. As of yet, I am still not sure how I am going to get the end results I need. I think I should break this problem down in steps. The first step is to get the code letter of each position in the...

Thanks everyone, it's the weekend now so I won't be working on this again until Monday morning. I will either be back for more questions or I will post what I come up with using the recomendations above.

I have strings that can be any combination of the following: HHHHHHHD HHHXHHHD HHHHDDDD I need to be able to parse them into meaniful messages to the user. This is very complicated so I am going to post the rules along with this (It's a brain teaser). Overtime is represented as a eight...

I am stumped on this one, sorry! Anyone else?

You should be able to modify this to work: Private Sub Command130_Click() If Me!frmLoggedOn.Visible = False Then Me!frmLoggedOn.Visible = True Else Me!frmLoggedOn.Visible = False End If End Sub When the command button is clicked it first checks to see if the...

raskew, I give Ken all the credit. I had no idea of how to get to the end result I was looking for. I still don't realy understand what is going on in the code he gave me. But it worked and that is what is important. Thanks Ken, As I said the problem was with my logic. The real purpose of the...

Never mind, I got it. The math logic I was originaly using was not correct. Dim WeekEndDate As Date Dim PayDayDate As Date Dim MyDate As Date MyDate = Date WeekEndDate = DateSerial(Year(MyDate), Month(MyDate), Day(MyDate) + (7 - WeekDay(MyDate))) PayDayDate = DateSerial(Year(WeekEndDate)...

Still there?

Can you post the code you are using to do this?

Ken, I don't understand any of that so I am going to post the code as I have it now and tell you what it is doing. Dim WeekEndDate As Date Dim PayDayDate As Date Dim MyDate As Date MyDate = Date WeekEndDate = DateSerial(Year(MyDate), Month(MyDate), Day(MyDate) + (7 - WeekDay(MyDate)))...

Thanks Pat. I think I finaly have it now.

Our payroll week ends on Saturday and Payday is Thursday. I am looking for a way to get the date for the next Thursday and Saturday following the current Date(). Any ideas?

I got it, finaly. Thanks! Say I want to grab the name of the field and put it in the message box. How do I get that from the MsgBox (ctl.[THIS] & " Value required") Edit<--- I figured this one out, ctl.Name. Thanks anyways.---> End Edit [This message has been edited by Talismanic (edited...

Rich, what am I missing. I have the function in its own module, I have the tag properties marked, and I have entered data but it still doesnt work. You mentioned that the tag should be AlphaRequired or NumberRequired. Doesn't this evaluate the tag property If InStr(1, ctl.Tag, "Required") > 0...

Ok I added the Required to the tag but Access is still letting nulls or empty strings get through. I added the new function from the forms code window, is that where it should be? Shouldn't I be calling the function from somewhere? If not when should the fields get their evaluations?

So I have to write code for both events, the forms catches entry problems and the fields takes care of messages and formatting. I don't understand this at all because the cursor is placed in the textbox, nothing is typed but there is a tab in and then a tab out. Isn't that considered focus...

Rich, How do I use this in my database. I have added the Function and now I need to start testing for it. What do I do next?

Rich, I assume you are referring to this thread, Topic: Validating fields before record update. My project manager wants the fields checked instantly and a message sent to the user instead of doing it at the end of the record entry. It would seen that there would be an easy way to catch a null...