Search results for query: *

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

Thank you for such a quick reply. I commented out the bit of code to hide the div and it does still show. Maybe the problem is something else as the pages takes about 5 seconds for the data to re-render. When you make a selection on the selectbox, the browser hangs for approx 5 seconds (the...

I have a small problem with a JavaScript function which is giving bizarre results. I am working with SalesForce S-controls. The primary language used to create the pages is JavaScript. I am displaying a page where data is queried from a database and displayed. (This function is called on an...