Who will solve this ?

  • Thread starter Access form problem
  • Start date
A

Access form problem

I am trying to create a Sales application for my self use.

Description: My work is picking orders from customers.
Problem 1 : Now an order may contain single item or multiple items. Each
item is having further parameters like (Type, Specifications, Unit Price, and
Warranty). So is there any way to manage at run time like if I fill No of
ITEMS =5 then 5 times only i have to fill the details

For each Item , I need to fill 5 details . Type , Specification , Unit Price
,Qty & Warranty

Ex : An order may be for –

2 No Desktop @ Unit Price 40000/- each Warranty 2 Yr , Spces : Dual Core , 2
GB , 500 GB etc.
1 Printer @Unit Price2000/- Warranty 1 Year , Specs : DMP 21 Col , 80 Pin
& 1 UPS @unit price 1800/- Warranty 3 Year , Specs : 800 VA , 2 hr backup .
 
A

Allen Browne

If you plan to build an application in Access, the first (and most
important) thing is to get the database schema correct. That means
developing the right tables, so that all the one-to-many connections are
represented by one-to-many relationships between your tables.

There are 2 ways to learn about this:
a) Read up on normalization. Some links to get you started:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

b) Study some examples of normalized databases that are similar to what you
need, and learn from that how to do it.

Important: There is *no* instant option: no way to shortcut this process. I
suspect that starting with (b) will be the quickest way to get you there,
although you will want to get at least the basic facts for (a) as well.

So, start by downloading the Northwind sample database for Access. (It's
probably already on your computer if you are using A2003 or earlier.) Open
the Relationships window (Database Tools tab of the ribbon in A2007, or
Tools menu in A2003 and earlier.) See how the relationships exist so that:
- one customer can place many orders
- one order can have many line items (detail records)
- one product can appear in many order details
and so on.

You will then understand how to build your orders as 2 tables, that connect
to customers and products. In your OrderDetail table, you can then add the
fields to deal with warranties, comments etc.

Post back if you need more detail about that once you get the relational
structure in place.
 
J

John W. Vinson

On Thu, 3 Sep 2009 22:46:01 -0700, Access form problem

I'm very sorry that you are not getting the level of service you desire.

This is not a chat room. It is not staffed by Microsoft. Volunteers like me
get onto the newsgroup in our free time and answer questions (or sometimes
don't).

Posting back with a petulant "Who will solve this?" two minutes after your
initial post is either unrealistic... or very rude.

I'll try to find time to look at your technical question sometime tomorrow, or
another *unpaid volunteer* may well reply. In the meanwhile, here's your
refund of what it cost to post your question:

<>
 
K

Keith Wilby

Access form problem said:
I am trying to create a Sales application for my self use.

Description: My work is picking orders from customers.
Problem 1 : Now an order may contain single item or multiple items. Each
item is having further parameters like (Type, Specifications, Unit Price,
and
Warranty). So is there any way to manage at run time like if I fill No of
ITEMS =5 then 5 times only i have to fill the details

For each Item , I need to fill 5 details . Type , Specification , Unit
Price
,Qty & Warranty

Ex : An order may be for –

2 No Desktop @ Unit Price 40000/- each Warranty 2 Yr , Spces : Dual Core ,
2
GB , 500 GB etc.
1 Printer @Unit Price2000/- Warranty 1 Year , Specs : DMP 21 Col , 80 Pin
& 1 UPS @unit price 1800/- Warranty 3 Year , Specs : 800 VA , 2 hr backup
.

Solve what? I don't see a question, just a description of what you want.
Do you expect someone on here to build it for you for free? Not gonna
happen! Perhaps you could use or adapt the Northwind example app that ships
with Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top