Subject:  Re: [access] RE: Warehouse Management System

Hello Steve,
   I've converted excel sheets into Access databases for several warehouses
 type database.
Here are some pointers.

1. Analyze the excel data first, then come up with a plan to Normalize 
data using tables.  Reducing multiple entries or duplications of effort. 
Example all the parts can be in a Parts Table.
2. Consider automating procedures to reduce redundancy and improve on 
accuracy. Example introducing bar coding.
3. Provide reporting analysis (cost, usage, capacity, etc...).
4. Provide search capability (Search for Part to find Isle, Bin, or slot 
location).
5. Using Access 2000 you have the ability to publish your form or reports 
using a web browser (ASP).

Good luck,


Thanks,

Derrick Flores
66318

>>> "Steven Van Aken" <svanaken@m...> 03/21 3:22 PM >>>
TXS Richard for yr answer.  Well, the inventory of our warehouse is 
kept
in a flat excel sheet now and I'd like to make it more user-friendly 
and
of course all advantages of a well-designed intelligent database could 
be
very convenient.  The only developer mean I have is Access2000 Pro.
Can you help or do you have interesting tips?

Steven

> Strange you should phrase it that way.

My main role in life seems to be the writing, maintaining and updating of
WMS - my access 2000 database.

What are you looking to do?

Regards

Richard Gibson
IT Manager
Walkerpack Ltd
01604 760529

-----Original Message-----
From: Steven Van Aken [mailto:svanaken@m...]
Sent: 21 March 2002 13:15
To: Access
Subject: [access] Warehouse Management System


Does anyone has experience in building Warehouse Management Systems in
Access 2000 Pro?

Subject:  Re: [access] Tool Box

Kenneth,
you can use the form timer to change the format of an object

Option Compare Database
Public bln As Boolean
Option Explicit

Private Sub Form_Timer()
If bln =3D True Then
    Me.Box0.BackColor =3D 10040115
    bln =3D False
Else
    Me.Box0.BackColor =3D 65535
    bln =3D True
End If
End Sub

Try that,

Thanks,

Derrick Flores
66318

>>> "KennethMungwira" <KennethMungwira@Y...> 03/25 6:22 PM >>>
Dear Sir or Madam,

does anyone know if the ToolBox has a command for a flashing 'Dot'. I 
have
a map and I would like to place a flashing dot in the county that has 
been
choosen.

thank you