Need Web App to Search Inventory

[Guest]

I need some help in developing a web app that we can use on our company
intranet for doing simple inventory lookups.

I've got a single table of about 17,000 records. The fields are standard
inventory labels like product number, model, description, location, etc.

Ideally, I'd like to have a web app that allows searches using one or two
fields, and returns various bits of information from that record. Ex.: Enter
product number, and the app returns, description and location.

Simple idea, but my skills fall short of developing this. I know the basics
of Excel and Access, but I think this project is going to involve complex
forms and/or macros.... Something that I am weak with.

I would appreciate any help you may be able to provide. Thanks in advance!

-- John

 

[Arvin Meyer [MVP]]

If you plan on doing it on an intranet, you'll need something like an ASP
page to access the data in a browser. I think you'll find it much faster to
develop the app using Access forms on each workstation, and place the data
tables on the server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[PC Datasheet]

John,

If you want help with this, contact me.

 

[StopThisAdvertising]

John,

If you want help with this, contact me.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help.
(e-mail address removed)

--
To the OP:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R

 

[Guest]

Arno: The web link you provided is dead. I appreciate your intention.
Ideally, I'd like some advice or help in getting started, not to hire someone
to do it for me.

Thanks,

-- John

 

[Danny J. Lesandrini]

John:

I've posted this link before, and it's not exactly what you need, but
it might get you started. Check out the download with my article
at DBJ about converting an Access table to ASP web page ...

http://www.databasejournal.com/features/msaccess/article.php/3487741

 

[Arno R]

Arno: The web link you provided is dead. I appreciate your intention.

Link is not dead here at this moment...
It might be however that the link has been dead for a little while or so.
I don't see anything in particular in the stats, except that the website is visited again...

Arno R

 

[John Marshall, MVP]

John,

If you want help with this, contact me.

Stevie, still abusing these newsgroups? These newsgroups are for free help
not for solicitation.

John... Visio MVP