Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced access training - MORE buttons on a form

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

advanced access training - MORE buttons on a form

Resolved · Low Priority · Version Standard

Reply Sun 24 Jun 2007, 10:30Delegate Elaine said...

Elaine has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

MORE buttons on a form

I've created an order form and I need to add a 'more' button onto it which allows me to add more items to the list of products being bought. It needs to be unique to each order so cannot be a subform.

Please help!

Thanks.

For upcoming training course dates see: Pricing & availability

Reply Fri 6 Jul 2007, 10:27Trainer David said...

RE: MORE buttons on a form

HI

Thanks for phoning in, it made what you were trying to achieve must clearer. What you need to do is to have:

Order table
Item table
OrderItem table

Item table: contains a list of all items that can be ordered along with ID etc

Order table: holds all of the details about the order, however not what has been ordered.

OrderItem table: holds all information about the items ordered for a particular order.

Then in you order form - you have the order details at the top and then you are able to have a sub from for the orderItem as it is now a separate table. Thus orderItems are linked to an Order. So you sub form can be just a simple table format, which can have 1 or many rows.

Hope this helps

David

Reply Fri 6 Jul 2007, 15:36Delegate Elaine said...

RE: MORE buttons on a form

Hi David,

That works great - One more question though.

In my order form if I choose to add a new record the order items are still appearing. How can I make them exclusive to the order?

Elaine

Reply Tue 10 Jul 2007, 13:04 Edited on Tue 10 Jul 2007, 13:04Trainer David said...

RE: MORE buttons on a form

Hi Elaine

Just make sure that you have the form set up properly - ie that you have the correct query for the sub form as you need to link the order item ID to the actual order item. If it is not linked then it will generally show all of the order items for regardless or which order it is.

Hope this helps

David

Reply Tue 28 Aug 2007, 15:12Delegate Elaine said...

RE: MORE buttons on a form

Hi David,

Please can you tell me how I can change the appearance of the sub-data sheet in the order form?

Thanks,

Elaine

Reply Wed 6 Feb 2008, 15:15Delegate Elaine said...

PLEASE HELP

Forgive me, I'm confused. I don't understand what I am asking my query to do.

Please help me.

Elaine

Reply Thu 7 Feb 2008, 09:35Trainer David said...

RE: PLEASE HELP

Elaine,

You just need to make sure that everything has a UNIQUE ID, the order item table must have a unique ID, the order item must have a unique ID. The order item table should contain a field called order which contain the unique order ID. If you make sure you are using unique ID's you should have no problems.

Hope this helps
David

Access articles

· Three Myths About Microsoft Access
· How To Take Control Of Your Data And Save Money In The Process
· Microsoft Access and Customer Surveys
· How To Create Calculated Fields In Access 2010 Tables
· Access And Its Uses On The Web

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips