Recent content by Keph

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

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

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

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

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

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? :(

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

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

Thanks for your help guys! It worked when I put the function in a module. Keph

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

Dcount looks like it's exactly what I'm looking for, thanks!

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!

Thanks a lot, it worked!

Thanks, I think that might be just what I'm looking for!

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