INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Thanks! Awesome group. I put out a simple question in the access/vba forum that I couldn't find answered on technet or anywhere else on the web and it was answered the same day!!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Modules (VBA Coding) Forum

Hello All, I was wondering if th

Read More Threads Like This One

DarkOne72 (TechnicalUser)

8 Aug 12 7:49

Hello All,

I was wondering if this would be possible to have in a database.
What I have is a quantity field for inventory and a reorder level; what I want to happen is automatically email me if any given item is equal to or less than the reorder level.
The trick, I would guess, is to make it where it is always checking the table and the quantity levels.
Is this possible, if so how could I accomplish this?

Thanks.

Andrzejek (Programmer)

8 Aug 12 8:33

You may want to investigate triggers in Access

Have fun.

---- Andy

DarkOne72 (TechnicalUser)

8 Aug 12 11:13

Thank you for the reply,

I found out where you can do it with data macros for a table but the atcual quantity in stock is an if statement in a query.
I can't seem to get it to work porperly with queries.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Access Modules (VBA Coding)