Search results

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...

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

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

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]...

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...

I have a need to limit the number of times a company comes up in a query result. I have two tables: tblStationData, and tblSerialNumbers I have tried SELECT DISTINCT tblStationData.StationID, tblStationData.[Station Name], tblSerialNumbers.SerialNumber FROM tblStationData INNER JOIN...

I have a table imported from Excel...(Screenshot below) It relates to freight charges and I am required to programme vba to allow the user to enter say 2.5 Kg and Zone 4 and have the answer 109.75. I have no idea so am looking for any ideas which will be much appreciated Thanks Bob KG...

I have a form (frmContactDetailsPower) with a form (frmProgressiveNotesEntryPower) linked by [StationID] from txtStationID. Form frmProgressiveNotesEntryPower is linked to a table (tblProgressiveNotes). I need to be able to search the table (limited by the StationID) for each instance of a...

Hi, I am a selftaught access programmer working for my son's company. I am by no means professional