Search results for query: *

Ok ok - I have to say that having asked a bunch of IT geeks who sit around me, they all agreed that it was called an egg timer.

Does anyone know if there is an ActiveX Egg Timer that can be used and if not what could be used instead? Thanks

Thanks Peter I've declared the word application as an object or else I get a runtime error when trying to run the code for the second time. You don't know if there's anything that works with any email application do you (I wanted to include groupwise etc) - if not then I'll stick with this.

I'm trying to email out a word document as an email attachment from Access 2000. The code I'm using (that doesn't work) is: Dim objword As Word.Application Dim odoc As Word.Document Set objword = CreateObject("Word.Application") With objword .Visible = True...

I'm trying to email out a word document as an email attachment from Access 2000. The code I'm using (that doesn't work) is: Dim objword As Word.Application Dim odoc As Word.Document Set objword = CreateObject("Word.Application") With objword .Visible = True...

On the on current event of the form: If Me.MyCheck = 0 Then Me.MyText.BackColor = RGB(155, 155, 155) Else Me.MyText.BackColor = RGB(0, 0, 0) End If

Why don't you just disallow edits form.allowedits = false

Hi PH Thanks - that's totally fixed it. Sophie

Unless you want the user to be able to access previous records in which case put the code form_Open: docmd.GoToRecord,,acNewRec

just type in add_record into the YourCommandButtonName_Click procedure.

Olly Here you go: Public Sub Add_Record() Dim MyDB As Database Dim MyRst As Recordset Set MyDB = CurrentDb ' dbOpenTable is default. Set MyRst = _ MyDB.OpenRecordset("Name of your table") With MyRst 'bit that I wrote before .Close End With...

Olly Delete the record source from the form and dlete the 'control source' from each field. It doesn't matter if your combo box is looking up values from another table - you can keep the row source in for your fields. They'll still be unbound. Put this code in to add a new record to your...

I've already got the code for that but I'm having problems with where to trap the error. If I put it in the after update of the date field then I get the microsoft error message and then my error message. If it's in the on_error of the form it doesn't appear at all. thanks

The only way I've done that is by not binding the form to the table, having all the fields as unbound fields and then saving the contents of the fields to a recordset on the on_click function. Does that make sense?

I have a date field on my form that gives the above error message if anything other than a date's entered. I've tried customising the error handler in both after_update of the date field in form_error neither of which seems to work. Can anyone help please? Thanks