Search results

Hi there I've have a form used to input/edit people data. The form has an exit/save button which performs various tasks via the click event. One of the tasks is calling a subroutine to validate some of the form's fields (subroutine attached). The UPN validation works (the first check), but none...

Hi There I'm trying to pre-populate some fields on a form using the following code in the on activate event: With Me.CreatedBy .Enabled = True .SetFocus .Value = tmpClass End With With Me.Location .SetFocus .Value = tmpLocation End With...

I'm trying to construct an sql statement that will filter the contents of a field (from a query), based upon the contents of another field on the form. The statement works if I put a string in the where clause instead of the filter field name, but I don't know how to specify the field name in...

Hi there I have a form that lists people. Each field has a click event that opens a people detail form using docmd.openform "PeopleDetail", , ,"str(PeopleCode = " & str(Form!PeopleCode). The detail form opens but always displays the first people record. PeopleCode is an AutoNumber, hence the...

Hi there. I want to write some script that will pick up new email message in my outlook inbox. If picking new emails can't be done, then having a script to read the emails then delete them would do. Any ideas? Thanks

Hello. I am trying to automatically refresh a form when focus returns to it. When I click on a control in the form another form is opened for new record entry. When the new record entry form is closed, the original form does not display the new data (the original form is tabular). I've tried...

Hello everyone. I have a tabular form with a textbox control containing an integer value on each row. I wish the colour of this textbox to vary on each row according to it's numeric value i.e <50 is green, >=50 and <100 is amber, >100 is red. Any ideas? Thanks a lot :confused: