Search results for query: *

Hi! I am currently writing an application in VB.Net 2008 and this connects to an iSeries database. I have the IBM System iSeries Access for Windows installed on my development machine. I now need to deploy this application to other machines. I have included a reference to...

Thanks for the reply! I have sorted it now.

Hi! I developed an application using Visual Basic 2008 that uses SQL Server 2008 Express. When I published it using clickonce under Windows XP there were no problems with the setup (a sqlexpress2008 folder was included within the install location) and all prereqs were included/installed. I...

Hi jebenson, Thanks for that! Tried it and it does what I wanted! Regards, Alan

Hi! I am trying to create a deployment project that requires an additional msi file (mySQL net connector) to be installed as part of the deployment. The in-house written dll was written in VB.Net 2010 and this dll requires the mySQL net connector to be installed on each workstation as well. I...

Hi! Does anyone know how to hide the grouptree in the Crystal Reports viewer in VS2010 (VB.Net). I used to use the following - viewername.DisplayGroupTree = false But I cannot use this in VS2010... Any suggestions? Regards, Alan

Hi! I have written some VB.Net (2008) to run a mailmerge... my problem being is that I want to make the instance of Word invisible to the user. The nearest that I van get is to minimise the Word application. The code that I have written is below. Public Sub fred() Dim sqlQry As...

Hi! Is there any way of detecting the user that has made any changes using the FileSystemWatcher? Any help will ber appreciated! Regards, Alan

Hi bborissov, Thanks for the reply! No the query you supplied returns 19145 rows out of 19583.... Regards, Alan

Hi! I'm tryng to find rows in one table (tblRemainingFiles) that do not match with an entry in another table (tblErrorLog)... So far, I have the following sql written - SELECT c.SourcePath, c.ErrorMessage FROM dbo.tblErrorLog AS c JOIN dbo.tblRemainingFiles AS e ON e.Path <> c.SourcePath...

Hi Lemon13! Thanks fr the reply. I took ownershp of the said folders and it worked! Regards, Alan P.S. A star for you!

Hi! I have inherited a SBS2003 system and in certain folders/files under a share, the administrator is not allowed to access them! Is there any way that I can authorise the administrator and say, the Domain Admins to to access these folders/files? Any help will be appreciated! Alan

Thanks kliot! I'll try it out next week!

I dont know wether this has been asked before but... In VB6 you could retrieve the error number and the error description and also the line number where the error occurred. In vb.net I cannot find a way of duplicating this functionality. Has anyone managed to reproduce this or something...

Sorwen, Thanks for the reply.... I found an article that sorted out my problem!

Hi! Does anyone know of a good step-by-step tutorial of how to create a setup project in VS2008? I am getting stuck on adding desktop and users program menu shortcuts and I am getting nowhere fast! I can get them created but they do not launch the application... Any help will be appeciated...

Thanks for the reply... but I already knew that... what I am trying to do is make the desktop short cut that I have created in code invoke the click-once updater... Regards, Alan

Hi! I found some code (can't remember where!) that creates a desktop shortcut in code. The problem with this is that I am using click-once deployment and clicking on the desktop shortcut does not invoke the update of the application when it is required. Does anyone know how to create a...

Hi! Does anyone know of a way to load and retrieve an icon (.ico) file to/from a SQL Server database? I found some code on the web that will load/retrieve bitmaps (.bmp) but this does not seem to work with icon (.ico) files I need to load an icon file say fred.ico into a SQL Server 2005...

Hi! I hope that someone can help me.... I have a databse table containing rows of company names. What I would like to do is to parse these names to ensure that they are properly capitalised. For example if the name is - XYZ trading co I would like the function to return - XYZ Trading Co...