Search results

  1. R

    Suffixes in number fields

    I have a series of fields on a form into which I enter dimensions, weights or volumes. I would like to be able to automatically follow the figures I enter with the relevant suffix, i.e. "mm", "kg" or "lt". However I want them to retain their status as numbers so that I can perform calculations...
  2. R

    ActiveX calendars

    I have a form on which I log the realease and return of hired out tools. I have an ActiveX calendar on the form to enable me to enter the ReleaseDate but I would like to use the same calendar to enter the ReturnDate but at present the Control Source for the calendar is only the ReleaseDate. Is...
  3. R

    Automatic opening of forms

    I have a form - frmSuppliers - on which is a sub form - frmContacts. I have a button - btnFindContact - on the Contacts sub form to find a ContactSurname. When frmContacts is opened independently (when I know the name of the contact but not the name of the Supplier he/she works for) and I...
  4. R

    Disabling a check box

    I have a check box on a subform called Contacts. If this box is ticked then the name of the contact appears on a particular report. I would like to have this check box (and its label) enabled only when there is a contact shown - ie when the ContactID field has data in it. Does anyone have any...
  5. R

    Command button - setting focus

    Following on from my question yesterday, what I actually need to happen is for the SupplierName field to receive the focus when the Find Supplier command button is clicked. I set up the comand button using the relevant wizard. Thanks in advance for your help.
  6. R

    Setting the focus

    How can I ensure that a particular field on a form has the focus when the form is opened? Thank you.
  7. R

    Input mask - post codes

    Can anyone tell me the correct input mask to use for all UK post codes. The ? character for optional letters doesn't seem to work. I've tried >L?90\ 9LL but it won't register a London postcode with only one letter in the first section.
  8. R

    Text boxes which can change position

    I have a report which is to produce an envelope - essentially just the Name, Address, Town and Postcode fields. The address field can have a varialbe number of lines (up to four). How can I ensure that the Town and Postcode fields appear imediately below the bottom line of the address field...
Back
Top Bottom