Search results

  1. J

    Having Query Results Populate in a Drop Down

    Frothingslosh, thank you so much for your time explaining everything. I was concerned after my last post required approval, for said reason. Regardless I found your knowledge, and direction extremely helpful. Please note your time is greatly appreciated. I will surely return to this forum...
  2. J

    Having Query Results Populate in a Drop Down

    Finally was able to identify the line of code I wrote to Ignore the 3061 Runtime Error was actually skipping over the Like "qryQC_*" line. This was resolved by utilizing proper error handling using "On Error Resume Next" Again, thank you all so much. This was an excellent learning experience...
  3. J

    Having Query Results Populate in a Drop Down

    Please excuse my ignorance, [Utility Functions] is something I just googled to make the qry's populate in the combo box. Which does work great. Only problem it pulls all qry's. The issue I'm having is the "Like "qryQC_*" not having any impact on the results that populate within the combo box...
  4. J

    Having Query Results Populate in a Drop Down

    Thank you both again for the pointers. I have tried both suggestions, and still no change in the result. Here's the screen shot in a zip.. Everything works without errors. It's just providing me with all the qry results. I'm only wanting to see those that match Like "qryQC_*" in the combo box.
  5. J

    Having Query Results Populate in a Drop Down

    Now that I'm able to place the qry results in the combo box.. How can I make it so the only choices to choose from are queries that begin with "qryQC_" ? I've tried this, but it doesn't work unfortunately.. If qdf.Name Like "qryQC_*" Then I must be missing something. Screen Shot...
  6. J

    Having Query Results Populate in a Drop Down

    Thank you for your prompt responses. After spending a few hours with trial and error I was able to resolve it myself. The objective was to pull all results from all queries named like "qryQC_" Then place them into a combo box for selection. Not that it may be useful to anyone, but the final...
  7. J

    Having Query Results Populate in a Drop Down

    Hello, I am new here, and new to using VBA in Access. I've been presented with an existing code below. The objective is to have Access Pull Query Results in a Drop down. The code errors out on the line in red. Can someone point me into the right direction to make this work? Any assistance...
Back
Top Bottom