Search results for query: *

I have a form that has multiple sub forms available as tab options. What I want to do is make it so a certain tab (berthing tab) is not available unless the person that the record belongs to lives more than 50 miles from our place of business. Is this possible? Hopefully my question is clearly...

Debbie, I have tried open Microsoft Access and then opening the database, I am not getting the error that I cannot use the file now..so it looks like that is fixed. However, I am now get an error that says "Cannot Lock File" any suggestions? Thanks David

I have a database that is not allowing more than one person to access the databas at once. Whenever you try to access the database, and someone is already working with it you get the following error: could not use name.mdb file already in use I have set the file to open as a shared file...

Jim, WOW... I feel like a total moron now... the section that you said to type the Query in the SQL View, I thought that was just for the last one...I guess I should read a little more slowly. LOL Anyway I got it figured out....thanks for your help. David

Jim, I tried your Query #1 design and I am getting an error that says that it cannot delete from the specified tables. Here is what my query design looks like. I am sure that I just misunderstood what you saying to do and typed it incorrectly. Column1 Column2 Field...

OK...here is my problem. I have an excel spreadsheet that contains the data that I want to use to update my current table with. I have created a macro to import the data into a table called temp. This macro works fine and imports the data for me. Now the hard part. I want to take the temp...