Search:

Brilliant, I will check it out, much appreciated.

Thanks, I have looked at that also, that will be my last resort.

Thanks, manually pasted the white space and got it to work, will try this for other special charters I find.

Thanks,
Adam.

Excellent, that worked perfectly.

I have the following text which looks like it has white space

GCID = "aaa bbb" which contains white space (?asc(" ") >> 160), but I can't seem to find the...

Hi All,

I have using VBA in Microsoft Access to replace special characters in a text string. Can you provide assistance in changing the pattern so line feeds are ignored?

Pattern: Need to...

Thanks for the detail relating to DAO, we have found it is quite good for mass inserts.

Issue we having is related to datatable time increasing from 0.3 seconds to 20+ seconds if it proceeds a...

Thanks for replying, your testing is for SQL client & I am using Access so there is no pooling as noted.

I have tested and in one operation we are connecting to the database 300 times which...

I agree to always keep the connection open with Access. We do quite a lot of operations so opening and closing will also deteriorate the performance. Interestingly this performance issue is only...

Thanks for the details, I have indexes on some fields.

Just carried out some further testing and found that getting the data table is very slow after an update is carried out. I have also found that we keep the connection open all the time. If I close &...

Totally agree, we have 30k+ lines of code to migrate so it is not going to be an easy move.

Hi All,

I have found some interesting performance issues with a legacy application that uses an Access(mdb) database which is located on the local hard drive. When the main form performs an...

Outstanding effort.

Thankyou so much for the solution and taking the time to explain the details was brilliant. I will definately spend some time learning the ins and outs of regular expressions....

Hi All,

I am trying to split a variable lenght string like 'abc [XYZ] + [efg]123' into 'XYZ' and 'efg'.

I have attempted to use Regular Expressions without any luck, your guidence would be...

Thanks Joacim, really appreciate your assistance.

Thanks,
Adam.

Hi All,

I am trying to write a code snippet in VB to carry out the following:


Dim SQL As String = <![CDATA[SELECT * FROM Table]]>.Value

I am having an issue in getting the special...

My mistake, sample can be run from the project file in VS 2005.

Thanks,
Adam.

Hi Merrion,

Latest version appears to be in VS 2008, any chance of getting it in VS 2005?

Cheers,

Thanks for replying Andy_P,

The cursors which are available as part of 'DragDropEffects' cannot be used directly as part of 'Me.Cursor ='. I am looking for a way to convert this into a cursor or...

Hi All,

Is it possible to save the current cursor type to a file & then load it later? Basically I need to use the mouse pointers which are set when you are performing Drag and Drop (ie...

Hi All,

Is it possible to get the position of the desktop icons? Currently I am using the ' Windows Scripting DLL' to create an icon but I would also like to get the position of icons & have the...

Thanks ZaNi, I will give it ago...

Thanks for replying Warren,

I am upating (removing & recreating controls) on the main form. These updates are occuring automatically, ie before I have finished all the operations. Basically I need...

Hi All,

I am a novice when it comes to vb.net so this question maybe very easy to answer.

Basically I have an application with a main form with numerous usercontrols drawn at run time. When I...

Hi jmcilhinney,

The code I have inherited is shown below. The issue is when the aShow(i) is being loaded. 'dv(i)("Display")' gives the array the correct value the first time the procedure is run...

Thanks for replying, I am updating the rows on the first pass. When I move through the rows a second time it appears to get stuck on the first row.
I have tried using the 'BeginEdit' & 'EndEdit'...

Hi All,

I am new to VB.Net and I have noticed somthing strange with dataviews.
The code below does not move through the dataview but displays only the results for the first record.

For i = 0...

Thanks for your response. I am not to sure what 'fx' is so I will have to do some investigating.

Cheers,
Adam.

Hi All,

There seems to be a few threads regarding this issue. My question relates to registering the VB.Net dll on the clients machine so it can be accessed in Access 2003. As I am using Access...

Thanks Bill, as I am still a novice when it comes to .Net that maybe a good option to help get me up to speed.

Cheers,
Adam.

Thanks, I will check those products as well. Yes I think I will have to pay for a package to get the data events I require.

I have been looking at ComponentOne, they appear to have quite an...

Hi Bill,

Thanks for replying, I will check it out. I hope they can accomodate data events.

Cheers,
Adam.

Hi All,

Great forum, I am new to VB.Net 2003 and have a question relating to any recommended third party controls for charts. Basically I need to have similar functionality to charts in Excel. The...