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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by haygordon

  1. haygordon

    Use command button to import new records

    I have to import and excel file with 3 columns, all of which match columns in access table1. The excel file is named newdata.xls and data is in columns a, b and c. Is there any way I can import this in to table1 with the user simply pressing a command button? I find that access frequently...
  2. haygordon

    Update query SQL error

    Thank you PCLewis for an excellent piece of help - the code ran a treat and I can now modify it to extend the updates required. Congratulations of you Tek-Tips award, you deserve it. Gordon
  3. haygordon

    Update query SQL error

    Sorry, my use of English made it unclear. I want to update the existing data in table1.outteacher with the data from table2.teacher The data has to be found in table2 and copied to table1. The conditional field in table1.yeargroup I do not want to create extra records. Sorry if I confused...
  4. haygordon

    Update query SQL error

    In table1 I have a field "Teacher" and I want the data from row 4 to be inserted into table2 "outteacher" where the "yeargoup"= 6P I have tried this sql code: UPDATE Table1 SET Table1.Outteacher = Table2.teacher.[tbl2ID] = "4" WHERE (((Table1.Yeargroup)="6P")); Thereis an error but I can't...
  5. haygordon

    Getting rid of excess blank spaces.

    Thank you aceman1 and PVH Both code versions worked perfectly and I will now have a happy bunch of teachers with less work to do correcting their annual reports. A few seconds saved makes up a lot of time for some who are writing 500+ reports. Thanks once again. Sheer brilliance that I...
  6. haygordon

    Getting rid of excess blank spaces.

    Aceman1 - your function has very nearly got there. I still got multiple spaces but I added an extra space to the fixspc line to give 3 spaces to check for and it worked fine where there are just one outcomment and one outjoin fields that are blank before the next selected outcomment or outjoin...
  7. haygordon

    Getting rid of excess blank spaces.

    Wow PHV, nearly there but a minor bug I have tested it with: =[forename] & IIf(Trim([outcomment1] & "")="",""," " & [outjoin1]) & IIf(Trim([outcomment2] & "")="",""," " & [outjoin2]) & IIf(Trim([outcomment3] & "")="",""," " & [outjoin3]) & IIf(Trim([outcomment4] & "")="",""," " & [outjoin4])...
  8. haygordon

    Getting rid of excess blank spaces.

    Thanks PHV - I tried the amended code but got a message box saying it wasn't valid. My code is in the textbox, is yours intended for the same location or am I missing something? My problem is that the blank spaces might be 2, 3, 4 or even 5 in number.
  9. haygordon

    Getting rid of excess blank spaces.

    I have a textbox that gathers information from many fields using the code: =[forename] & " " & [outcomment1] & " " & [outjoin1] & " " & [outcomment2] & " " & [outjoin2] & " " & [outcomment3] & " " & [outjoin3] & " " & [outcomment4] & " " & [outjoin4] & " " & [outcomment5] & " " & [outjoin5] & "...
See more

Part and Inventory Search

Back
Top