Does anyone know how to create a Code that would print out a warning
report regarding the re-order quantity of products in inventory? I've
seen in the Northwinds database that there is a field in the Products
Table that shows the re-order quantity level. When a product quantity
gets too low, how can the user know to order more? I'm thinking either
a report that prints automatically or a pop-up warning message. Any
thoughts?

There are quite a few ways to do what you want BUT I personaly don't like
coming into the office to find reports have been printed over night or when
you are not expecting them so -
It would be a good idea to run the code each morning (when you have had at
least 10 cups of tea). You could put this behind the On-Load of you main
switchboard form. (it's just an idea)
Change the [DetailOfStockLevel] and [ReportName]


Private Sub Form_Load()
On Error GoTo Form_Load_Err
If (DetailsOfStockLevel < 10) Then
DoCmd.OpenReport "ReportName", acViewNormal, "", "", acNormal
End If
Form_Load_Exit:
Exit Sub
Form_Load_Err:
MsgBox Error$
Resume Form_Load_Exit
End Sub


--
Wayne
Manchester, England.



"Grassy7" wrote:

> Does anyone know how to create a Code that would print out a warning
> report regarding the re-order quantity of products in inventory? I've
> seen in the Northwinds database that there is a field in the Products
> Table that shows the re-order quantity level. When a product quantity
> gets too low, how can the user know to order more? I'm thinking either
> a report that prints automatically or a pop-up warning message. Any
> thoughts?
>
>

So forgot to mention to open a Pop up form use

DoCmd.OpenReport "PopupFormName", acViewNormal, "", "", acNormal


You need some way of telling when the stock levels are too low
[stockIn],[stockOut],[stockWarning] The last [ ] could be the number at which
the code is triggered - or better still just run this in the base query of
the form



--
Wayne
Manchester, England.



"Wayne-I-M" wrote:

> There are quite a few ways to do what you want BUT I personaly don't like
> coming into the office to find reports have been printed over night or when
> you are not expecting them so -
> It would be a good idea to run the code each morning (when you have had at
> least 10 cups of tea). You could put this behind the On-Load of you main
> switchboard form. (it's just an idea)
> Change the [DetailOfStockLevel] and [ReportName]
>
>
> Private Sub Form_Load()
> On Error GoTo Form_Load_Err
> If (DetailsOfStockLevel < 10) Then
> DoCmd.OpenReport "ReportName", acViewNormal, "", "", acNormal
> End If
> Form_Load_Exit:
> Exit Sub
> Form_Load_Err:
> MsgBox Error$
> Resume Form_Load_Exit
> End Sub
>
>
> --
> Wayne
> Manchester, England.
>
>
>
> "Grassy7" wrote:
>
> > Does anyone know how to create a Code that would print out a warning
> > report regarding the re-order quantity of products in inventory? I've
> > seen in the Northwinds database that there is a field in the Products
> > Table that shows the re-order quantity level. When a product quantity
> > gets too low, how can the user know to order more? I'm thinking either
> > a report that prints automatically or a pop-up warning message. Any
> > thoughts?
> >
> >