Recent content by Vigilante001

  1. V

    VBA Nested SQL Efficiency

    That's what I get for posting while tired. Thanks Lee for your in depth example, and to you mailman for your expanded post. I'll check out the ideas later today.
  2. V

    VBA Nested SQL Efficiency

    Woot! Alright! Works like a charm now; The JOIN statements did the trick. I'd like to thank you all for the insight! I'd rep many of you, but since I'm limited to one I'll give it to Namlaim|mailmaN because of the in-depth answer with sample code showing JOIN examples. Here was the resultant...
  3. V

    VBA Nested SQL Efficiency

    Gotcha... yep, that was limited to a list from the start. Gotta love human error.
  4. V

    VBA Nested SQL Efficiency

    Thanks all for the great insight! vbaInet & LPurvis, I'm going to try the JOIN modifications tomorrow and see if that runs better (I imagine so...). Just to clarify - and also to potentially clarify me if the code doesn't reflect what I thought it did - the code should be applying the same...
  5. V

    VBA Nested SQL Efficiency

    Excellent feedback all... I'm on the road to NYC, so once I'm in front of my computer I'll give these a try and report back. Thank you all!
  6. V

    VBA Nested SQL Efficiency

    VBA Nested SQL Efficiency (SOLVED) Hello Gurus, I have the following SQL code which gets the results I need. Unfortunately, it takes a long time to run. I am familiar enough with SQL to build complex queries, but in this case I'm not confident that I did so in the most efficient manner...
  7. V

    Show date range instead of week number

    No problem...let me know if it works for you...
  8. V

    Date Range from week number

    Hi QuietRiot: I was also in your situation, and I solved it via table-stored ranges. Check out the following post for more: http://www.access-programmers.co.uk/forums/showthread.php?p=810049#post810049 Hope it helps...
  9. V

    Show date range instead of week number

    Week Number to Date Range Function Hi aldeb: I've seen a bunch of questions regarding either changing or displaying the date ranges associated with week numbers. The easiest route I have found to getting what you need is through creating a table. Here is the step by step breakdown. 1...
  10. V

    A parameter for a rowsource of a combobox

    Anytime...
  11. V

    A parameter for a rowsource of a combobox

    I would set the .Visible property of the 2nd tab = No until the user makes a selection from the combobox. Based on your Mainform, subform1, subform2 setup, and assuming that page/tab 0 on subform2 is the first to see, and page/tab 1 is the one you want blocked until dataentry...In the subform, I...
  12. V

    A parameter for a rowsource of a combobox

    Hi odrap... did it work our for you?
  13. V

    A parameter for a rowsource of a combobox

    Sounds good.. just let me know. Good luck from Cleveland, Ohio, USA!
  14. V

    A parameter for a rowsource of a combobox

    Hi odrap... Are you requering the combobox after you make a selection with your supplID? If you don't requery it, the control might not show the correct list of products. I would have the query that is linked to the products combobox directly reference the SupplID combobox on the main...
  15. V

    Question Data not saved after program exit

    Pat Hartman:: 1. Yep, the table itself didn't have the records, so it wasn't a filter block on the form. 2. DataEntry is set "No", so the users see all records created. 3. That's the kind of tip that makes you lean back and say "Ohhhh...". Good to know if I decide to revamp the whole thing...
See more
Back
Top Bottom