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!

  • Congratulations bkrike 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: *

  • Users: Keph
  • Content: Threads
  • Order by date
  1. Keph

    CVS of more than just code?

    Hi, I'm new to CVS, but I can see how it is a powerful and useful tool. However, I was wondering if there existed a system that did versioning of more than just source code (text). For example, is there a system out there that allows the similar versioning of an entire website (images, directory...
  2. Keph

    Rowsource for Lookup in VBA?

    Hi, when in the design view of a table, there is a tab at the bottom that says 'Lookup'. In this tab there are two settings 'Rowsource' and 'RowsourceType'. I would like to be able to set these using VBA. CurrentDB.TableDefs("MyTable").Fields("MyField") does not seem to have...
  3. Keph

    Logout current user programatically?

    Hi, I'm using user-level security and I'm wondering if there is a way to logout the current user using VBA and have access prompt the user for a new username and password. This would make switching between users much easier. Thanks, Keph
  4. Keph

    Call one function from multiple form buttons?

    I know it's easy to call an event proceedure from a form button, but I have several buttons and I want them to call the same function (passing it a different argument for each button). I have the function created on the same form as the buttons. I tried entering the name of the function in the...
  5. Keph

    Check if a query returns rows?

    I'm trying to find a way to check if a given query returns any rows. I can't seem to find anything like this in these forms or in the MS Access help files. Can someone point me in the right direction? Thanks!
  6. Keph

    User-defined type is not defined

    Whenever I try to define something as QueryDef (i.e. Dim MyQuery As QueryDef), it gives an error message saying "User-defined type is not defined". I'm only at a beginner's level with VB, so it's confusing when examples right out of help files give errors on the second line! I've tried...
  7. Keph

    Reuse a query for multiple tables?

    Hi, I'm wondering if it's possible to write a single query and use it to query multiple similarly structured tables. The tables have a few columns in common but are different enough otherwise to be in separate tables. I have managed to pass a paramater to a query, but I can only get the...

Part and Inventory Search

Back
Top