Search results

  1. V

    ShowUsers on another Database

    Hello, I found the following code on Microsoft and applied it to my BackEnd which obviously only had the Admin logged, which is me. I would like to alter this code to check if someone is in another Database - such as the accde. I would like to find out who is in the database so I can reach...
  2. V

    Dropdown works on Form but not within Navigation

    I had to clean up some things before putting it out there, but basically it's the Active Estimates and Complete Log tabs that are having the issue currently. Thank you for taking a look
  3. V

    Dropdown works on Form but not within Navigation

    I have a form that opens in datasheet view and allows the user to select options from dropdowns in some of the fields. When I use the form on its own the dropdowns can be selected, however, on once it's in the Navigation form, the dropdowns drop down but I can't make a selection. What is missing?
  4. V

    SourceObject with criteria

    I tried both of these and got Run-time error 2465 Application-defined or object-defined error. I still want to be able to add the "where" so it opens on the record DoCmd.OpenForm "FormD", , , "RequestID=" & RequestID, , acDialog Me.Parent.FormC.SourceObject = "FormD"...
  5. V

    SourceObject with criteria

    I have a main form (Form A) with a subform embedded (Form B) When I click a button to open a second form (Form C), gets embedded Me.FormB.SourceObject = "FormC" ' - no problems there Form C has a double-click event to open the specific form to the record: DoCmd.OpenForm "FormD", ...
  6. V

    Refresh SubForm

    Firstly, thank you for taking a look! I removed that from the control so now that filter holds the selection, but until I select something in Station or Line dropdown nothing filters. The Reset and Show all don't clear the combo selections
  7. V

    Refresh SubForm

    The combos are not bound to anything
  8. V

    Refresh SubForm

    there's no code behind that right now but ideally that's the third filter and it should be able to filter with any of these selected
  9. V

    Refresh SubForm

    It won't let me save as a downgrade. :(
  10. V

    Refresh SubForm

    I have ensured that the Master and Child links are correct. In my subform I removed all events and filters and the form, on its own loads all records. but it won't let me filter both
  11. V

    Refresh SubForm

    HI All, I have a main form (frmIncRetEstimates) with three combo boxes and a SubForm sfrmEstimateLogSummary) that opens in Datasheet view and is linked by the Link Master Field and its Link Child Field The SubForm when opened on its own has a filter and the Filter On Load is set to Yes. I...
  12. V

    Requery combo box on load/open

    I get an error trying to save it downward because it "requires features used" - Thank you for your attempt
  13. V

    Requery combo box on load/open

    what is not allowing you to open it?
  14. V

    Requery combo box on load/open

    from the main form, click on the second option (Review Active Estimates) or from the forms list, it's frmIncRetEstimates
  15. V

    Requery combo box on load/open

    The combo box is unbound. Is there an alternative?
  16. V

    Requery combo box on load/open

    Scenario: Form A contains: a combo box to select a requestor VBA - Form Load: ComboBoxControlName.Requery (I tried this OnActivate too) VBA - combo box AfterUpdate MyFormControlName.Form.FilterOn = False Form B (datasheet view) Form B Form Load will filter the records on the current user...
  17. V

    Solved Unfilter subform after combox selection

    I have a subform that OnLoad will filter by the current user but sometimes they'll need/want to see other tasks (primarily for supervisors). So the OnLoad of my SubForm filters on the current user. On the main form, which only contains the combobox to select another user the parent/child...
  18. V

    Navigation Forms - acBrowseToForm v SetFocus

    I modified it. Click on Edit Details > Project Details > Status (onChange Event (thinking it should go in BeforeUpdate but...) When the status is Complete the Cost Details must be entered. How do I navigate to that tab?
Top Bottom