Search:

Type: Posts; User: adam.syd

Search: Search took 0.01 seconds.

  1. Re: [VBA]: Regular Expression Pattern: Replace & ignore line feeds

    Brilliant, I will check it out, much appreciated.
  2. Re: [VBA]: Regular Expression Pattern: Replace & ignore line feeds

    Thanks, I have looked at that also, that will be my last resort.
  3. Re: [VBA]: Regular Expression Pattern: Replace & ignore line feeds

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

    Thanks,
    Adam.
  4. Re: [VBA]: Regular Expression Pattern: Replace & ignore line feeds

    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...
  5. [VBA]: Regular Expression Pattern: Replace & ignore line feeds

    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...
  6. Replies
    13
    Views
    1,588

    Re: Access(mdb) Performance Issue

    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...
  7. Replies
    13
    Views
    1,588

    Re: Access(mdb) Performance Issue

    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...
  8. Replies
    13
    Views
    1,588

    Re: Access(mdb) Performance Issue

    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...
  9. Replies
    13
    Views
    1,588

    Re: Access(mdb) Performance Issue

    Thanks for the details, I have indexes on some fields.
  10. Replies
    13
    Views
    1,588

    Re: Access(mdb) Performance Issue

    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 &...
  11. Replies
    13
    Views
    1,588

    Re: Access(mdb) Performance Issue

    Totally agree, we have 30k+ lines of code to migrate so it is not going to be an easy move.
  12. Replies
    13
    Views
    1,588

    Access(mdb) Performance Issue

    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...
  13. Replies
    2
    Views
    433

    Re: Split string by two different characters

    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....
  14. Replies
    2
    Views
    433

    Split string by two different characters

    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...
  15. Re: VB Code Snippet: Special Charaters in XML Charater Data

    Thanks Joacim, really appreciate your assistance.

    Thanks,
    Adam.
  16. VB Code Snippet: Special Charaters in XML Charater Data

    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...
  17. Re: DataGridPrinter - A class to print data grid in a nicely formatted way

    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,
  18. Replies
    3
    Views
    461

    Re: [2005] Save Cursor

    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...
  19. Replies
    3
    Views
    461

    [2005] Save Cursor

    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...
  20. Replies
    0
    Views
    681

    Desktop Icon Position

    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...
  21. Replies
    5
    Views
    549

    Re: [VS 2003] Stop form from updating

    Thanks ZaNi, I will give it ago...
  22. Replies
    5
    Views
    549

    Re: [VS 2003] Stop form from updating

    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...
  23. Replies
    5
    Views
    549

    [VS 2003] Stop form from updating

    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...
  24. Replies
    4
    Views
    936

    Re: Dataview confusion

    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...
  25. Replies
    4
    Views
    936

    Re: Dataview confusion

    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'...
  26. Replies
    4
    Views
    936

    Dataview confusion

    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...
  27. Replies
    2
    Views
    554

    Re: VB.NET library in VBA

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

    Cheers,
    Adam.
  28. Replies
    2
    Views
    554

    VB.NET library in VBA

    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...
  29. Replies
    6
    Views
    672

    Re: Chart controls - Recommended any

    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.
  30. Replies
    6
    Views
    672

    Re: Chart controls - Recommended any

    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...
  31. Replies
    6
    Views
    672

    Re: Chart controls - Recommended any

    Hi Bill,

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

    Cheers,
    Adam.
  32. Replies
    6
    Views
    672

    Chart controls - Recommended any

    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...
Results 1 to 32 of 32



Click Here to Expand Forum to Full Width