Search results

Thank you!!

now I'm getting the following error Run-time error 2448 You can't assign a value to the object I placed the above code in the Form Close

Hmmmm still I'm doing something wrong Private Sub ResetChkBoxes() Dim ctrl As Control For Each ctrl In Me.chkSendEmail 'Me.Controls If ctrl.ControlType = acCheckBox Then ctrl.Value = False End If Next End Sub I'm getting the following error...

I have a form with several records, the user is given the option to check a box if he want to send a email, what I need to happen when the form loses focus or is closed, how do I re-set all check boxes = -1 back to 0?? Thanks in advance.

I have a button that collects all the email addresses that have a check mark next to them. What I want to happen next is trigger a form to open, so I can select from a list of options (this is already built) which in turns runs a report which ultimately gets attached to my above email...

Thank you it working great now!!

Thanks I'll try it

not sure if a combo box can contain a null value I have two combo boxes I want to make sure the user fills in box one before going to box two here what I got so far: Private Sub ResetTxtBoxes() If cmbBox1 = Null Then Me!cmbBox2.Enabled = False Else Me!cmbBox2.Enabled = True...

ADO vs. DAO (or A97 vs. V2K) you we're correct, I was missing the DAO reference, but I still wasn't sure how to reference it to my database, so I took your advice and did a search on Google and dude you are sooooo right it is a great place to get info. What I found on google was a write up...

Lotus Notes if it helps, I did find examples of emailing with Lotus notes. Best of luck I'm onto building a better form search feature..

Lotus Notes if it helps, I did find examples of emailing with Lotus notes. Best of luck I'm onto building a better form search feature..

Found it!! and Attached the example not sure who build this but I think I'm in love....Good luck

okay I wasn't able to attach it but I'll get the name of it then you can do a search for it, if you still can not find it write me and I'll try to attach it again.

I did find it, it's really great see attached I'm a newbie so I hope I did the attachment right, if not I'll figure it out

Compile error: "User-defined type not defined" I split my database (Access2k) and then went into the front end to test my forms, now I'm getting the compile error, the form has a multi list select box (which I got from this wonderful site) and then you press a button to preview a report, when I...

okay I'll go check it...Thanks

yeah I know, if I can't figure it out, I'll use a diff. computer on diff. network. Thanks anyways

I Ran across a great example of selecting (chkbox) multi records and then click a button to send email and the email address were auto filled. Stupid ME didn't make a copy of it and now I'm going crazy looking for it... anyways it was a beautiful thing, does anyone know what I'm talking about...

Drag and Drop works great but how do I open a reports based on what I selected? I have two list boxes the first is "items not selected" and the second is "Items selected" now I want to create a button that open a report showing the result from "Items selected"?? Hope someone can help I've been...

I'm working in Access 2000, and everything was running great till yesterday....on my forms I have a simple count record calculation. i.e. =" The Number of Customers for this Educational facility = " & " (" & Count(*) & "" & ")" every time I'd open a form it would tell me how many records I had...