Recent content by lidds

I need some advise from the group. I have developed a piece of software that uses MS SQL Server to store my application database. My software can be used by companies that have multiple offices in different countries, and this is fine as they write back to the SQL database in one of the...

I am stuggling to find out what I am doing wrong here and think a fresh pair of eyes might help. I have a class called DBAccess which I am using to connect to a SQL Server database, the DBAccess class contains the following code: Public Class DBAccess Private connStr As String = Nothing...

This may or maynot be possible, but thought I would ask the question anyway. I have a webbrowser control on a form that I am using to allow my users to create custom email templates within my application. I then have a number of button on the form that enters predefined tags within the...

I have a WebBrowser control added to my form, which I am allowing users to create custom html email templates. The problem I have is that when you with the 'Return' key, the cursor jumps what looks like 2 lines. I've looked at the HTML behind it and it seems to add a <p> (Paragraph) item each...

I have written a plugin application into a third party 3D design software. The 3D design software is owned by another company. The problem that I have is that with each version of the 3D design software that is released, they add new code and change the version of the dll's that I reference...

I was wondering if anyone could help me with combining 3 byte buffers. I am using a licening piece of software has supplied the below code example on there website, which is to create a unique machinecode. The problem is that the example shows how to use 2 computer parameter e.g. GetCPUId and...

I don't know if this is possible, but what I want to have is a SQL table that contains has one column called "Command" that contains a VB.Net code E.g. Me.btnHome.Enabled = False Me.btnSave.Enabled = True What I then want to do is query the database, and then loop through the datareader and...

I have an SQL statement that gathers the users fullname from a userTbl table using the userID value in the commentsTbl table. What I want to be able to do is if the value of commentsTbl.isPublishedComm equal to 'True' then add a value into the FullName field e.g. 'NOT FOUND' else if...

I have a file called setting.xml which contains the following: <?xml version="1.0" encoding="utf-8"?> <settings licenseServiceType="1" protectedStorageFile="%AppDomainAppPath%App_Data\storage.psf"...

I have a form that depending on results from a table would create a number of buttons using code at runtime. This could range from 1 to 20 buttons. What I am struggling with is creating a generic mouse over event for each of these buttons? The reason why I want a generic mouseover event is that...

The error is this: I have also checked the path to the MDB file and it exists in the directory in myFilePath I have also added MDAC 2.8 SP1 and this has had no effect. Thanks Simonhttp://www.ticodi.com/downloads/access_error.png

I have written a VB6 application that connects to an MS Access database using the following connection string: myConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myFilePath & ";" This works fine on the computer that has Visual Studio 6 installed on it but when I deploy this to a...

I have developed a desktop application that connects to a MS SQL server over a network. One of my clients wants a third party company to be able to use my desktop application but connect to the MS SQL database in my client’s office. Obviously my client could open the ports to the SQL server to...

I need some advise and guidance as this is well out of my comfort zone. I have developed an VB.Net application that works with SQL Server and currently connects to the SQL server over a network within the clients company, no problem here. One of my clients has asked the following question...

I have developed an application and need to allow users to enter text in any language and save it to my database. However the text is saved as '?' in my database. I have googled quite a bit and found that people have suggested not to use varchar, text types but use nvarchar and ntext etc in...