By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,509 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,509 IT Pros & Developers. It's quick & easy.

inventory

P: n/a
i've got a basic order entry d-base w/ a form for adding products, etc.

can anyone help me w/ inventory control?

i want to be able to not only enter a new product but also enter the number
of units. then once a sale is made on a given item it subtracts the number
of units sold from the inventory. is this a big task.

help

thank you,

//frank
Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Yes, this is a big question.
There is no one-size-fits all solution, but to set you off on a useful path,
see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbr...Inventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:FL*********************@news04.bloor.is.net.c able.rogers.com...
i've got a basic order entry d-base w/ a form for adding products, etc.

can anyone help me w/ inventory control?

i want to be able to not only enter a new product but also enter the number of units. then once a sale is made on a given item it subtracts the number
of units sold from the inventory. is this a big task.

Nov 12 '05 #2

P: n/a
Hi,

I have a demo application for parts stock management and inventory control
(although not finished) written in Visual FoxPro 8.
You can download it from http://amssoft.dyndns.org:8090/Chris/

However, it can be developed in Access too.

If you are interested to get more info about this, you can e-mail me.

Regards,
Bogdan Zamfir
____________________________
Independent Consultant

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:FL*********************@news04.bloor.is.net.c able.rogers.com...
i've got a basic order entry d-base w/ a form for adding products, etc.

can anyone help me w/ inventory control?

i want to be able to not only enter a new product but also enter the number of units. then once a sale is made on a given item it subtracts the number
of units sold from the inventory. is this a big task.

help

thank you,

//frank

Nov 12 '05 #3

P: n/a
the DSum option looks like what i might get away with.

in my orders form i have a subform for product selection and quantity to be
purchased. how do i format DSum to subtract the quantity sold from the
UnitsInStock?

i'm going to setup my tblProducts, tblAcq, tblAcqDetails as described in
your helpful link.

thank you,
//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Yes, this is a big question.
There is no one-size-fits all solution, but to set you off on a useful path, see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbr...Inventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:FL*********************@news04.bloor.is.net.c able.rogers.com...
i've got a basic order entry d-base w/ a form for adding products, etc.

can anyone help me w/ inventory control?

i want to be able to not only enter a new product but also enter the

number
of units. then once a sale is made on a given item it subtracts the number of units sold from the inventory. is this a big task.


Nov 12 '05 #4

P: n/a
The actual DSum() expression will depend on your table structure.
The Control Source of the text box will look something like this:
=DSum("Quantity", "SomeTable", "ProductID = " & Nz([ProductID], 0))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:Vc*********************@news01.bloor.is.net.c able.rogers.com...
the DSum option looks like what i might get away with.

in my orders form i have a subform for product selection and quantity to be purchased. how do i format DSum to subtract the quantity sold from the
UnitsInStock?

i'm going to setup my tblProducts, tblAcq, tblAcqDetails as described in
your helpful link.

thank you,
//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Yes, this is a big question.
There is no one-size-fits all solution, but to set you off on a useful

path,
see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbr...Inventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:FL*********************@news04.bloor.is.net.c able.rogers.com...
i've got a basic order entry d-base w/ a form for adding products, etc.
can anyone help me w/ inventory control?

i want to be able to not only enter a new product but also enter the

number
of units. then once a sale is made on a given item it subtracts the number of units sold from the inventory. is this a big task.



Nov 12 '05 #5

P: n/a
let's say the table structure is identicle to the one in your link.

thank you for your generous help.

//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
The actual DSum() expression will depend on your table structure.
The Control Source of the text box will look something like this:
=DSum("Quantity", "SomeTable", "ProductID = " & Nz([ProductID], 0))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:Vc*********************@news01.bloor.is.net.c able.rogers.com...
the DSum option looks like what i might get away with.

in my orders form i have a subform for product selection and quantity to

be
purchased. how do i format DSum to subtract the quantity sold from the
UnitsInStock?

i'm going to setup my tblProducts, tblAcq, tblAcqDetails as described in
your helpful link.

thank you,
//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Yes, this is a big question.
There is no one-size-fits all solution, but to set you off on a useful

path,
see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbr...Inventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:FL*********************@news04.bloor.is.net.c able.rogers.com...
> i've got a basic order entry d-base w/ a form for adding products, etc. >
> can anyone help me w/ inventory control?
>
> i want to be able to not only enter a new product but also enter the
number
> of units. then once a sale is made on a given item it subtracts the

number
> of units sold from the inventory. is this a big task.



Nov 12 '05 #6

P: n/a
Then use the function supplied on the web page.
DSum() would be too slow, complicated and cumbersome for that stucture.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:rt**********************@news04.bloor.is.net. cable.rogers.com...
let's say the table structure is identicle to the one in your link.

thank you for your generous help.

//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
The actual DSum() expression will depend on your table structure.
The Control Source of the text box will look something like this:
=DSum("Quantity", "SomeTable", "ProductID = " & Nz([ProductID], 0))

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:Vc*********************@news01.bloor.is.net.c able.rogers.com...
the DSum option looks like what i might get away with.

in my orders form i have a subform for product selection and quantity to
be
purchased. how do i format DSum to subtract the quantity sold from the
UnitsInStock?

i'm going to setup my tblProducts, tblAcq, tblAcqDetails as described

in your helpful link.

thank you,
//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
> Yes, this is a big question.
> There is no one-size-fits all solution, but to set you off on a useful path,
> see:
> Inventory Control - Quantity On Hand
> at:
> http://members.iinet.net.au/~allenbr...Inventory.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Frank Ruffolo" <fr******@rogers.com> wrote in message
> news:FL*********************@news04.bloor.is.net.c able.rogers.com...
> > i've got a basic order entry d-base w/ a form for adding products,

etc.
> >
> > can anyone help me w/ inventory control?
> >
> > i want to be able to not only enter a new product but also enter the > number
> > of units. then once a sale is made on a given item it subtracts the number
> > of units sold from the inventory. is this a big task.
>
>



Nov 12 '05 #7

P: n/a
where is the code inserted?

i don't know quite how to set up the form to use this code.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Then use the function supplied on the web page.
DSum() would be too slow, complicated and cumbersome for that stucture.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:rt**********************@news04.bloor.is.net. cable.rogers.com...
let's say the table structure is identicle to the one in your link.

thank you for your generous help.

//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
The actual DSum() expression will depend on your table structure.
The Control Source of the text box will look something like this:
=DSum("Quantity", "SomeTable", "ProductID = " & Nz([ProductID], 0))

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:Vc*********************@news01.bloor.is.net.c able.rogers.com...
> the DSum option looks like what i might get away with.
>
> in my orders form i have a subform for product selection and quantity
to
be
> purchased. how do i format DSum to subtract the quantity sold from
the > UnitsInStock?
>
> i'm going to setup my tblProducts, tblAcq, tblAcqDetails as described
in > your helpful link.
>
> thank you,
> //frank
>
>
>
> "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
> news:3f**********************@freenews.iinet.net.a u...
> > Yes, this is a big question.
> > There is no one-size-fits all solution, but to set you off on a useful > path,
> > see:
> > Inventory Control - Quantity On Hand
> > at:
> > http://members.iinet.net.au/~allenbr...Inventory.html
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "Frank Ruffolo" <fr******@rogers.com> wrote in message
> >
news:FL*********************@news04.bloor.is.net.c able.rogers.com... > > > i've got a basic order entry d-base w/ a form for adding products, etc.
> > >
> > > can anyone help me w/ inventory control?
> > >
> > > i want to be able to not only enter a new product but also enter

the > > number
> > > of units. then once a sale is made on a given item it subtracts the > number
> > > of units sold from the inventory. is this a big task.
> >
> >
>
>



Nov 12 '05 #8

P: n/a
Okay.

1. Choose the Module tab of the Database Window.

2. Click New. Access opens a code window.

3. Beneath the "Option" statement(s), paste in the function (everything from
"Function OnHand( ..." to "End Function").

4. If you are using Access 2000 or 2002, choose References from the Tools
menu and check the box beside:
Microsoft DAO 3.6 Library

5. Choose Compile from the Debug menu, to ensure Access has understood
everything.

6. Save the module with a name such as Module1.

You can now use this function like any of the built-in ones.
For example, if you have a form that contains a ProductID text box, you
could add another text box and set its Control Source to:
=OnHand([ProductID])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:u9*********************@news04.bloor.is.net.c able.rogers.com...
where is the code inserted?

i don't know quite how to set up the form to use this code.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Then use the function supplied on the web page.
DSum() would be too slow, complicated and cumbersome for that stucture.

"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:rt**********************@news04.bloor.is.net. cable.rogers.com...
let's say the table structure is identicle to the one in your link.

thank you for your generous help.

//frank

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
> The actual DSum() expression will depend on your table structure.
> The Control Source of the text box will look something like this:
> =DSum("Quantity", "SomeTable", "ProductID = " & Nz([ProductID], 0))
>
> "Frank Ruffolo" <fr******@rogers.com> wrote in message
> news:Vc*********************@news01.bloor.is.net.c able.rogers.com...
> > the DSum option looks like what i might get away with.
> >
> > in my orders form i have a subform for product selection and quantity
to
> be
> > purchased. how do i format DSum to subtract the quantity sold from the > > UnitsInStock?
> >
> > i'm going to setup my tblProducts, tblAcq, tblAcqDetails as described
in
> > your helpful link.
> >
> > thank you,
> > //frank
> >
> >
> >
> > "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
> > news:3f**********************@freenews.iinet.net.a u...
> > > Yes, this is a big question.
> > > There is no one-size-fits all solution, but to set you off on a

useful
> > path,
> > > see:
> > > Inventory Control - Quantity On Hand
> > > at:
> > > http://members.iinet.net.au/~allenbr...Inventory.html
> > >
> > > "Frank Ruffolo" <fr******@rogers.com> wrote in message
> > >

news:FL*********************@news04.bloor.is.net.c able.rogers.com... > > > > i've got a basic order entry d-base w/ a form for adding products, > etc.
> > > >
> > > > can anyone help me w/ inventory control?
> > > >
> > > > i want to be able to not only enter a new product but also

enter the
> > > number
> > > > of units. then once a sale is made on a given item it
subtracts the
> > number
> > > > of units sold from the inventory. is this a big task.

Nov 12 '05 #9

P: n/a
how generous of you to take the time to spell everything out.

you have laid out a great foundation on which i will learn and build - i
appreciate it.

//frank


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Okay.

1. Choose the Module tab of the Database Window.

2. Click New. Access opens a code window.

3. Beneath the "Option" statement(s), paste in the function (everything from "Function OnHand( ..." to "End Function").

4. If you are using Access 2000 or 2002, choose References from the Tools
menu and check the box beside:
Microsoft DAO 3.6 Library

5. Choose Compile from the Debug menu, to ensure Access has understood
everything.

6. Save the module with a name such as Module1.

You can now use this function like any of the built-in ones.
For example, if you have a form that contains a ProductID text box, you
could add another text box and set its Control Source to:
=OnHand([ProductID])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:u9*********************@news04.bloor.is.net.c able.rogers.com...
where is the code inserted?

i don't know quite how to set up the form to use this code.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Then use the function supplied on the web page.
DSum() would be too slow, complicated and cumbersome for that stucture.
"Frank Ruffolo" <fr******@rogers.com> wrote in message
news:rt**********************@news04.bloor.is.net. cable.rogers.com...
> let's say the table structure is identicle to the one in your link.
>
> thank you for your generous help.
>
> //frank
>
> "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
> news:3f**********************@freenews.iinet.net.a u...
> > The actual DSum() expression will depend on your table structure.
> > The Control Source of the text box will look something like this:
> > =DSum("Quantity", "SomeTable", "ProductID = " & Nz([ProductID], 0)) > >
> > "Frank Ruffolo" <fr******@rogers.com> wrote in message
> > news:Vc*********************@news01.bloor.is.net.c able.rogers.com... > > > the DSum option looks like what i might get away with.
> > >
> > > in my orders form i have a subform for product selection and

quantity
to
> > be
> > > purchased. how do i format DSum to subtract the quantity sold from
the
> > > UnitsInStock?
> > >
> > > i'm going to setup my tblProducts, tblAcq, tblAcqDetails as

described
in
> > > your helpful link.
> > >
> > > thank you,
> > > //frank
> > >
> > >
> > >
> > > "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
> > > news:3f**********************@freenews.iinet.net.a u...
> > > > Yes, this is a big question.
> > > > There is no one-size-fits all solution, but to set you off on
a useful
> > > path,
> > > > see:
> > > > Inventory Control - Quantity On Hand
> > > > at:
> > > > http://members.iinet.net.au/~allenbr...Inventory.html
> > > >
> > > > "Frank Ruffolo" <fr******@rogers.com> wrote in message
> > > >

news:FL*********************@news04.bloor.is.net.c able.rogers.com...
> > > > > i've got a basic order entry d-base w/ a form for adding

products,
> > etc.
> > > > >
> > > > > can anyone help me w/ inventory control?
> > > > >
> > > > > i want to be able to not only enter a new product but also

enter the
> > > > number
> > > > > of units. then once a sale is made on a given item it subtracts the
> > > number
> > > > > of units sold from the inventory. is this a big task.


Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.