Search results

You may have to identity path of x01.xls in the code Ii is reproducible in all instances

DB guy your €£$ worthed of placing a range at the end did not work. It is not range but a table in the database I think range is mainly for import.

Hi guys i use following to export a table eg Tb01 to a Excel eg X01.xls docmd.transferSpreadsheet acExport, 8, Tb01, X01, true by doing so either 1. if there is no worksheet by the name of Tb01, it will create one & export content to it 2 if there is the folder Tb01 it will just replace it's...

Thank you Pat, appreciate the care To keep it simple i still export the text & numbers with its tabs then open the rtf with Word. Here i can add the graphics or copy the whole lot as 'it is' to Excel then do the cosmetics therein. Kind Regards worry about the violent weather

Thank you Pat, appreciate the care To keep it simple i still export the text & numbers with its tabs then open the rtf with Word. Here i can add the graphics or copy the whole lot as 'it is' to Excel then do the cosmetics therein. Kind Regards worry about the violent weather

hello members when i export a report, with lines ie physical separation lines, into an .rtf format file the lines don't appear. How to resolve this? :o

Heaps to tinker & tonnes of thanks for the efforts to help :)

How to solve reference issues when each pc has different version of it i have a reference to Excel object set to one location / folder However different pc have different office package eg 32 bit or 64 bit all from different folder thus cause error on running application how to resolve in...

Thank you guys should resolved. Build big help

Hi experts Let say I have a bounded text field whose control name is txtFld. This control is in a subform SF1. There is another subform SF2 in the same main form. In SF2 there is a text control which I want to link to txtFld. How to identify it eg =[SF1].[txtFld] will generate #name error

Guys it is onlyMDB, no accdb Only access 03 & 2010 The 03 mdb was never touched by 2010. Just open an empty instance of 2010, on return to 03, untouched 03 mdb flag the error stated I think just opening 2010 remove something so 03 don't work any more. So no mixed up just simple as I first type

Hi All Whenever Access 2010 is started, mdb created in Access 2003 will produce the follow error on starting "Expression On Open you entered as Event property setting proudced error: Object or class does not support the set of events" The Error occur even before the Open.Event of the StartUp...

Great to hear so many new things. Thank you

Thank you guys for sharing. There is no activex and the decompile can't remove or resolve the corruption

Hi members I have met this many times; whenever i alter an old form, after saving it, it can't be opened. On trying to, it report that is it short of memory to open. This is not true as there is ample memory. To avoid this i make just a few changes, save it first before i do another few...

Bro totally agree with your clear logic from the odd guy on the block. Appreciate!!:D

Now i remember i have a hidden form that has a very short timer, 1 sec. I use is timer to check if the number of forms has dropped to a critical number, if so the app will close. I would still like to keep this perhaps 1 increase the timer to 5 sec or 2 turn if off when i do the text...

Colin your logical pointer is worthed checking all forms THANK YOU

Ya I also missed that should work, ��

There is no timer event on the form