Recent content by IanW

Hi, Can anyone tell me the best performance combination of Cursor and lock type if I want to open a ADODB recordset and Append a record to it (1 for each pass of the function) Thanks

Hi, Does anyone know which is the best to use on Access Reports JPG's or BMP's? By best I mean quickest to load with best resolution to size ratio. The images in question are just grey scale forms with controls laid overtop. Thanks

Sorry, Try if isnull (me("text box1")) OR isnull (me("textbox2")) OR isnull (me("textbox3")) then If referring from code or: if isnull ([text box1]) OR isnull ([textbox2]) OR isnull [textbox3] then if referencing controls from a control on the form Hope it helps. Ian

test prog Here is a bit of test code: you can use Replace to remove any unwanted punctuation b4 passing it to the split function. Sub test() Dim strArray() As String Dim intCount As Integer Dim intNoOfWords(15) As Integer strArray = Split("Iaskdjh ASDH Jh asdpjAPD...

Does your code look anything like this: Dim strArray() As String Dim intCount As Integer strArray = Split("Iaskdjh ASDH Jh asdpjAPD PIASJIDJ ASIODJ", " ") ' This is the important bit For intCount = LBound(strArray) To UBound(strArray) ' Code should be...

Try: if isnull ([me!text box1]) OR isnull ([me!textbox2]) OR isnull ([me!textbox3]) then

It may give you a blank last value if the sentence has something after the last full-stop e.g. a Cariage Return. As regards the word count , 3/4/5/6 letter words etc. I would us code like: I would create a loop and increment intCount by 1 each time until you got to the UBound(intCount) value...

Good point. What version of access are you using

The word count is quite strauight forward (on the face of it anyway). Try: Dim intCount As Integer Dim varArray() As String ' Split words into array varArray = Split(Trim("Test text test text "), " ") intCount = UBound(varArray) + 1 ' Array is Zero...

Hi, I am working for a company who has recently moved their BE Access 2000 database onto a newer faster server. This has decreased the speed of the file server application on the client pc's. Does anyone have any ideas on how to speed up the system. We disabled opportunistic locking on the...

Have you tried using DoCmd.RunCommand acCmdCopy instead? Hope this helps Ian

Hi, Can anyone point me in the right direction please. I am trying to copy objects (forms, reports, queries, etc) from the current database into another (closed) database using VBA (Access.Application object). Any pointers or advice will be gratefully received Ian

Hi, Can anyone point me in the right direction please. I am trying to copy objects (forms, reports, queries, etc) from the current database into another (closed) database using Access.Application object. Any pointers or advice will be gratefully received

I have found a problem using Access 2000 and 2002 where when Access is shut down normally it still holds a process open when viewed in the Task Manager (Processes) has anyone else come across this problem and if so does anyone know a solution please.

Hi, I am in charge of developing and maintaining an access database written in Access version 2.0 then upgraded and changed over a number of years through to Access 2000. The database is set up as a File/Server application with a central data file serving between 45 and 55 PCs daily...