Search results

can this happen if you alter the 'one' part on a 'one to many' relationship?

only 1 sub form record is being viewed at the same time. what are the main reasons for this? apart from having to set the form to being continous? Many thanks in advance

ok thanks for the advice!

if I had tblOrders OrderNo, CustomerNo, Date, OrderTotal tblCustomers CustomerNo, Name, Street, Country, Postcode and I was asked to delete orders placed by customer Smith, would I be correct if I put this: DELETE tblOrders* FROM tblOrders INNER JOIN tblCustomers ON...

ok moving slightly away from this question I have another . . What two reasons can be given if the records that are shown in the subform are the same irrespective of the record on the main form. I would firstly say that they are not correctly linked (i.e. VB coding), buy not sure why else?

Absolutely. I have my database module exam tomorrow. I've learnt more in the last week from helpful people like yourselves than I have from him. Never mind! I know plenty to pass the exam now I hope. It does seem like a bit of a weak question to be honest . .

What be 3 good checks to verify correct operation of a form and its subform?

"the changes you requested have not been successful because they would create . . ." I open a form and attempt to add a record to its subform... I am getting the message: "the changes you requested have not been successful because they would create dublicate values in the primary key or...

There are supposedly 3 checks to verify correct operation of form and subform? What are they? Check if to certain fields are locked to stop others changing data on purpose or accidently? Check to see that data changes with the rest of the data (linked) in both? Am I on the right lines...

thankyou very much

Going back to the top one . . . would it be . . . CREATE TABLE tblArchive ON tblCustomers WHERE customername = "x" ?

Also, on a Parts table, I need to increase all parts whose description includes the word "washer" by 4% Is this correct: UPDATE tblParts SET Price = Price*1.04 WHERE Description LIKE "%washer" I'm usually wrong about these things!!

How would I archive all orders place by customer 'x' in to a new table called tblArchive? something like: CREATE INDEX tblArchive ON tblCustomers WHERE customername = "x" ?

Archive all orders placed by customer Clarke into a new table called tblArchive. how do I put in a new tables using SQL? Increase the price of all parts whose description includes the word “washer” by 4%. Do I have to * by 1.04 ?

Excuse me what? Yes its my exam - and I'd like some help! This is last year's question and I'd like someone to answer it. I want to do well, and I have 3 weeks until the real exam is upon! Thanks in advance.

By doing this, for part 1 I got: SELECT tblCustomers.CutomerNo, tblOrders.OrderTotal FROM tblCustomers INNER JOIN tblOrders ON tblCustomers.CutomerNo=tblOrders.CustomerNo WHERE (((tblOrders.OrderTotal)=">1000")) ORDER BY tblCustomers.CutomerNo; and for part 2 I got: SELECT tblOrders.OrderNo...

Thanks for the reply. Will be really useful - am gonna do now. If someone could write what they think is correct - I'd be v appreciative!

haha I don't think so. I'm studying multimedia technologies and I was never expecting a database module! Pretty much all of us on this course are great at all modules but this one. The people who are good at this are the people on the programming course - cos their is a piece of piss for them -...

Hi Guys, I have an exam coming up and I have a few past paper questions that I need answers to, to see if my ones are correct - to enable to further revise this topic. I'm really looking for model answers - so I can make some good progress! I dont just want to pass - I want to at least get a...

Hi Guys. . . In a few weeks I have to face a dreaded database exam. I have lots of past papers and questions . . and I'd just like to pop only 2 or 3 to see what answers you guys would give. I am really looking for model answers - to help me further revise. 1. Describe three checks that...