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!

  • Congratulations strongm 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: *

  1. scubadunc

    Search & Concatenate VBA

    Thank you What about if my original table structure is Fname Sname Address1 Address2 Locality state Postcode and both address fields required comparison Could you show me the modified code for that schema?
  2. scubadunc

    Search & Concatenate VBA

    Hi there Can anyone help. I have a database that has name and address details included. I need to find exact address matches, then combine the recipients names at the same address into one record/field with the following criteria: 2 people with the same surname at same address: Fname...
  3. scubadunc

    Truncate a text field into 3 text Fields

    Hi Duane The code works really well, although I get sporadic results when using the "&" character. Thanks again for all your help on this. Regards Duncan
  4. scubadunc

    Truncate a text field into 3 text Fields

    Thanks Andy and thanks Duane Duane, your code is just wat I'm looking for. Thank you so much, will test it out and let you know how I go.
  5. scubadunc

    Truncate a text field into 3 text Fields

    Thanks for the code Andy I can pass the variable "Entity Name" field into the function but how would I go about placing the outputted data into 3 or 4 or more separate fields within Access? I need to export the truncated data to ascii text for use within a DOS based environment. Thanks in...
  6. scubadunc

    Truncate a text field into 3 text Fields

    Hi there Just to reiterate, can someone show me some SQL that would enable me to split the below text into approx 40 characters per block, separating at the next available "&" char? An example is below: Original Data Entity Name M.R BEARD & D.C COCKING & R.L FEWSTER & S.L GILL & J.L NIGHT &...
  7. scubadunc

    Truncate a text field into 3 text Fields

    Thanks for your replies. I'm very rusty with access functions these days, any ideas on what the code should look like. The reason behind the requirement of splitting the fields is for a mail merge application in a DOS based environment (I know, I know get with the times right). But as you are...
  8. scubadunc

    Truncate a text field into 3 text Fields

    Hi there I have a database that has an "Entity Name" field which in some cases is ridiculously long. I need to write a query or VBA function that will allow me to truncate only those records that have more than 35 chars into 3 fields, splitting at either an "&" or " " char. An example is...
  9. scubadunc

    1 to Many Relationship - Create New table merging contents

    That was it! Now works perfectly Thank you very much for you help
  10. scubadunc

    1 to Many Relationship - Create New table merging contents

    Yes, I have copy and pasted the entire code into a new std module.
  11. scubadunc

    1 to Many Relationship - Create New table merging contents

    I have tried the code you suggested, and changed the SQL to the appropriate field/table names, however I get the following error when trying to run the query Undefined function 'Concatenate' in expression My SQL looks like this: SELECT AddressComma, Concatenate("SELECT MailNameJoint FROM...
  12. scubadunc

    1 to Many Relationship - Create New table merging contents

    Hi there I have a 1 to Many relationship between 2 tables where the primary key is a combination of the surname and address. So there is multiple people (parents, children etc) at the same address in my detail table. person1 129kensingtonst person2 129kensingtonst person1 30clasibrookrd...

Part and Inventory Search

Back
Top