Hi judge, that's a bit pedantic, humbleprogrammer displayed the need for declaring (dim) variables in procedures a few posts back. Isn't the law profession consistent or is that a silly question?
Jane.
A star 4 u humbleprogrammer.
I for one would very much like to see you post the code BillPower. Thank you for this. I can now upgrade client databases by just emailing an update.mdb
Thanks again,
Jane
jmooreathome@tiscali.co.uk
chrissie1, I'm very interested in your comments, how would one use ADO to connect to SQL Server without using an ODBC driver. Give an example please. I use ADO all the time but use ODBC. Thanks
Hi myke50,
The simple answer is both users. A basic example is that if the parameter was say based on a country and user 1 entered USA, user 1 would get results for USA, similarly if user 2 entered UK, user 2 would get results for UK.
For more info, do a search in Access help, copy and paste...
Hello Ken,
Could you please demonstrate the code to save the dates in an array and then sort the array as you've suggested. I'm working on a similar project at the moment and haven't a clue!
Thanks in advance.
Jane
Thanks compucop for your suggestion, but what I really want to know is how to open a form in dataentry mode using ADO. The user can still press pgup and pgdn and use the mouse wheel to navigate previous records.
It's my fault using the record selectors as an example, I don't want the form to be...
hello everyone,
I’m trying to convert my existing database to ADO. The problem is that I can’t work out how to get my forms to open in the same way using ADO as they would open if they were bound to a table or query.
I want my form to open in DataEntry Mode. My form bound to a query or table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.