Search results

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.

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 ;)

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

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

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.

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

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

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?

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

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

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

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

Happy I could help :)

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

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.

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. :)

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]")

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

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

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.