Recent content by smithcza

Hi all How can I find if I have duplicate records in a table? Regards, SmithcZA

Thanks a million, didn't see that. Works like a charm now. Regards, SmithcZA

Hi all We are trying to pull data from a SQL2000 database with Excell. Problem is, as soon as I try to have more than 5 conditions (where...), I get a "Type Mismatch" error. Has anybode got any good suggestions how to work around this? With ActiveSheet.QueryTables.Add(Connection:= _...

Thanks Skip I think we have a bit of a misunderstanding here. The database represents the data in a more strucktured way like you would expect from a MSSQL database. The client wanted to see the data in a "Montly" report, tests performed on a daily basis. With the tests in rows and days in...

Thanks for the info, SkipVought. Question, will this still be tru if the workbook is re-saved as another workbook? Sheet names will stay the same, just file name will change. Regards, SmithcZA

Hi thanks guys. Will give it all a go. SkipVought, the problem is I populate from an external DB, which will only has data for every monday of a month. This data sits in columns (one column per day), hence only four out of a possable 31 columns will be populated. The client doesn't like the...

Thanks a million, works like a charm!!!!! SmithcZA

Hi I want to search a range of data, if the entire column within the range is empty, I want to hide the column. So far I am looping through the range with to loops. This is probably not the most efficient way. Can sombody please adcise me on this? My code: Sub Test2() Dim sStartRange Dim...

Hi I need to import data from a MSSQL database, using a macro. It is working well, problem is, the DB password has to be hardcoded the way I do it, which is not ideal. I also do not want the user to enter login information everytime the macro runs. I can pass the password into variables using...

Hi I would like to update a MS SQL table with data from excell, can somebody please help me with correct syntax? I haven't got a clue on where to start. Regards, SmithcZA

Hi How can I limit the amount of columns in cross tab / page. I.e. have five columns on page and then the cross-tab contnues on the next page etc. Regards, SmithcZA

Hi all We use wscript to host VB screens in a aplication. These forms do not "show" in the taskbar like normal applications. Is it possable by code, to "show" these forms in the taskbar? Regards, SmithcZA

Hi I eventually succeeded. Created a form with two text boxes, fed the one the cell value and the other the cell value trimmed to 20 characters and compared the two textbox values. Probably not the best way but it worked for me, this way I could also see how much too long it is. SmithcZA

Hi How can I determine the length of data (all text) in a cell. I want to be able to do something when the length of text in a cell is more than 20 characaters. Great many thanks, SmithcZA

Thanks a mill Wil give it a go. SmithcZA