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!

Recent content by Keph

  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?

    I've looked into this a bit more. I really need to be able to view many rows of data all at once and have that view editable. A table view is perfect for this except that I can't figure out how to program a lookup in a field using VBA. The lookup is important as well, since it's difficult to...
  3. Keph

    SQL select from....using variable question

    Hi, VBA doesn't know that the variables you've defined are inside the " " of your SQL statement so I think you want it to look like this: DoCmd.RunSQL "SELECT tblStock.[fkManufacturer ID], tblStock.[fkStockCategory ID], tblStock.[Stock ID], tblStock.[Stock Description]...
  4. Keph

    Rowsource for Lookup in VBA?

    mstrmage1768, thank you for your advice! I can see the logic in what your saying. However, I'll have to think about this a bit more, because for my project (which is relatively small and simple with only a few users) I think it might be simplest to leave the lookup at the table level. Either...
  5. Keph

    requery listbox automatically

    me.mylistbox.requery will force your list to, well, requery ;)
  6. Keph

    Rowsource for Lookup in VBA?

    I understand that they aren't properties of fields - that's why I'm asking for help. Doesn't anyone know how to do this? :(
  7. 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...
  8. 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
  9. Keph

    Call one function from multiple form buttons?

    Thanks for your help guys! It worked when I put the function in a module. Keph
  10. 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...
  11. Keph

    Check if a query returns rows?

    Dcount looks like it's exactly what I'm looking for, thanks!
  12. 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!
  13. Keph

    User-defined type is not defined

    Thanks a lot, it worked!
  14. Keph

    Reuse a query for multiple tables?

    Thanks, I think that might be just what I'm looking for!
  15. 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...
See more

Part and Inventory Search

Back
Top