Search results

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

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

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

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

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

Hi Guys. I Need your fantastic help again! Attached is my access document. I have some reports - to show which student have what marks for their exams & coursework and to show which student does which module they are studying. Could someone either build a seperate form for me with a way of...

I have a major problem. I can figure out. I'm going to give you as much info as possible to see if you can help me. I will be forever grateful if you can. I've been looking at books and tutorials all day and I feel like and idiot because I cant get my head around this. The business department...