Search results for query: *

can you please send a copy of the mdb to me too. gamisens@inter.net.il Thank you

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

Hello Jeff, Thank you for your reply. My listbox is unbound and can accept several queries with different calculated alias fields in different columns. Do you think there is a way I can still have this sort button functionality implemented somehow? I need the function to be able to recognize if...

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

Thank you, this was just what I was looking for. It's so goog having somewhere to turn to for answers.

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.

Thank you for all your help, but I found out Acc2000 comes with a handy replace function for doing what I need so my code ended up looking like that: Private Sub folder_ID_AfterUpdate() Dim strHyperlink As String Dim strOldSubDirectory As String Dim strNewSubDirectory As String...

Yes Kathryn, the directory is always the same. I even have the old subdirectory name as the old value of the subdirectory field. Actually all I need is to replace whatever is between the second and third &quot;/&quot; (which is the old value of the subdirectory field) with the new value of the...

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