Search results

I currently have a email blast database that I can loop through and send out text. I would like to add our company logo to the email and not as an attachment. I would like it to be right under the text. here is a copy of the body of my email as it is right now. strMessage =...

How can I add attachments to outlook express using access code. I have my code to loop through the email database and send simple text or I can attach a report or table as RTF, HTML etc.. what I want to do is have a command button called attach and when I click on it I can browse my hard drive...

Thanks. that bit of code worked fine. I will use it. Thanks again.:D

I want to be able to have a msgbox pop up if no records were found. I tried a couple of things but they did not work. Here is my orignal code without my added mess. Can someone give me a hand. Thanks. Private Sub btnFindFirst7_Click() Dim MySrchString As String If IsNull(Me.txtSearch7)...

I solved my problem Just in case any one is wondering press the alt + 0174 will insert the registered symbol also alt + 0153 for trade Mark and alt + 0169 for copyright. :D

Is there a way to put into access text the trademark symbol of the circle with the little r inside the circle...something like (r). :confused:

Please someone help me out here Can any one give me a hand here. My eyes are red and have a bad headache trying to fix this.:confused:

I have code that will use a query "MemberKIt" and merge it with word, then it will uncheck the MemberKit check box on the Member form and puts a check on the sent box. My Problem is after the merge is done and the letters print out word will ask if I want to save the letter and then will ask if...

Answered My own question I put in the following code after the table was created: Set qdf=currentDB.createQueryDef ("",strSQL) qdf.execute worked...:D

Need help with filling a table using VBA. I created the table fine but Having trouble with the sql string to fill that table with the information form the Order's table. All I want is that one field to be populated with that same field from the order's table. Function MakeTable() Dim db...

thanks David, that does work better and you are right about using any string with four letters or six. The chapter I just finished reading was dealing with left$, Right$, MID, and LEN maybe that is way I was trying to use it. Thanks for your help.;)

David R, thanks for your help. I'm new to VBA and I'm practicing with the book "Beginning Access 97 VBA Programming". I created a database at work and added code here and there to make it somewhat automated by searching this website and other Access sites. I finally decided to try and learn...

I tried that and does not work. It will still run and set the font to bold.

I'm trying to code a command button so that when pressed you will see a input box that will ask you if you want to change the font to bold or italic. I have that working but if you do not type nothing and hit ok it will bold everything. What am I missing from my code. If you do not type...

thanks Thanks I will give both a shot and let you know how I made out.:)

I'm having trouble with what might seem to be simple coding for the seasoned VBA pro. What I want to do is have a number entered like 127 and then have it show as text like One Two Seven. Can any one help me out. My example code is below. Dim MyNumber, MyText MyDouble = 127 MyText =...

Thanks for your help Fizzio. I apologize for posting the same questions. Your suggestion works, thanks again.

Have two check boxes. 1. sendemail and 2. sentemail. I have a cmdbutton to send email to everyone in database that was checked off for sendemail. I want the code to then clear the sendemail checkbox and automatically check the sentemail checkbox. Right now when you check off sendemail and...

Good day everyone. Here is my problem. I have a event form with participants information including emails. I made a qry that has their email and send email (Yes/No field) and sent email (Yes/no field). Qry is set up to show if the sent email is not checked off so if sentemail is yes it will...

You can try this. On your form go to the Timer Interval and set it at 1000. Then on then put the following on the ONTIMER event: If Me.PendingMember = -1 Then Me.CancelDate.Visible = True Else Me.CancelDate.Visible = False End If You can play with that. The -1 can be yes or is notnull. Try...