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

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

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

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

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

Hi! I am having trouble with the above control... What I am trying to do is retrieve the value from one of the bound textboxes in the datarepeater and I just cannot find a way of achieving this... Basically, the repater contains 4 bound text boxes and a command button. When the user clicks...

Hi! I am trying to extract all of the module code (Stand alone, Forms, Reports) from a MSAccess database using VB.Net 2005. Ideally, I would like to achieve this without using automation and the documenter. I have tried several attempts at converting native MSAccess VBA code but cannot get...

Hi! I was wondering, if there is any way via the MSYSxxxxx tables (or another way i.e. vba code), there was a way of listing all of the actions and comments associated with a macro (other than using the documenter). Any help would be appreciated! Regards, Alan

In MSAccess there is a feature called Database Documenter which allows you to print all of the module code/querydef code (amongst others). Apparently, you can run this through VBA code using something like this- acwztool.Doc_PrintDatabase This simply brings up the dialog box within MSAccess...

Has anyone know of a way - preferably in VB.Net to print the nodes (together with associated icons and lines) for a treeview. I have found some code on The Code Project but this is written in C# and uses a bitmap and it doesn't work properly - it truncates after a few pages. Any...

I was wondering whether you can run 32bit drivers under Vista64 bit? I have an Astra Umax 3400 scanner and the only driver that I can find for it is a XP version that I managed to get running under Vista32 bit. Regards, Alan

Hi!! I am trying to use SQL DMO in a VB.Net project to script out selected stored procedures. What I would like is to have all comments stripped out of the selected stored procedure just leaving the T-SQL. Has anyone got any ideas on how to go about this? Regards, Alan