Search results for query: *

I have this table with a name field. Unfortunately it has the lastname and first name together. Here is an example. Bateman, Ramey Bell, Leroy Schremmer, Stephanie All records have the comma and space. I want to have an update query that will take the last name and make it like this. The...

Hey Lilliabeth, that coffee must have worked. That code worked perfect. Thanks,

Yes, that was a big shy on details. The original Control Source formula would sum up all grades A thru D and give a final average of the courses taken and then divides the sum of more stuff. The latest formula did not give anything but a zero value. I didnt see any Sum. Keep in mind that I...

Thanks Lilliabeth for the quick reply. That worked in getting a 0 instead of #Num!, but it changed the calculation in my original Control Source formula. Thanks

Here is my problem. I have this report that I get a sum. I use this in my a text box called SumBox I put this in the Control Source =Sum(IIf([grade]="A",4*[hourscred],IIf([grade]="B",3*[hourscred],IIf([grade]="C",2*[hourscred],IIf([grade]="D",1*[hourscred],0)))))/Sum(IIf([grade] In...

This is so true fneily. My problem was this data was imported from an excel file that did not have the names seperated. When I design databases, I do my best to think ahead and that helps, but there are always things I dont think of. I am currently taking over a database that was created on...

Thanks everyone for the quick responses. TheAceMan1 your solution worked great. Appreciate it...

This has been posted, but is a little different than what I can understand. Here is what I have. A form that has a field called name. This field has lastname space first name ie "Johnson Larry" I have a 2 new fields I made that are empty. Called firstname and lastname. I want to populate...

Did you call your new textbox the same name as your memo field? No Is company the name of a field in the table / query which is bound to the report? Yes What happens if you type: ?replace("abc","b","a") Sorry I need more simple instructions. ------------------------------------ I...

I did as you wrote and when I ran the report it gave an error "Compile error: External name not defined" and it highlighted the [Company] in the module. I do have a text box called [Company]in the report I ran. Also, in the new text box that I created in the report it reads "#Error" and...

Thanks, for the reply. Actually there wont be any "[comp]" inside the memo except ones that we manually put in. Can you give an example of using he replace function you mentioned above. Im not a programmer.. Thanks,

I am sending out letters to potential customers. I have their [company] fields in the report. Also the name of the memo field is [memo]. In the memo is a whole page full of text. At certain locations (more than one) is the characters [comp] I want to replace all the [comp] within memo with...

Thanks spizotfl, it worked like a champ. Below is my final code. If DCount("Lastname", "Donors", "Lastname like 'A*'") > 0 Then Me.Filter = "Lastname like 'A*'" Me.FilterOn = True Else MsgBox "There are no records with this lastname" End If End Sub

I am currently using a command button to filter certain records to the form. For example. I have one button called "A" that filters all lastnames that are like "A" I have buttons A thru Z and an ALL button These work great, unless there is no Lastnames like A, then it opens the form in a...

Thanks dhookom, It works great. I use your examples except with the and instead of or. DSum("[dollaramount]", "[Student Scholarships Received]", "[socialsecuritynumber] = [forms]![Student Scholarships Received]![SocialSecurityNumber] and [name of scholarship] like '*plus*'")

I need some help. These 2 work. =DSum("[Student Scholarships Received]![dollaramount] ","[Student Scholarships Received]"," [socialsecuritynumber]=[forms]![Student Scholarships Received]![SocialSecurityNumber]") =DSum("[Student Scholarships Received]![dollaramount] ","[Student Scholarships...

Well that got it. A special thanks to Herman, Below is the code for my form and module. FORM CODE----------------------------------------- Private Sub SendEmailButton_Click() Dim rs As DAO.Recordset Dim strSQL As String Dim strSQL2 As String Dim strMessage As String Dim strNameSent As String...

Thanks for your help. Keep in mind that I know very little. What I have learned is from trial and error. I tried this and replaced my code with this in my form VB Code. It gave me the following error " Compile error: Invalid or unqualified reference" and highlists the ![Email Address] in...

Thank hermanlaksko for the quick response. After further thought, here is what I relly need to do so I can see who was sent an email, what was the name of the letter and when. This will be in a seperate table, with the following fields. TableName = MembersEmailsSent ID...

I am sending bulk emails as attached snap, "thanks to this site", now I want to add the date the emails was sent to each donor. Here is my code. Private Sub SendEmailButton_Click() Dim rs As DAO.Recordset Dim strSQL As String strSQL = "SELECT * FROM emailquery WHERE email = -1" Set rs =...