Search results

Its Chapter 10 in my copy - the section from p 412 titled "WORD - Creating a Formatted Letter with Data". It goes on for about 9 pages and my code is lifted from parts of it. The code works fine with Early Binding and I have it in lots of my apps. Have you tried it? T

The book is Access 2007 Programming, published by Wrox. If you go to Clients form, there is a letter button, press this and bingo, one pre-prepared letter. T

Its a Letterhead. This code was lifted from a Wrox book. Thanks Ted

No problem; clients always come first (even the internal ones). T

You are indeed a star so thank you for explaining it. I will be very interested in your Late Binding code and I look forward to receiving it. Please see the msg in your private box. I agree with your world but in this case, I have a client who requires their application on time and being late...

I have done so many things, not sure. Are you suggesting that you remove the References while in Design mode and then only put them back to test/run? Not tried that and its too late now as the 'IT boys' have it. Surely this shouldn't be necessary. May I ask something, when you say remove the...

Good morning Gina; I hope you had a good weekend. Yes is the answer to your question but it seems to make no difference. Yesterday I had our IT people re-install Office 2010 and again no difference. In each any every case, adding a simple button with a piece of OpenForm code causes the error...

Thanks Chris; that tends to suggest it my Lap Top that is the problem. Will endeavour to get an Access 2010 re-install. It doesn't help yours of course but I appreciate the test. Will let you know what happens next. Have a good day. Ted

Good morning Just tried another 'Test' with all code a References relating to the Word Object Library removed and still the same error when placing a new button on a form. Even tried replacing the Reference Office Access Database Engine with DAO 3.6. That made no difference either (BTW what...

Gina - have you seen the post here entitled SP1 - Access 2010 . Do you think we both have the same problem?

Indeed; I am working with a very nice lady (Gina) who is trying to help find a solution. I would be interested if you could try the test suggested in my posts and let me know if you get the same result. I too am becoming very frustrated with it as I am in the middle of a big project and...

Can you take a look at my post here titled Access 2010 Control Wizard. Shades of the same thing perhaps? What do you think? (BTW the 2007 pc referred to is Vista Pro and the 2010 laptop is Windows 7 Pro)

Enjoy your day; its 19:45 and I am 2 glasses of red wine in. Sunday is fine. I really appreciate your help. If you can please, tell me: why does the Word need to be Late Binding when in 2003/2007 Early has been fine? Is it a 2010 thing? PS: the code in the Create Letters module was...

Aaah - so how do I fix the error without checking the Reference. Surely the Create Letter module requires the Word Object Library and similarly File Browse needs the Office Object Library - at least they have always done in 2003/2007. I do have one less (the OLE one). Or am I missing...

Hi again; just unchecked all References, closed db, opened it, debug/compile and it produced the expected References error. Checked the appropriate ones (Word, Access Database Engine, Office) and then compiled again until nothing reported. Then took a back-up copy and on that switched ON the...

Wow Gina - you are good. Never really got to grips with Binding. Just ran a Debug/Compile on the DB I attached in my last post and it is not generating and errors but I think from your comments I am missing something. This database is only going to be used in 2010 so quite happy to...

One way would be to create a table with 12 records relating one to each Tax Period with second and third fields being the start and end dates for the period. Then use a DLOOKUP of the Tax Period against your objective date between the start and end dates.

Hi Gina - can you try this for me, please in Access 2010. Open the attached and in Design view, make sure the Control Wizard in On and then add a button to the form F-Quotations. When the wizard starts, press Cancel. Then using the On Click event ellipsis, add this line of code...

Thats OK Stopher - thats how I did it. Hope Gina sleeps well, she will no doubt respond this afternoon. BTW - quite remarkable how close the coding was between the original and last night's re-write.

Further thoughts: I have got the faulty db open in 2007 and of course changed the references back to Lib12. Success in terms of recovery. Put this same one back onto v2010 and all the References automatically reverted to lib14 and Success in opening it and running it in 2010. Just looked at...