Search results

Thanks for the help...at least i can see a way forward Bob

Thanks Mate, working on it Bob

I have this situation: one table holds all the contact people for Manufacturers [tblSuppliers], another table holds the contacts for Distributors [tblDistributors]. The problem is that a few companies are both Manufacturers of products and Distributors of other company's products. I need to...

Yahoo! Thanks. i have been trying using that page of options but I guess not the correcy option. Thanks again

I have this site and have tried everything but no luck! Would a text box be different to label?

Is it possible to hide a label on one open form by the click event of a control on another open form?

My database has a field "Town" as part of the address of each customer. Each town (say Brisbane) can have many customers, so when i use a combo box to select a town I get multiple instances of each town. How do i get it to show only one instance of each town? Thanks in advance Bob

Tried all this...no good. Is there some way I could have changed a setting in Options that could do this. I have been looking into security etc

Well! I have MS 365 of course, but I bought and installed separately the Access2010 when I first purchased the computer, so I figured that in developing it would still e 2010. How can I tell otherwise?

Single desktop computer..connects to laptop for conferences etc, Database is transferred via a shared folder but generally I use only the desktop. Monitor is 9 years old and set at makers resolution

Has been there in use for years, but disappeared recently

Tried this just now...pane stays to the right...physically moved it to the centre... made no difference

In my instance the problem exists in all queries in the one database, even when creating a new query. I can get around the problem by dragging a table from the navigation pane on the left hand side. Since the development of this database is on going (bosses keep coming up with new requests), I...

YES

I have tried the same Database on another computer...same result. I have opened another (different) database on this machine and it works perfectly...so I assume it is only this database and not a problem with the machine or software (Access)

Not a thing. I have tried the same Database on another computer...same result. I have opened another (different) database on this machine and it works perfectly...so I assume it is only this database and not a problem with the machine or software (Access)

No ...accdb

I am using Access 2010

Hi, For this particular database, in query design mode I right click to bring up the menu, the click on "Show Tables" and nothing happens...no sign of the list of tables that normally appear to the right. This has only recently occurred...Could I have changed something in File..Options? Thanks Bob

Thanks all..i used isladogs idea with success...I will learn from the other info . isladogs idea