Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Hillbillie
  • Content: Threads
  • Order by date
  1. Hillbillie

    Getting lastname and filling rest with blanks.

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

    #Num!

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

    Get Last Name from (Lastname Firstname)

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

    Insert info memo field

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

    Filter form

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

    DSUM combinning 2

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

    Need to add "Date email Sent"

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

Part and Inventory Search

Back
Top