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 Chriss Miller 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 SeanDagger

  1. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Thank you Thank you Thank you. You are a STAR!!!! All is working beautifully now thanks to your help. I would have never done this on my own. I have now set up a macro to open the module and perform the code. Works great. Thank you so much, can't thank you enough. Bestest regards Sean.
  2. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Also It seems that I have results such as: 100 Northumberland, Northumberland, Northumberland How would I make this only appear once? So sorry for pestering. I'm rubbish at this but i'm learning a hell of a lot.
  3. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Wow you are a star. Very almost there. It is inserting the data and concatenating as it should. However it is adding commas even if the field is blank. for example: 100 Cleveland, , , , , , , , , Newcastle, County Durham 200 Northumberland, 300 Newcastle, Northumberland some...
  4. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    This is the section of code that is always empty. it is not concatenating or inserting into temptable? Do While Not rs1.EOF = False vStore = vStore + ", " + rs1!COUNTY__C rs1.MoveNext Loop
  5. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Many thanks. I reallly appreciate you helping like this. This is the code I now have in the module, I am tesing it within the module with the debug tool. It is inserting the clientids in the temptable no problems (now I added the v3.6 DAO library). However, it keeps telling me that there is...
  6. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Finding it difficult to work out what to do. My details are as follows. Database: CustomerDataConvert.mdb Table: DevelopmentLeads Fields: ClientID and County (both type text). If I make a module, do I change it to be a function or keep it as a Private Sub Command0_Click()? then do I make a...
  7. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Thank you for pointing me in the right direction. Unfortunately, I'm not the best programmer around and have never done VBA within Access. Am I right that I create a new module to use the code you suggested? How would I use the code once I have created the function? Sorry if I am asking for...
  8. SeanDagger

    Concatenate Strings from different rows in same column grouped by ID

    Is there an easy way to Concatenate Strings from different rows in the same column grouped by ID? (all in one table). For Example: Client ID County 100 Newcastle 100 Cleveland 200 Northumberland 200 County Durham 200 Newcastle 300...
  9. SeanDagger

    Access query to convert string to general date

    Yeah the date is still text at this point and it shouldn't need to be converted to text now. I have been told that the destination application will accept the import as text as long as the formatting is spot on. Which it is. Thank you for your help. If I run into further problems, I will...
  10. SeanDagger

    Access query to convert string to general date

    I think I may have cracked it by using UPDATE ExternalClientExtract SET ExternalClientExtract.[Date] = "20" & Right(ExternalClientExtract.Date,2) & "-" & Mid(ExternalClientExtract.Date,4,2) & "-" & Left(ExternalClientExtract.Date,2)& " T 00:00:00 000z" WHERE ((ExternalClientExtract.Date) is not...
  11. SeanDagger

    Access query to convert string to general date

    Funny you should mention that. I have just been informed that the SalesForce system we are importing into accepts the following format: yyyy-mm-dd T 00:00:00 000z So my next move is to now change my SQL query. I will hard code the ' T 00:00:00 000z' bit (as not important for migration data)...
  12. SeanDagger

    Access query to convert string to general date

    Thanks Remou Much appreciated. Since I posted the question I managed to get it working by doing the following: CDate(Left(ExternalClientExtract.Date,2) & "/" & Mid(ExternalClientExtract.Date,4,2) & "/" & Right(ExternalClientExtract.Date,2)) Looking at your solution, you have a much better...
  13. SeanDagger

    Access query to convert string to general date

    Hi. I am new to programming and would like help on converting a text string to a date in access. I have imported a spreadsheet that contains a date column as text (ie, 24.02.07). I have imported the data into Access no problem. Now I need to run a query to convert the text into a date...
  14. SeanDagger

    JavaScript Alert simulation?

    I know what you mean but you know what users are like? If the page hangs and looks like it is not doing anything, users start clicking everywhere to see if browser crashed. I have put a pause delay code in to see what happens and it is still resulting in my original problem posted. it just...
  15. SeanDagger

    JavaScript Alert simulation?

    Hi I wish it was ASP as I have done it before at my old workplace. I am familiar with the method you described. As I am using SalesForce to interact with the server (Apex?), I'm not sure if my problem is serverside or the Client JavaScript? I have also noticed a method using something called...
See more

Part and Inventory Search

Back
Top