Search results

i have very little knowledge of vba. any chance you could explain how to do it?

i have to have an element of dynamic data exchange in it (its coursework) and this was the 'easiest' way. anyone? :s

anyone shine a light on this problem plz!?

sorry, just needed a quick reply, gotto hand it in tomorrow! lol

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

its my a level coursework and i have to use DDE in it somewhere

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

lol thank you both!

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

how do i do that mate

yea but i need another method. maybe by splitting it up by first letter of surname somehow. i kno the autocomplete would work but the end user has requested an alternative way

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

thats how i am doing it, the query is run, and then the records that are selected are mail merged

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

does anyone know how to solve this? really need some help and quickly!

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?

thanks, will do

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