Recent content by SteveCop

Thank you Frink. This is exactly my problem. However I found (I think) a solution to it! I found that the office machines were NOT set up to receive Office updates but were recieving Windows updates. Because they all showed this problem late last week I suspect a recent Windows update may have...

Within a customer browse form, I have a sub-form which displays brief summary records linked to the customer. One of the fields on the subform can be double-clicked to open a detail form for that specific record. This has worked fine for 3 - 4 months. In the last week on the networked version...

I hadn't but have now and it has made no difference. The strange thing is, if I leave one of these unsent/can't send messages sitting in in the outbox, others seem to be sent as normal! If I di that, though, it is irritating because I constantly get the "There are unsent messages in your outbox"...

Using Outlook 2003, WinXP SP2, ADSL connection. Recently Outlook has refused to send my e-mails after creation. They are listed in the outbox but not in italics (ready to send) and have "none" in the sent date column. The only way to send the message is to select each one and "forward" the...

I have a system for mail merging documents monthly to 200 people The data comes from Excel and the document from Word. Some of the recipients are having problems opening the documents, getting the message : "Word experienced an error trying to open this file. Try these sugesstions: a.. Check...

M8KWR Thanks for your suggestion. Although I know what I did wrong (see previous shame faced post) I like your idea as it will help me elsewhere. I am already using tab control change property for another purpose but did not know it was possible to work out which particular tab had been...

I am an idiot! Sorry to waste anyone's valuable time! I was using the field names in the code, not the actual control names. (shuffles off into the distance in shame)

One of the forms on my database contains a five tab page. There are around 20 fields on each page and each page is pretty well a mirror of the others, the data fields on page 1 being identified with trailers of _1, on page 2 _2 etc. For each page there is a database field called IsLocked. When...

Thanks very much indeed. I'd tried to assign the public to some local variable without success but would never have thought of this trick. A couple of things I found necessary even now 1) the function needs to be declared as a public function and 2) it needs to be in a general module and not in...

I have a form for which the data source is a query on two databases. Elsewhere in the system, a public variable is set when the system starts running with a user ID name (No fancy code, the public variable is declared in a dedicated module simply as PUBLIC PubUserName as String) On my form I...

Thanks, Geoff. My earlier searches were not that helpful but, spurred on by your suggestion, I happened on this wonderful site which simply has to answer everyone's queries about e-mail and excel! http://www.rondebruin.nl/sendmail.htm#body

I have a very large Excel workbook which produces a complex "profile" worksheet containing not only data but mini-charts. Entering a subject name on the profile sheet updates the sheet to show that subject's information from the data sources elsewhere in the workbook. I need to make the...

I have an unbound field on a print control form and I require the contents of this field to print on a report. I don't know how to refer to the form field from within the report. Might I have to create a temporary table to hold the text so as to be accessible to both the field and report or is...

I need a documenter which will show the relations between the tables, queries and other objects in my database (for example, which screens and reports relay on a particular query). It would also be helpful if it were possible to list all fields referenced (for example) by a particular form or...

Thanks for the guidance - have re-posted as suggested