Recent content by 123dstreet

  1. 1

    Handle Multiple Textboxes with 1 code

    Yes this is multi-user with front and backend split. I'll stick with the global refresh it seems to work well. Thanks for your help!
  2. 1

    Handle Multiple Textboxes with 1 code

    Here is a screenshot of my form in Design View.
  3. 1

    Handle Multiple Textboxes with 1 code

    Yes I meant to say bound. I'm curious why I need to refresh then...
  4. 1

    Handle Multiple Textboxes with 1 code

    Yes I just checked out your video, I am using the identical NZ([Text0],0) equation in an unbound textbox, but my entry textboxes are controlled where yours are unbound, maybe this is the difference?
  5. 1

    Handle Multiple Textboxes with 1 code

    This works perfectly: In design view select all textboxes. In the after update event put in =Refresh Without the refresh, the unbound textboxes with the total don't update at all unless I close and re-open the form, I'm clearly missing something here? D
  6. 1

    Handle Multiple Textboxes with 1 code

    The total is located at the bottom of each column in an unbound textbox, but unless a refresh is done the total isn't updated. I'd like it updated in real time as soon as the user enters their hours. I'm sure I could be doing a lot differently, but if there's a possible way to do this that...
  7. 1

    Handle Multiple Textboxes with 1 code

    Hello, I am creating a Timesheet/Payroll database, on the main timesheet form there are about 100 text boxes where the user can enter their hours (10 days in the pay period x 10 different possible tasks. In order to update the total hours immediately, I require the following for each textbox...
  8. 1

    Filter Upon Filter in Continuous Form

    Beetle, Worked like a charm, thank you very much!
  9. 1

    Filter Upon Filter in Continuous Form

    I don't think they are the same. If the user wants to see what falls into FilterA, then they decide they want to narrow the search down even further, so they use FilterB, the result should show both FilterA and FilterB combined, but when I use FilterA, then decide to use use FilterB, it only...
  10. 1

    Filter Upon Filter in Continuous Form

    Thanks for the quick reply! The problem is I don't want to run both filters at the same time. For example, the user filters by Product first, now they want to filter it even further with one of the other optional filters in the header... Do you have to include the previous filter in the most...
  11. 1

    Filter Upon Filter in Continuous Form

    Hello, I have a continuous form that shows all the records from TableA. In the form header I have added multiple filtering options using either text or combo boxes. Each filter uses the following VBA executed by a button: Me.Filter = "[Priority] Like" & "'" & Me.Combo94 & "*" & "'"...
  12. 1

    Recordset is not Updatable - Access 2010

    Unfortunately due to security reasons I cannot upload anything from this DB. Although, I have found a temporary solution to the issue: When the form is opened, the records cannot be edited or updated, etc. But when I run a filter, then clear the filter with VBA, the form goes back to being...
  13. 1

    Recordset is not Updatable - Access 2010

    Hi JHB, Thanks for your reply, I'll try to clarify the best I can. Normally, when the form is opened, the user can add new records, edit records, delete, etc. The "Allow Edits" property has always been set to "Yes". Now, in Access 2010, when the form is first opened, no new records can be...
  14. 1

    Recordset is not Updatable - Access 2010

    Hi there! I've got an odd issue here: I have a continuous form that displays 1000s of records, each record has multiple check boxes, text boxes, combo, etc. When I open the form using Access 2010 - it is defaulting to a 'read only' state and I cannot edit any of the records. A weird fix -...
  15. 1

    Find number of records based on Date Difference

    Could you give me a quick example as to how I would do that?
Top Bottom