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...

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)...

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:

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...

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...

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...

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 =...

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...

I want to have a seperate search form using unbound text boxes. I'm currently using Combo boxes as my search and the following code. docmd.openform "Members",,,"[MemberID]= "&Me![combo2].column(0). I would perfer to use txtboxes so that if a user enters something like MICRO the database...

I have a main form with a synchronized pop up form named Payments. On the main form I have a unbound text box that shows amount due. When I enter new payment info in the payment pop-up form for the first record for 100 dollars and the dues payment = 100 dollars the main form will show amount due...

I have a mail merge button with the following code. Dim objWord As Word.Document Set objWord = GetObject("G:\MSAPPS\Share\Dueshor2.doc", "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the mail merge data source as the Northwind...

I have a main form with a synchronized pop up form named Payments. On the main form I have a unbound text box that shows amount due. When I enter new payment info for the first record payment for 100 dollars and the dues payment is 100 dollars the main form will show amount due 0 (good). For...

How can you have your table clear some fields exacly one year from now.

I have a main form with a payments form attached by member number and a order form also joined by member number. The payments form has amount of product, deposit, payment1 payment2 and amount due. All these feilds are in the payments table. On the payment form in the control "amount due" I...

Bascially what I want to do is this. On a Membership form I have a drop down list that puts companies in their membership catagory. If you select the catagory of Former Member the form changes color to lets say red but all the other member records stay the same. Any Help???

I have a Main form with a couple of pop-up forms on it, one being a payments form. On the main form I have a field total amount paid that reads off the payments form field amount paid. This works great for one payment but if I add another payment for that person the main form is still reading...

I have a databse with one main table and other link tables all one- to- many relationships. I made a qry using three tables the main and two of the many side tables. I would like to make some data entry to the qry that will update the main table. When I enter in a new date into the qry it...

In my membership database I have popup forms within the main member form. One of the popup forms is a form called phonelog. Within phonelog lets say I might put call this cusotmer back on Wednesday. I would like to click a checkbox that will set an alert for me so the next time I start the...