Recent content by Ricardo1

Steve, It looks like we are getting somewhere! Offcourse I'll have to check whether using this doesn't hurt performance too much (it probably will have to be executed serveral times per hour on a few thousand records!). However I have a small problem to add to the discussion. The program will...

Leslie, If I'm not mistaking a function like instring is available in SQL. When using it, it will return the position of some text within some other text. If you use it and check whether the return value is larger than 0 you'll probably be able to find them all! You might however have to use...

Leslie, What you suggest seems rather logical, however I spend some thought on this and came up with the following problem : Normally when I open a database through the jet driver only the first x records (normally 50) are read into memory. This saves time and resources. When I do as you...

Thank you for your suggestion, lespaul! This looks helpfull. It's looks like this function is created within the mdb file. I would like to call this function through a sql statement which I submit through the jet database driver from visual basic (not the visual basic for applications within...

Hi I'm using a access database in combination with visual basic 6 and the ms jet driver. I've created three tables : 1) Authors (containing number and firstname, middlename and surname) 2) Books (containing number and title) 3) Link (containing booknumber, indexnumber and authornumber) In this...