Search results

  1. CraigDolphin

    Problem with Database Copy

    You could also try compiling the database to find any vba errors. Open the vba editor>Debug Menu>Compile <dbnamehere> This should highlight any code which might be causing the db to stop running the code and give you somewhere to start with tracking down the issue.
  2. CraigDolphin

    2 questions on multi select list parameters

    As a suggestion: you could make a copy of the db to share, and remove all real data and repopulate with some fake data enough to demonstrate the issue. Sometimes it's a lot easier to delve in hands-on than play 20 questions ;)
  3. CraigDolphin

    2 questions on multi select list parameters

    Try surrounding all references to 'Cost Center' with '[Cost Center]' (without the quotes)
  4. CraigDolphin

    How do YOU validate your results?

    Thanks Brian. I didn't mean to put you on the spot but I have learned that it's much smarter to benefit from the advice of people who have been there and done that, rather than undertaking to learn the same lesson via the school of hard knocks. Admittedly, I seem to be more able to take the...
  5. CraigDolphin

    2 questions on multi select list parameters

    The code would build the string dynamically based on what you selected in the listbox....and if you look at the example Paul linked, that's likely exactly what happens.
  6. CraigDolphin

    How do YOU validate your results?

    So, does this mean that you design test data in such a way as to challenge the assumptions implicit in the data model?
  7. CraigDolphin

    2 questions on multi select list parameters

    I think the only method to use multiselect list boxes as criteria in a query is to build the SQL string using vba to loop throught the listbox items, and if the item is selected, then add this to a comma-separated list which is used in conjunction with the 'In' operator. So the final sql for a...
  8. CraigDolphin

    How do YOU validate your results?

    I should point out that I'm not an IT professional and I'm not saying my approach is the best way...it's just what I do. Brian....I'm interested...any chance you'd outline something of the process you'd use in designing test data?
  9. CraigDolphin

    How do YOU validate your results?

    It depends how complex the query is. Simple queries without outer joins etc I have done so often that I am VERY confident in the result set. But for more complex queries, I usually sub-sample specific results/values. And I especially look for situations where I know there could potentially be...
  10. CraigDolphin

    Simple task

    In the criteria row for the field containing the date, type... Is Not Null ...then open the query. It should have what you want.
  11. CraigDolphin

    Question Access and Citrix - some questions for those who have done it

    Thanks for the links...an interesting read and some of the issues he mentioned strike a chord with my own experience as a victi...er, user... of citrix. But there are more issues too....though I'm not saying these are necessarily inherant to citrix as they could also be partly due to our local...
  12. CraigDolphin

    Question Water quality database

    Gemma, that's a very good point. that said, my solution is very narrowly tailored to the tribe's protocols and needs. While it could be adapted, it is far from being ready to ship as a general commercial product. That said, there are commercial WQ applications available on the market which do...
  13. CraigDolphin

    Criteria In A Query Not Evaluating In Code

    Happy I could help :)
  14. CraigDolphin

    Question Access and Citrix - some questions for those who have done it

    If it means never having to wait for that damned citrix loading sequence again...I'd be close to breaking even :p
  15. CraigDolphin

    Question Access and Citrix - some questions for those who have done it

    I still hate **itrix! :p But my frustrations with it reduced remarkably when I switched to a laptop with a local copy of Access and got rid of the PNA-Agent file type associations. K...sorry to distract! :D Carry on.
  16. CraigDolphin

    Criteria In A Query Not Evaluating In Code

    Interesting link Paul. I've always managed to just use the eval function in the query itself to solve this issue, but it's always good to know another way to skin the same cat. :)
  17. CraigDolphin

    Criteria In A Query Not Evaluating In Code

    To resolve this I suspect you will need to wrap the criteria reference in your query in an Eval("") function. So, instead of [Form]![Formname]![ControlName] you should use Eval("[Form]![Formname]![ControlName]")
  18. CraigDolphin

    Question Water quality database

    Ok, have pm'ed you to have you send me your email address so I can send those to you.
  19. CraigDolphin

    Question Water quality database

    Quoted for truth. I have designed an extensive water quality database for the native american organisation where I work. This database is setup based on the concept of water quality sampling 'runs', and not only stores the information used by the Water Resources department, but must export data...
  20. CraigDolphin

    Question one-to-all relationship

    Then page 2 should be based solely on a query of the products table, with additional calculated fields for the other 'details', using parameters taken from the current client details on page 1 as inputs for your calculation.
Back
Top Bottom