Search results for query: *

That's the strange thing - I haven't issued a quey. I open a recordset for the record I need, update the record form memory variables and issue an update, e.g:- rs.open = "SELECT * FROM property where code = '01AA0001',... rs!datafield = strdatafield . . . rs.update Then I get the error...

I have an VB6 application that has been used for 18 months by a client in several offices, some of them use Access 2000 and some use SQL Server 2000. I am doing some changes which have increased the number of fields in one table from about 70 to 105. All works fine when using SQL Server, but...

Thanks for that - will that work with Word 6? I thought you had to use Word Basic with Word 6?

I have an application running at a client who has every flavour of Word from Word 6.0 to Word 2000 running in various offices. I do a mail merge as follows:- Set objWord = CreateObject("Word.Basic") objWord.FileOpen Name:=strNetworkDrive & "\newnead\data\lettera.rtf&quot...

I don't have data bound controls. I didn't want anything updated until the user clicks 'OK' on the form so everything on the form is updating public memory variables. There aren't any redundant indexes as ar as I can see. The exe file is about 6.5mb, and I compiled for native code and optimise...

I've written a system in VB6/Access 2000 for a client to replace a FoxPro 2.6 system. Developing and testing on a stand alone pc the response times are as I would expect - more or less instant as data volumes are not huge - but testing on a network (2 separate ones) the performance is dreadful...