Search results for query: *

I have a complex form with 4 subforms on it all set to record level locking (Access 2000). When a second user attempts to edit a record that is being edited by another user access beeps (as it should) but I would like to display a message box explaining that the record cannot be edited right...

I am trying to program a button to sort a listbox by changing the SQL rowsource. I saw a post by you suggesting this technique. My initial SQL is: SELECT AssayID, AssayName, DLookUp('[Value]','ValueList_Items','[ItemID] =' & SeqTypeID) AS Type, GeneSymbol, GenomicLocation AS Location FROM...

I have a piece of code I got from a book that is supposed to handle multiuser record editing error. When I try to run it I get an error message “object doesn’t support this method or property” for this line of code: If ctl <> RSC((ctl.ControlSource)) Then .... As far as I understand, this...

I would like to copy an internal bitmap from the picture builder (the one you use to add icons to command buttons) and paste it into an OLE type field in a table in my database. Can this be done? Thank you.

I have a database with the following structure: an items table has a one to many relationship to a groups table. The groups table has a many to many relationship to a members table through a connecting table of group members. I need to find an item by searching for member data but there is no...

I have a database with the following structure: an items table has a one to many relationship to a groups table. The groups table has a many to many relationship to a members table through a connecting table of group members. I need to find an item by searching for member data but there is no...

I would like to loop through the field collection of a table and store the fields caption in an array variable. Can someone help me with the code to do this? I dont see the option field.caption available when I loop through the collection, I can only get field.name or field.value. Thank you.

I have a tab cotrol with 3 pages on a form. Under certain conditions I would like only the first page to be visible and hide the other two pages. Can someone help me with the correct syntax for doing this in VBA? Thank you.

I have a hyperlink field in a record in my table that links to a specific word or excel file (something like #description#x:\directory\subdirectory\filemane). Another field of the same record specifies the subdirectory name where the word or excel file is found. I would like the subdirectory...

I have a hyperlink field on my table that links to a specific word or excel file (something like #description#x:\directory\subdirectory\filemane#). Another field of the same record specifies the subdirectory name where the word or excel file is found. I would like the subdirectory part of the...