Replies

Many thanks for your help. I can see that this is a very flexible and useful pair of functions. My apologies for not not replying soon but I got waylaid.

FANTABBYTOESIE

That’s brilliant. Just the sort of fix I was looking for. Quick, no programming and you use the control setting as default! You’re a star. Apologies for not replying soon I got waylaid.

Sorry did not explain myself clearly enough. Please see above.

You are quite right it is too vauge.

I have a large crowed form. The uses often have to leave there stations to get data. Also the tab order is not normal in that it jumps from one block of controls to another block and there are four blocks. New users are finding it difficult to use, experienced users do not want to change. To help new users I want to highlight the control that has focus. Most of the controls are bound a few are not, all are on a single form and all are flat.

It seamed so simple when I started.

Many thanks

This has put me on the right track.

Excellent idea. Unfortunately Outlook Express is not listed in the E-mail combo box – (????) – The plot thickens.

Shoudn’t I be doing something else on a Friday evening?

Thanks for the reply.

> Is the report prepared ahead of time so that access can be out of the picture?
It could be! But how/where would I store it?

> i would use task scheduler to send the message, …
I’ve never used task scheduler could you point me to a book/site that covers this?

> if you set up a SMTP server you can bypass a mailer and just send the report.
> WinXP includes a smtp server in iis or you can find a small free/shareware
> one at any download site.
Still using Win 98 and NT 4.

Graham

Thanks, that looks worth investigating.

Apologies for the tardy reply. Pressure of work…

Many thanks the site you indicated had exactly what I required.

Thank you for your time and interest.

Apologies for the tardy reply. Pressure of work…

Sorry I did not express myself correctly I wanted to copy the comments using VBA. Fortunately Peter Morgan pointed me in the right direction.

Thank you for your time and interest.

I

Sorry I don not express my self correctly. I want to automate it via VBA

Thanks Rupert

Very useful.

Spot on Mark

I was convinced that I had seen a demo database send them all in one go. I have but obviously not on this computer. Works fine now.