Re: Before it gets too deep !!

Yes they are on a network, so your solution makes a lot of sense. I also like
your thought about using Outlook to send onscreen messages.
I will look at the barcoding part later, but this is very encouraging.
Thanks VERY much for your reply !

"PC Data***" wrote:

> Are the office and warehouse on a network? If so, they woule both be using
> the same database. The database file containing the tables would be
> installed on the server and both the warehouse and office would have a copy
> of the application file installed on their computer. A simple way for the
> office to communiucate that an order has been placed and for the warehouse
> to communicate that an order has been filled is to place this information on
> the opening screen of the database. Presumably both the office and warehouse
> use their computers for other tasks so they coul periodically check the
> database for new messages. Outlook has a feature where on-screen messages
> can be sent. This is an alternative whereby Access could be programmed to
> send a message through Outlook. Another alyernative is that Access could be
> programmed to send out emails about order status.
>
> Re Barcodes. This is an everyday task for Access. Open Access, go to reports
> and click New. You will see there a label wizard for creating just about any
> kind of label you might want. For the barcode part, this is just a matter of
> setting the font in the label report to a barcode font. Easy stuff for
> Access!
>
>
> --
> PC Data***
> Your Resource For Help With Access, Excel And Word Applications
> resource@xxxxxxxxxxxxxxx
> www.pcdata***.com
>
> If you can't get the help you need in the newsgroup, I can help you for a
> very reasonable fee. Over 1000 Access users have come to me for help.
> Need a month calendar or 7 day calendar? Need appointment scheduling? Need
> room reservations scheduling? Need employee work scheduling? Contact me!
>
>
>
> "James B" <JamesB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D5C23128-13DE-40F5-8CE2-595B6E1B39F9@xxxxxxxxxxxxxxxx
> > OK...you've got me thinking that I am on the right path. I do have Access
> > and
> > I am pretty familiar with Frontpage.
> > You seem very knowledgible about this so I am going to propose a couple
> > more
> > scenarios to you if you don't mind.
> > I have one person in the office entering orders, I have one person in the
> > warehouse filling the orders. Can Access somehow alert the person in the
> > warehouse that a new order has been entered and on the flip side send an
> > acknowledgement to the inside person that the order has been filled and
> > shipped, through something as simple as a screenprompt, etc..
> > And my final question, sorry if I am being a pest, I'd just like to know
> > if
> > certain things are possible, then I'll go off and figure out how to make
> > it
> > happen....say there is an order placed that requires 10 boxes or totes (we
> > ship parts to Daimler Chrysler in totes) to fill the order. Each box or
> > tote
> > has to have a unique barcode label printed and affixed to the box or tote.
> > Can Access do this simply by knowing the total qty of the order and the
> > amount of parts that one box or tote contains? I guess creating the
> > barcode
> > labels is my greatest concern with Access. Right now we use an antiquated
> > system based on the PICK OS, but it does do a very good job of automating
> > the
> > labeling process.
> > Anyway, I hope I am not wasting your time, just want to know what I am
> > getting into BEFORE I get into it.
> > Thanks again !!!
> >
> > "Pat Hartman(MVP)" wrote:
> >
> >> I would use Access. I find web applications flat, slow, and annoying.
> >> I
> >> don't like to use them. I have no interest in developing them. They
> >> remind
> >> me very much of my mainframe days. They may look prettier than my CICS
> >> screens for the 3270 but they work essentially the same way and with the
> >> same limitations. Only the client/server environment can give you a
> >> "rich"
> >> experience at this time.
> >>
> >> If you are not already an experienced developer with C# or any other
> >> language that you choose to use, you don't have a snowball's chance in
> >> Hell
> >> of getting an application up and running by yourself. However, Access is
> >> such a rich and forgiving development environment that many
> >> non-developers
> >> are able to develop workable applications.
> >>
> >> No software is the perfect tool for all tasks. You should choose the
> >> tool
> >> that works best for each task. Right now, Access is the tool for the
> >> basic
> >> application. I suggested FrontPage for the web parts, not because it is
> >> the
> >> best tool necessarily, but because it is a tool that you might already
> >> have
> >> and it doesn't take a PHD to get it working.
> >>
> >> "James B" <JamesB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:20DB927D-59A8-4AED-8AA2-E82F7B9D976F@xxxxxxxxxxxxxxxx
> >> > Thanks for your response ! In a perfect world what software would YOU
> >> > use
> >> > to
> >> > do a first rate job of accomplishing a rich, feature filled, inventory
> >> > system?
> >> >
> >> > "Pat Hartman(MVP)" wrote:
> >> >
> >> >> 1. Access can use any printer for which you have the correct windows
> >> >> drivers
> >> >> and fonts.
> >> >> 2. Access doesn't have very good web tools. As long as all you want
> >> >> is
> >> >> the
> >> >> ability to view data, something like FrontPage could be used to
> >> >> present
> >> >> Access data as a web page.
> >> >>
> >> >> "James B" <JamesB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> news:13EC6AF3-679E-42BC-9B72-2AABFF91E3D2@xxxxxxxxxxxxxxxx
> >> >> >I am wanting to build a warehouse inventory system and would like to
> >> >> >use
> >> >> > Access since we already own it. I would like to know if someone can
> >> >> > tell
> >> >> > me
> >> >> > if Access is capable of doing a couple of things before I start.
> >> >> > 1. Can Access create / output barcode labels to a thermal printer
> >> >> > such
> >> >> > as
> >> >> > an
> >> >> > Intermec 3400?
> >> >> > 2. Can the Access database somehow be converted / used as a webpage?
> >> >> > The
> >> >> > reason I would want to do this is to allow customers access to the
> >> >> > system
> >> >> > to
> >> >> > view their inventory levels, transaction details, etc.
> >> >> > Thanks in advance for any responses or suggestions !!!
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.