Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. janeatwork

    Requery makes frmCustomers go back to record 1.

    Hi zevw, Really good idea. Jane
  2. janeatwork

    dbAutoIncrField. Cause of Problems???

    Hi BillPower again, Thanx, thanx, thanx for sharing your knowledge. This is another so helful to me answer. Thanx Jane
  3. janeatwork

    Syntax error is making me crazy

    Hi r937, Love it. A * 4 u Jane
  4. janeatwork

    How do I access the SQL behind a query using ADO

    Good stuff Tranman A * 4 u Jane
  5. janeatwork

    import table via ODBC

    Hi DerickD I like this one too. Jane
  6. janeatwork

    how do i recode the value of a null field

    Hi Hap007, I have given you a star for having the acumen to spot this and also having the courage to point it out. JAW
  7. janeatwork

    Stop "form view" in status bar

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

    Nested IIF vs Select Case

    Really excellent suggestions MichaelRed and scriverb. Thanks Jane jmooreathome@tiscali.co.uk
  9. janeatwork

    linking tables externally

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

    Connecting to/Updating SQL Srv d/b from Office XP

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

    How to concatenate variables and use it as a new one

    Why don't you post this as a FAQ?
  12. janeatwork

    Find Date

    Thanks Ken, But don't really understand at all?
  13. janeatwork

    Multi-User Question

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

    Find Date

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

    How do I get my form to open in proper dataentry mode using ADO

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

    How do I get my form to open in proper dataentry mode using ADO

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

Part and Inventory Search

Back
Top