Search results for query: *

It is probably safer to create a new field based on the old field, setting the datatype of the new field to what you want and copy the data into this new field - this way you do not lose the original data Simon

Jackie, Using DAO like this will only give you an accurate recordcount (using rs.RecordCount) after you have moved to the last record. Simon

NT4, SP5 server, 2000P clients Simon

Hello, I have inherited an application built in VB6 on an Access97 database which constantly produces Error 3343, Unrecognised database format (which I can correct each time by repairing the database). I have a feeling that the corruption is due to access not being able to cope with 14...

have you considered using the winsock control to ftp the files?? Simon

To set the initial value, providing there is something in the combo box, set the ListIndex property to 0 (for the first element in the list). If there is nothing in the list, then setting ListIndex to 0 will give an error, so you will have to check ListCount>0 first. E.G. If...

Two double quotes next to each other becomes ONE double quote. Alternatively, and more work, you could use: strA = "She said, " & Chr(34) & "I did it!" & Chr(34) & "." Simon

It is not a good idea to mess with these files in Notepad, Wordpad,... as you may screw them up and not be able to use them in VB, and so have to recreate them. Simon

Use the Format function to format AEDt to the required format, then you do not have to use the individual parts. (Also, if you want to do it this way, you can also use the format function to get just the day number, month number and year number more easily than you have done - SelMth =...

Change the controlbox property of the form, to remove the buttons on the top right. You can hide the min and max button if you set the MinButton and MaxButton properties to False. However, if you only set one of these properties to False, then the three buttons will appear, with the relevant...

Try 3.60 instead of 3.51 - you must have the updated Jet engine on the server for it to work (the easiest way to do this is install Access2000 on the server). Simon

If the field name has a space in it you must enclose the field name in square brackets. The reason you were getting no motach is that with the syntax in your expression you were comparing 2 literal strings (by enclosing the field name in single quotes). Try this: DataCont.Recordset.FindFirst...

I still think this can and SHOULD be done by the way I suggested first. This way involve less database reads and therefore will be quicker. Simon

Didn't spot that!!! Simon

How about the MSDN training guides for exams 70-175 and 70-176?? These exams cover COM and MTS quite extensively, but I do not know how in depth the text goes. Simon

I think there is a much simpler way to do this. Can you not do just one select statement to return all of the information you need, using JOINS between the tables in question: In the SQL statement below I am assuimg the following (as you did not include the select statement in your stored...

Wouldn't it be better to use <cfindex ...> to index the database fields, and let CF do the matching for you, returning a percentage match, as with all other searches on the web?? Simon

What do you mean by web mail??? Will <cfmail ...> do the job for you?? Simon

I have had Response.Redirect working without either of the suggestions in the previous 2 posts in place, but I think it is always a good idea to include them. Simon