Recent content by New2SQL

thanks for the advice above but there is an error when i try and run the form1 alternatively, instead of doing this in a macro, could it be done in either Access or sql query analyser? the data is originally coming from there so if i could manipulate there that might make it easier?

I have data in excel where 1 contact is known by many people such as: New2SQL - Access Forum - David Beckham New2SQL - Access Forum - Coby Jones New2SQL - Access Forum - Daniel Dichio I am trying to macro this so it appears as follows: New2SQL - Access Forum - David Beckham, Coby Jones...

Is there a way to edit the 'count' results in a pivot table? I have got a list of name down the left to show the person a. from my data i can see the count of people who know person a. he knows 2 people. is there a way to show me the names of these 2 people rather than just a number? thanks in...

actually... I have also tried this in SQL Query Analyzer (same database) but InStr isn't valid? any alternatives in SQL QA?

dude you are a leg-end! thanks a lot.

I am looking for the best way to shortern a string. Basically the string has the set up like this: New2SQL/123/London I just want the name bit at the beginning. Everything before the first / any one have an idea the best way to get this? thanks

..I am trying to run a query that allows me to enter the name of an entry on my database for that entry only. So for example, when I run the query, I am looking for information on "New2SQL" only. Now I know I could just enter this in the 'Criteria' row BUT I am needing to run this query...

ha attached a mobile phone. tried to download a ringtone from his machine but got frustrated so "rammed" the USB in the machine. when he disconnects, it is still broke. i told him to send it back as the PC is only a week old.

he can't check his motherboard because he can't start his machine. when he starts that error pops up. Would starting it in SAFE MODE be of any good?

A guy i work with has a slight issue with his PC. He tried to connect a USB cable to his harddrive and now when he tries to start his PC gets the following error: "USB overcurrent device detected. Will close down in 15 seconds" Any suggestions?

works a treat but... ...in the row i used this on, some names have no spaces so literally just first name and in the results i get from the expression, i get an #ERROR for those people. is there a way to get the results from that expression as well as keeping those unaffected as they were...

I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also. I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill"). i...

How do i trim a name in a string. I have 2 rows with firstname in one and the second has surname. if i wanted to view the results to have A Einstein rather than Albert Einstein, how would this be done? thanks.

having a prob with the above. not sure what is the best way to find out what comes after the @ in an e-mail address. For example, if i was to have the following e-mail address@ firstname.lastname@myemail.com is there an expression to use to shrink the above so that i can only see the...

thanks for that. works a dream.