useing access to create orders

[Emily]

I have all my inventory in access and now i want to create and order form in
excel. I want to somehow with ease be able to select from the inventory in
access and have it appear on the excel order form. I also want the access
database to update the amount being taken out of stock as the item is entered
into the excel order form. How do I do this??

Emily

 

[Wayne-I-M]

Hi Emily

Is there are reason why your ae using excell and access. It sound like you
would b better using one or the other - and if you have the items in access
it would not take much work to process the whole thing in access. Of course
you "can" export "stuff" if you really need to - but if there is a reason
only, or it's just more work

 

[Tom van Stiphout]

On Thu, 22 Nov 2007 12:13:00 -0800, Emily

You're making it more difficult than needed by involving Excel.
Take a look at the Northwind sample application. It has a nice Orders
form. It doesn't do inventory, but this page may help:
http://allenbrowne.com/AppInventory.html

-Tom.

 

[Emily]

Since I have a growing inventory, and it currently has over 1000 items in it;
I found that access would be better suited to hold that info, also I wanted
someting that could be easyer to update since I have many things coming in
and out of the inventory. I would like the order forms to be made in excel,
since the company that I am sending them to wants it that way. Is there a
way to make order forms in access that I can send? In truth I would like to
have all of it in one program, can I do this?

Emily

 

[Emily]

TY for the link. Excel is not my first choice, and I would rather not involve
it. The most inmpotand thing is that the inventory will auto update the
amounts in it

Emily

 

[Wayne-I-M]

Hi Emily

Have another look at Tom's suggestion (below). I can't see your application
but this looks to be just the type of thing the access was design for.

Store = 10 cakes
Sold = 1 cake
Query [cakes in store]-[cakes sold]
OK that would be better in excell

BUT
Cakes now in store = 9
If cakes in store go below 10 then show me a list of all cake suppliers we
have used in the last 5 years ("very" difficult in excell - "very" simple in
access)

Next automate the cake order to bring the amuont in store over the minimum
to be held in stock - automate the email to my chosen suppler from the list.
- send the order in xls format - oh yes and send a copy to the accounts
office in rtf format and print a file copy rich text.

Do all of the above by selecting a product and supplier. Not too hard in
access don't think this can be done in excell.

Have another look at the northwind DB and if you have specific question (how
to) then you can always pos here and someone will answer hopefully,

Good luck