Search results

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

I have two tables joined by StationID. In a query that shows which companies (stations) have a link (RPCustomerPoNumber) to field in the other table, but I only want to see that company name once. The query is unbound. SELECT DISTINCT tblRepReport.StationID, tblStationData.[Station Name]...

Hi To answer plog: The employees use MYOB for sales etc The database is used in conjunction for tracking possible sales, as a database of customers newsletters, calculatinng freight etc... I have downloaded a spreadsheet of products etc from the MYOB unfortunately there are many products...

I have an SQL query (Query1) that gets its data from two different tables...works fine. SELECT tblProduct.ProductID, tblProduct.PartNumber, tblProduct.Product, tblProduct.Purchaseprice FROM tblProduct UNION SELECT tblProductsMYOB.ProductID, tblProductsMYOB.PartNumber, tblProductsMYOB.Product...

Thanks Pat I have done as advised and all s well

Thanks.. works well..Excuse my misunderstandig of your previous comment

Hi I want any all companies that have a serial number associated with it, but only one instance of each of these companies