Search results

This is a VERY good idea! thanks for the advise!!! :D

I would like to click on button on a form to send an email containing 3 reports. I used the following: Private Sub CmdEmailScoreReports_Click() On Error GoTo Err_CmdEmailScoreReports_Click Dim stDocName As String stDocName = "RptNegativeResponsesByProject" DoCmd.SendObject...

errors in the

dimwits, dweebs and

and thereafter prohibit

to these seemingly

was scheduled that

and travel lodge.

minions he employs

Tried that - Survey Number = 0 and does not increase. :confused:

I need a little more help. I was going to try this code: NextNumber = Nx(DMax("[SurveyNumber] = '" & me.SurveyNumber & "'"), 0) +1 I don't know where to put it. BeforeUpdate?

Blush I was just informed of my error in another post. When I embarrass myself I do it up right! sorry again! :o

Oh (hits self in forehead with palm of hand) DUH! So very sorry to Pat!!! Pardon me! :o Now I know, won't do it again!

Who's a she???

Thanks Rich, I'll do a search on that.

which jams repeatedly

Reading this has made me realize that I have not sufficiently thanked ALL OF YOU who have helped me. When I first started learning Access (and I know I still have a loooonnnngggg way to go, Pat Hartman told me to read about normalization. She said I was treating Access like Excel and SHE WAS...

Yes, it is an autonumber. I didn't think of that. I have written a delete query to remove these instances from the past. I was hoping to stop the problem. Thanks anyway!

I've been reading about blank records and have tried a few options found here but have not solved all my of problems. (I tried going to the table and making them required fields - didn' t like that, so I used Pat Hartmans 'if statement': If IsNull(Name) Or IsNull(Office) Then MsgBox "Record...

That doesn't do me a lot of good if I put bogus information in the fields. I can type XXX and an unused survey number and I still get a success message. I want to know that the correct information was removed. Perhaps I going about this the wrong way.