Recent content by Mozz

Hello, I've inherited someone elses databases and I'm tryi ng to update some tables to add new fields. When I look at these in design view I get this message: "Table ... is a linked table with some properties that can't be modified" And it won't let me add these new fields. How do I get...

Hello, I'm trying to use Access as a library catalogue for the charity I work for, and although fairly happy with the results I would like to move it on abit, away from using "Filter by Form" as a way of searching. My catalogue is about to go "live", and I would like the users here to come...

Hello, I'm trying to limit the number of text characters displayed in various fields on a form. I want it to appear so that after a certain number of characters it then displayed "..." indicating there is now information in a field. Thanks for any help!

Thanks four your help it's really moved me on. Mozz

Ok, but how do I get the query to display all the fields, and then on the form get the filter to look at two or more fields. For example I want the whole table to appear in a form, but want the filter to look at two fields when I filter, so when I filter a field named "Author" it will filter...

Hello, I'm new to using Access, and come from a library background, and I'm trying to use Access to build a library database. So far it's going well, but when it comes to searching using a form and applying a filter I can only get it to search one field at a time, and really I want to search...