Automatic Reports

[Grassy7]

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?

 

[Wayne-I-M]

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-I-M]

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.

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.

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?