Purchase Request

[Guest]

Hello,
I was trying to create a purchase request form with a work order autonumber
as the identifier. Need to find a solution to allow a user to login to a web
based database, fill out the purchase request and submit the form to either
an email address or another user within the database for approval. From the
approval side have a approval, disapproval, or a disapproval with some items
available. After the action is applied the requester would then see a status
of the purchase request number either on the database or via email. Thanks
in advance.

 

[Larry Linson]

I caution you that many accounting types do not like AutoNumbers as
identifiers that are shown to humans, because they may not, in fact, be
monotonically increasing, and there may, due to a number of conditions, have
gaps, small and large, in the sequence. A "roll-your-own" numbering method
based on the DMAX built-in domain aggregate function has worked well for
some.

The only web-based solution that you can implement in Access are Data Access
Pages (DAP), which are limited, were not an overwhelming success, and for
which neither new development nor maintenance will be supported in Access
2007 (although it will run existing DAPs). I would not suggest new
development using DAP in Access.

Front Page will not be part of the next release either, and it used to be my
suggested "start point." You can use ActiveX Server Pages, .asp, if you are
using an older version of Visual Studio, or you can use the newer ASP.NET if
you have one of the two or three most recent Visual Studio releases.

There are also various other programming environments, and other databases,
that you can use online.

Larry Linson
Microsoft Access MVP