Recent content by bloomy555

YES IT HAS.........I have been in your place before.

I am not getting the format of your table is it like this: EMPID EMPNAME SDATE EDATE TDAYS DAYS You said first there are 2 columns in your table..now you are saying there are others?!!!!!!!11:confused::confused::confused::confused::confused:

I don't know if my answer is correct, since I didn't get your question well. can't you try to resort the lastname column in the Names table, so when you found one the others will be just below it.

add this code to a button on your form: dim db as DAO.Databaase Set db = CurrentDb Dim rc As DAO.Recordset Set rc = db.OpenRecordset("nameofyourquery") 'the name should be without spaces Text1.Value = rc.Fields(0) of course, you should have DAO added to the reference of your Access VB.

I am not sure that I have understood your problem clearly. you said there are 2 columns in your table.....aren't there any columns that represent employee's name, ID...? or what? ???

I think I will do the same as you, using numbers for logical values can get some confusion! like what happened to me. Thanks again

Yes, I changed the edit message value to 0. I've tried before to change the value from -1(default) to 1, but It didn't work. I didn't know that the value should be 0.........anyway I have changed it to 0 and it is working.........Many Thanks.

Hi........I have managed to generate an email by using "docmd.send object" command......the problem is that, this command generate an email and open the Outlook for me, but I have to press "send" from the outlook in order to send the message..........what I want to do is to skip that last step...