Search results

I have created an invoicing system for a CD shop There is a transaction table which has each individual cd sold as a seperate transaction. Each transaction has an order number, so there can be more then one cd sold per order, but they all still have their own record in the table. im now...

I have created an invoicing system for a CD shop There is a transaction table which has each individual cd sold as a seperate transaction. Each transaction has an order number, so there can be more then one cd sold per order, but they all still have their own record in the table. im now...

I have a form to input details on an artist into a table. however ive just found a fault: i have split the name up into first name and surname and some artists only use one name e.g. Mario is there any way i can get the form to check if there is anything inputted into the surname field of the...

I have a table with customer details, probs over 3000 customer, and i need a method of selecting the customer in a form by their surname. Currently i have a combo box, but as you can imagine, this is not practical with so many records. anyone think of any other way to do it?

Hi im going to make an update query to deduct the quantity purchased of a product from the stock amounts but i need it to run the query automatically everytime a new record is added to the table any ideas how to do it?

ive been doing a report in word with loads of screen dumps and stuff im on page 30, and now when i add a dump, and change its layout properties to 'other' so that i can move it around, and then move the image into the text, it just vanishes along with the text and just adds loads of blank pages...

Hi, i have set up a mail merge between a query and a word document. My system is a system that processes transactions from an online cd shop. I have made it so that each cd that is bought by each customer is a different transaction in a transaction table, and each transaction is given an order...

I have a table with an ole field and i have a form with a bound picture frame to the field but the pic that is displayed is only tiny and has its filename below the little pic, how do i get the pic to fill the frame and get rid of the filename under it?

I have a customer table with all the usual customer details (customer ID, name, address etc...), a transaction table (Transaction ID, Order Number, Customer ID, Title ID, Date, Status (order received, payment taken, ready for dispatch etc...)), and i have a Title table (Title ID, Artist ID...

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?

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

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

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