Search results

  1. I

    Calculate Tax week no. based on Date in Text box?

    Good Morning All, I'm currently building a form that I need to show today's date and the tax week number in a taxt box (Just in case it needs editing) I'm aiming to have these automatically populate based on the information I've assigned in the date text box E.g Date text box =(Today) Is...
  2. I

    Cant interact with Subform in main Form

    Hi all, I've got an add category form with a list of the current categories in a continuous subform on the bottom of it. When on open the subform on it's own it allows me to edit the text and change the tick box to on or off. However when the subform is open in the main form it won't allow me...
  3. I

    WHy does it go to the next field when I've asked it to set focus to a specific box

    Which Event would be best for this scenario then? Thanks
  4. I

    WHy does it go to the next field when I've asked it to set focus to a specific box

    Hi all, I've set the code below on a text box so it only allows the user to enter numbers. However when I enter in letters and hit Tab it brings up the message and instead of setting focus back in the current box it goes to the next field. How do I stop that from happening? Private Sub...
  5. I

    Easier way to change colour of text when text box is active?

    I'm currently working on an add customer form and because it's a lot of data I'd like the label for my text boxes to turn red when i'm using it's corresponding text box. Currently I'm using VBA to change it as an After_Update from the previous text box entry but I'm hoping there's an easier...
  6. I

    Add a multiple choice list on a form that creates new lines in the destination table

    Hi all, I'm currently trying to add a multiple option box on a form for different pot sizes. I know it's possible to use the multi-value combo box and the multiple choice when using a list box but 'm not entirely sure if it will generate two different lines on the destination table i'm...
Top Bottom