Re: Before it gets too deep !!

When you get to the point of looking at barcoding, check into the Code39
barcode. It's the simplest to use and if you google you'll find many places
to download it for free.

--
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:B28BBE13-AA6A-4322-A99E-A15ED4025185@xxxxxxxxxxxxxxxx
> 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 !!!
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


.

Loading