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 9 3963
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.
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
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.
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.
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.
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. > >
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. > > > > > >
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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: gregork |
last post by:
I have painstakingly created an excel 2000 workbook for the very complex
recipes I have to formulate. I have 2 sheets- 1 for configuring the recipe
and 1 that is like an inventory of all the raw...
|
by: Stella Pieters via AccessMonster.com |
last post by:
Let me start by saying that I'm a newbie in VBA.
I've created an application in access where the user enters the quantity of
the items sold in a form. I would like to have these records created...
|
by: royaltiger |
last post by:
I am trying to copy the inventory database in Building Access Applications
by John L Viescas but when i try to run the database i get an error in the
orders form when i click on the allocate...
|
by: zaidalin79 |
last post by:
I have a java class that goes for another week or so, and I am going to fail if I can't figure out this simple program. I can't get anything to compile to at least get a few points... Here are the...
|
by: south622 |
last post by:
I'm taking a beginning Java course and I'm stuck in week eight of a nine week course. If anyone could help me I would greatly appreciate it. This assignment was due yesterday and each day I go past...
|
by: xxplod |
last post by:
I am suppose to modify the Inventory Program so the application can handle multiple items. Use an array to store the items. The output should display the information one product at a time, including...
|
by: cblank |
last post by:
I need some help if someone could help me. I know everyone is asking for help in java. But for some reason I'm the same as everyone else when it comes to programming in java. I have an inventory...
|
by: pinkf24 |
last post by:
I cannot figure out how to add the following:
Modify the Inventory Program to include an Add button, a Delete button, and a Modify button on the GUI. These buttons should allow the user to perform...
|
by: jcato77 |
last post by:
I need help with a class project I'm working on, Below is my assignment and the code I have currently created.
Assignment:
Modify the Inventory Program by creating a subclass of the product class...
|
by: 100grand |
last post by:
Modify the Inventory Program to use a GUI. The GUI should display the information one
product at a time, including the item number, the name of the product, the number of
units in stock, the price...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |