Search results

  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...
  16. V

    Question Data not saved after program exit

    I'll be doing just that tomorrow... hopefully I find something. If it is still doing the error, then I'll be able to troubleshoot it. I'll post back if I figure it out... Thank you all for your help. I'll check the error trapping too...ugh!
  17. V

    Question Data not saved after program exit

    gemma-the-husky: But the data is being entered during that session. Requerying the subform (sourced to the table) shows those records as present. Then, close the database and open it, and they would be gone. Would that still happen if the SQL were failing? Alas... and good call on the Execute...
  18. V

    Question Data not saved after program exit

    Also, I checked the relationships window and I have none, though that is expected because only one table is being interacted with. I will keep RI in mind should I link it with another.
  19. V

    Question Data not saved after program exit

    The_Doc_Man:: Thank you for the clarification/insight... so my next question is, how would one catch if an RI issue is causing data loss? I get it right, RI prevents unlinked/unrelational entries from existing in a relational database, and in my database, the relationship between the unbound...
  20. V

    Question Data not saved after program exit

    Thank you both for the quick replies... gemma-the-husky:: The user enters one of two ways (form or datasheet).... I made a makeshift split-form (like Access 07) but for 2003 because the users run Access 03. I did this with a datasheet subform that is directly linked to the table, and unbound...
Back
Top Bottom