Search results

I now realize that the linked tables for the Subdatasheet and dropdown boxes did not get copied to the back end. I guess I have to reestablish these after I do the manual split?? Nancy

I am saving it to a different drive on the same server.

Hello, I am trying to split a database, but I am getting a message 'Subscript out of Range.' The _be copies in the remote location, but the tables remain in tact in the database. Thanks, Nancy

I manage several Access databases at work. I am considering splitting them. I understand the security benefits. But can you explain, in laymen terms, how this will increase performance. Nancy

To June7, In the property Sheet, format, Subdata sheet Expanded- I had to change to No. All is good. Thanks so much!!

This is exactly what I want!... but all of the records are showing in expanded view, how can I get then all to collapse? Nancy

I tried to create a sub form in design view, but the table I'm trying to link is an imported table from an external database and is not an option on the list of tables to choose from for the Record Source??

Hello, I have a table with a relationship to another table which creates a sub table(in the way of a plus sign to the left of each row). When I created a datasheet form from that table, I lost the sub table (plus signs). How do I get them to appear on the datasheet form?

Thanks for you help, I created a blank form for my formatting Key and inserted the main form as a sub form. Another question- is it possible to get the form to sort by the ID field on open?

I have a datasheet form (created from a table) with some conditional formatting on the cells. Is there a way I can have a key somewhere on the form so users know what the colored cells indicate?

Thanks all. This has been a big help!

Gina, I think many people have opened to the Exclusive mode. How can we change that?

No, we do not. Our IT department does not support MS Access. We treat it like any other MS Office program.

Ranman256 Yes, they are separate Access databases. They are all on the same drive, but in separate folders.

Hello, Not sure if this is an Access issue. We use a few MS Access databases at my company where multiple end users may be logged on at the same time. One DB works fine, but the Sample Log DB will not let more than one PC (or user) be opened with out getting an error message. We can't figure why...

Thanks everyone for your input. I see the now that I should hide the tables and create forms instead.

Thanks for a quick response. So, if a user (say a lab technician) is required to have access to a table to do various sorts or filters, would you recommend I create a split form from that table?

Is there a way to ensure that when a user opens the table, it will be sorted by the ID field, regardless of how the last user saved the table? Nancy

Thanks Guys, I'll try fixing the spaces and removing the symbols. To Mark- Yes, the height of the Detail section is gone; only the header shows (which is where I have the search button). It comes back when the Visible command works, or if you maximize the screen... I am doing this (visible...

Paul, Thanks for getting back... But, still does not work. However, If I take the search out, the Detail becomes visible. Nancy