Search results for query: *

Hi all How can I find if I have duplicate records in a table? 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:= _...

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

Hi How dow I copy data from another workbook into a open workbook and closing the other workbook again using code. Regards, SmithCZA SmithcZA

I want to use DVD-R as data archiving. My bying department mistakenly orderred dual layer DVD-R's. How stable is this media and for how long can this be kept? smithCZA SmithcZA

Hi How can I get a new line in a messagebox? (msgbx -Excell) SmithcZA

How can I retreive an address from the address book and use the address in another part of a macro. SmithcZA

Hi. How can I save a excell workbook and mail it to a specified address using code (via a button) Regards, Smithcza SmithcZA

Hi. I have been asked to create a "user friendly" questionare that can be easily send via mail, completed and then returned to sender. It will the type of "select 1 to 5", so radio buttons will be the way to go. The data must preferable be extractable in CSV / excell format. Does anybody have...

Hi I have a laserjet 2500 colour network printer. When I install the printer on the server, I get a error when trying to print. When I turn the printer of and on again, the job that gave the error, will print. I might be lucky to get one or two more jobs through before it starts giving me an...

Hi I urgently need to copy files from a 3.5' floppy but I get the Data error (Cyclic Redundancy Check) . Is there any way I can recover the data? Please help. Regards, Smithcza SmithcZA

I am trying to import a quottro pro file (WB1) into Excell. I noted that there are converters for Excell 2000 but I can not find one for 2000. Where can I find a converter for Excel 2003? Thanks Christiaan SmithcZA

We are running Mcafee on our network. When we try to copy SCR (vb screen, not windows screen savers), it says "Access denied" or when trying to save the file, it says file is "read only". When we disable Mcafee, it copies and saves. Any idea where and what to enable/disable? Regards...

Hi I am trying to get an installation of MSDE (Microsoft Data Engin) After installation, I can see the server running on the PC but can not connect to it (across the network from a PC with the proper tools - enterprise manager etc.) What login details (or how do I set them) do I use? Please...

Hi Somtimes when I insert a tape containing a backup, it is detected as New media when it is not (I used it for a backup before). Is this a Veritas problem or a drive probelm? SmithcZA