Access form in Module question, Can Access do this?

A

Aldred

Hi
I used to develop ASP/ASP.net page, now I am asked to develop something
similar in Access but I am not sure if it could do that.

I have a table design like this.

Company (1) ---- (many) Part Number (1) --- (many) PO

So, that means part number table stores the PO informations.

Now, I was asked to develop this:

PO: (input field) Date: (input field)

Part Number: (input field) Unit Price: (input field) Quantity:
(input field)
Part Number: (input field) Unit Price: (input field) Quantity:
(input field)
Part Number: (input field) Unit Price: (input field) Quantity:
(input field)
....

The Access Module need to grab the Part Number from the field and check the
table to see if it is in. If one of those is not, the module will handle it
some ways. If all of those are, then the module will append the PO
information to the tables.

I had the SQL queries done. However, in Access Module, how could I create a
field looked like above? I just need to have the UI for the users to input
and the DOA programming shouldn't be hard, right?

Thanks you.


--
 

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

Copy previous record into form field 0
Autonumber field in Excel that behaves the same as Access 0
Creating a Chart on form from selected data in query. 0
Grouping Names in Mail Merge 0
Time format hh:nn drops leading zero 0
MS ACCESS: SEARCH in a split form 0
Access: Input Mask and Inserting Current Date 1
How to make one standard "extension" in a column? 5

Top