Search results

  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?
  16. 1

    Find number of records based on Date Difference

    Hi All, I have a table with RMA (Return Merchandise Authorizations). This table has many fields, RMA #, Serial Number, Return Date, etc... My goal is to find how many serial numbers have been returned annually over the last 4 years. Most serial numbers are only returned every 2 years, so I...
  17. 1

    Form switches to READ ONLY after filter

    Hi and thanks for your reply! I've changed the filter string to "" before turning off the filter. I have discovered that when no records are returned for any of the filters, the form shows as 'filtered' and becomes read only, when I run the Command76 to clear it, the form goes back to normal -...
  18. 1

    Form switches to READ ONLY after filter

    Hi All, I have a continuous form based on a query (the query has 2 tables with 1 relationship, it's fairly basic). The problem is sporadic, which means I can't figure out the trigger causing it, but after the user filters the query either by serial number, or customer, etc... the form will...
  19. 1

    Create Backup of Back-end .mdb

    Hi MarkK, I just use a simple macro to backup the backend file to my local machine, although I'm sure you can back it up wherever you like. I use a timed backup, so the top of every hour this macro runs: For the condition: Time()>=TimeValue("07:00:00") And Time()<TimeValue("07:01:00")...
  20. 1

    Update Multiple Table Records With VBA Query

    pbaldy, thank you very much for your help!
Top Bottom