Recent content by antoineh

these answer are ok. But... it is always better to avoid looping on a recordset and use queries instead (lot of code, difficult to maintain if changes in tables etc...). I'd rather : - use queries for providing the data to the form and sub forms - use that very same queries, for providing the...

Thank you. the link is usefull. I ve searched the cause of the pb. I seems also that it comes when my module are bigger than 32 kB. Antoine

Using vba for excel is not difficult if you are familiar with vba for access. see the help in excel/vba, every thing is explain. the thinking logic is quite different from access, but easy to get. but with excel, you'd better use the cell "regular" calculation of the spreadsheet and not use any...

Hello, on msaccess 2000 with W2k, Office SR3 : After compacting or importing modules, and when I close and reopen a database, when I try to open a class module, VB opens, but hang and overload the CPU. Last time : VB opens the module, but as soon as I type in it => hang... I can't work this way...

Hello, on msaccess 2000 with W2k, Office SR3 : After compacting or importing modules, and when I close and reopen a database, when I try to open a class module, VB opens, but hang and overload the CPU. Last time : VB opens the module, but as soon as I type in it => hang... I can't work this way...