Search results

is there any way to add a button to a switchboard but not have it appearing on every s/b because in design view, it just shows a generic board, how do you edit specific boards?

how would you suggest to do this then workmad3? if you are on msn messenger, please can you add me as i really need some help quickly amavadia@gmail.com

Neil, thing is i want to do it in a query so that i can produce a report based on it but its not working the way pat said to do it. any ideas how to do it in his way?

thanks robert, thats exactly what i wanted is there a way of selecting the correct customer in the subform and all their details get filled in the main form automatically?

I have done this but when i run the query, there is no total, it simply shows the prices of each indiviual product, how do i get a total at end of it?

Fields of tblCustomer: Customer ID First Name Surname Address 1 Address 2 Address 3 Post Code Email Address Telephone Mobile Fields of tblTitle: Title ID Name Artist ID Record Label Release Date Source In Stock Quantity Genre Buy Price Sell Price There is no need for quantity of product...

Hi, i have a customers table, products table, and a transaction table that brings them together fields in tblTransaction: Transaction ID Order Number Customer ID Title ID Date Status I want to create a query so that you can type a name of a customer in, and it will bring up all the items they...

yep i get that, but i need a little menu to select the letter of the surname because its for my ICT coursework and im not going to get the mark unless i do that apparently

Hi, I currently have a table with a load of customer details: tblCustomer and i have a form with a combo box that looks up the customer's record with a drop down menu by the surname then the firstname columns from tblCustomer. The problem i have is there will be over 2000 customers in the...

I have a combo box on a form that allowes the user to select a record to be displayed in the form. The problem is i have about 3000 records in the table. Is there any way you can create a drop down menu with all the letters of the alphabet, and then use that to filter the records available in...

I have a combo box on a form that allowes the user to select a record to be displayed in the form. The problem is i have about 3000 records in the table. Is there any way you can create a drop down menu with all the letters of the alphabet, and then use that to filter the records available in...

I have a table with customers, one with products and one transaction table. How can i produce a report, based on a query that will add up the total any one particular customer has spent to date from the transaction table?

Thanks for the reply mate thats exactly what i have at the moment, but i want to make it so that to find a particular customers record, the user can type in the customers surname into a text box, click a button and it will lookup the details on that customer and display them in the form...

Robert88 Thanks for posting that file, but can you explain how it works please. It also seems quite complicated and i do not need all the date selections before searching, just so that the user types in the surname and it searches a table, and brings up the details in a subform. Thanks

Hi, i am a beginner to access and need some help if someone would be kind enough... i have a table (tblCustomer) which has all the standard customer details such as name, address, phone etc. The primary key of the table is a autonumber field (Customer ID). i have autoformed it so all the fields...

Hi, i am a beginner to access and need some help if someone would be kind enough... i have a table (tblCustomer) which has all the standard customer details such as name, address, phone etc. The primary key of the table is a autonumber field (Customer ID). i have autoformed it so all the fields...