Search results

It's now working like a charm.... 'New Working Version of the Code Dim varDM As Variant varDM = Me.txtDLDMemail If Me.chkDM.Value = -1 Then DoCmd.RunSQL "INSERT INTO tblTmpRecipients ( TotalRecipients ) SELECT " & " """ & varDM & " "" AS txtRecipient ;" ElseIf...

Private Sub chkDM_Click() Dim varDM As Variant varDM = Me.txtDLDMemail If Me.chkDM.Value = -1 Then 'original code not working 'DoCmd.RunSQL "INSERT INTO tbltmpRecipients ( TotalRecipients ) SELECT " & varDM & " AS txtRecipient;" 'New code not working either DoCmd.RunSQL "INSERT...

Can't empty the recipient text box.. The purpose is to send mails to multiple person. For example, it may go to district manager, financial advisor or what have you. me.recipients="" will empty other e-mail addresses that are being populated in the txttotalrecipients text box. If you see my...

I will try Wayne's suggession.... Thanks Wayne, I will try your suggession and Give you my feedback. Just wondering, what if user decided to uncheck a box, how will i remove the e-mail address from that text box.

collect e-mail addresses to one text box... Is it possible to check boxes and dump e-mail address to a text box bound to nothing? I attached a printscreen for clarification. Please suggest.... My thought, create a field in my memo table "tblNotes" called "Recipients" and append e-mail...

try this... maildoc.copyto = ccrecipient for more information go to http://www.fabalou.com/vbandvba/lotusnotesmail.asp

Send Mail from Access 97 when Client is Lotus Notes http://www.fabalou.com/vbandvba/lotusnotesmail.asp - Source Code call sendnotesmail, use this behind a command button to send mail. and put the following code behind your form. Assuming you have lotus client (mine is 5.0.8) you can modify...

Hi, I have a log - in form. I would like to put a button called "Forgot Password". When user click on "Forgot Password", the system will then take the user to another form "frmForgotPassword". User will then pick the user id from combo box "cboUser". (the data for user is coming from...

I Fixed It.... Thanks To Me... Yeahhhhhhh. I Fixed The Problem.

Did not work... I think that is what I had in my original script. Let me know if you can think off anything else. Thanks

Please help. I am in a serious crisis. Almost all the portion is done, excepts few. I am attaching two database. The one with Bug is mine and the Security Original is my master copy that I downloaded from here. When I load the form "frmrptinvidualdashboard" the me.cboadmin.enabled=true and...

More Tune up Now I only get the the real error message but twice when i leave the password blank or incorrect. MsgBox "You left the User Name and/or Password blank." & Chr(13) & _ "Please enter the correct User Name and Password or " & Chr(13) & _ "contact the Database...

Hi, I am using following code to verify user. It's working. But when user put a wrong password they get two error. Please open errors.zip to see those errors. picture 1 comes first then picture 2. for the first time when u click on picture 2 , the picture 1 pops up again and then picture 2. (so...

Hi, I KNOW I AM NOT GOING TO GET ANY HELP FROM HERE, BUT STILL TRYING. I am trying to customize a sample database to cater our needs. Your input or help will be VERY MUCH APPRECIATED. I spent two days on it but did not accomplish much. Goal 1. There is a performance report which is password...

Does anyone know any newsletter (or mass mail or bulk mail) software that will work with our MS SQL database. I know one called mass mailer, but one has to import all the data. I dont want to do that every week. I want to be able to connect to MS SQL database from the software and shoot e-mails...

Our company updated some MDAC from older (original access 97) version to MDAC 2.7. And now some users can NOT access 97. They are getting all kinds of error. Does anyone have any idea without reverting MDAC to older version?

Check.... Visual Basic for applications is checked Microsoft Access 8.0 object Library is checked Microsoft DAO 3.51 Object Library is checked

I have about 40 users using my database. None of them having trouble with CurrentDb code, except one guy. He used to be able to run the report (until last friday). Now he gets an error. Any idea why the CurrentDb is highlighted. I am assuming that the library got messed up. and suggested him to...

Try Dev Ashish Sample database... http://www.mvps.org/access/forms/frm0045.htm It worked for me. Excellent source database for your purpose. Good Luck

agrs Hi, you can use agrs to pass values from forms to forms. Good luck