Depends on what you wish to learn.  If you are a programmer at all, you would
probably prefer ACCESS but there is a learning curve. Once you go through it,
it's
a very rapid development tool and rather reliable for pretty complex databases
(can't speak for AC 2000 - have not worked with it yet but Ac 97 is pretty
stable).  Has cool user interface tools for example a very nice 'ad hoc' report
generator which clients always seem to want and also which can (assuming you
have a
power user or two) relieve you from the boredom and agony of formatting endless
reports. :)

If you are not a programmer, you'd better stick with Filemaker Pro unless you
wish
a new adventure! :)

If you will need multiple tables, you probably need to go with ACCESS.

I don't like doing databases in Excel.  It's seems very limiting.  Also, most
spreadsheets are memory based which really limits you as to size.  Also, the
larger
the table becomes, the slower it gets in moving around in it.

Sue



> Message: 2
>    Date: Thu, 16 Mar 2000 04:02:43 EST
>    From: teeseebee@...
> Subject: The BIG choice
>
>             I need to create a database to track my small business inventory.
>   I am considering using:
>
>     (1) MS Excel97 (Pros: I already own it; I'm somewhat familiar with it; I
> succeeded in creating a 15-sheet database/spreadsheet and it actually works.
> Cons: Its scope and abilities are limited).
>
>     (2) MS Access 97/2000 -- not sure which I can get  (Pros: a REAL database
> prog.; bigger and more capable/versatile than Excel.  Cons: I don't own it; I
> don't know anything about it; it sounds really hard to learn).
>
>     (3) FileMakerPro  (Pros: friends tell me it's able to do absolutely
> anything and that it's vastly customizable.  Cons: I don't own it; costs more
> than Access (?); you really have to know what you're doing to set it up.
>
>                 The main features I want to see in whatever program I get are:
>
>     (A) Able to insert mini images (.jpg's from my hard drive) into comment
> boxes attached to cells (tried but failed to get Excel to do this).  Or at
> least insert them completely inside cells, hopefully right alongside text.
>
>     (B) Able to get a sum of the numeric values in all cells with a "Y" in
> the Sold field,  a 99 in the Date field, across all 15 sheets/pages in the
> database (all formatted the same).  I can do this with Excel (AutoFilter),
> but it has to be done on each sheet separately.  Would also like to be able
> to do a keyword Find across sheets.
>
>     (C) [this is the most important feature I need] Able to enter code
> numbers (item identifying numbers), 75 to a hundred at a time, delimited by
> commas or whatever, into a box, and then tell the program to place a "Y" in
> the Sold column for each item so listed.  The only way I know of to do this
> in Excel would be to run a Find for every single code number and then change
> the "N" to a "Y", and I know it won't search across sheets.
>
>             Any input would be greatly appreciated.  I don't want to begin
> using a particular database and learn later that another program would work
> better for my needs.  Want to start with one program and stay with it.
> Thanks very much.
>
>
_______________________________________________________________________________
>
_______________________________________________________________________________

--

Sue Widemark
http://members.aol.com/swidema

I need to create a database to track my small business inventory.
   I am considering using:

     (1) MS Excel97 (Pros: I already own it; I'm somewhat familiar with it; I
succeeded in creating a 15-sheet database/spreadsheet and it actually works.
Cons: Its scope and abilities are limited).

     (2) MS Access 97/2000 -- not sure which I can get  (Pros: a REAL database
prog.; bigger and more capable/versatile than Excel.  Cons: I don't own it; I
don't know anything about it; it sounds really hard to learn).

     (3) FileMakerPro  (Pros: friends tell me it's able to do absolutely
anything and that it's vastly customizable.  Cons: I don't own it; costs more
than Access (?); you really have to know what you're doing to set it up.

                 The main features I want to see in whatever program I get are:

     (A) Able to insert mini images (.jpg's from my hard drive) into comment
boxes attached to cells (tried but failed to get Excel to do this).  Or at
least insert them completely inside cells, hopefully right alongside text.

     (B) Able to get a sum of the numeric values in all cells with a "Y" in
the Sold field,  a 99 in the Date field, across all 15 sheets/pages in the
database (all formatted the same).  I can do this with Excel (AutoFilter),
but it has to be done on each sheet separately.  Would also like to be able
to do a keyword Find across sheets.

     (C) [this is the most important feature I need] Able to enter code
numbers (item identifying numbers), 75 to a hundred at a time, delimited by
commas or whatever, into a box, and then tell the program to place a "Y" in
the Sold column for each item so listed.  The only way I know of to do this
in Excel would be to run a Find for every single code number and then change
the "N" to a "Y", and I know it won't search across sheets.

             Any input would be greatly appreciated.  I don't want to begin
using a particular database and learn later that another program would work
better for my needs.  Want to start with one program and stay with it.
Thanks very much.

I finally succeeded in creating a 15-sheet spreadsheet/database
in MS Excel97, but I am already noticing its limitations for tracking of
inventory and sales.

             Today, I purchased an upgrade for Access2000.  The clerk assured
me I could install this software even though I do not have Office2000, nor do
I have any version of Access (have only the Small Business Edition of
Office97).  Before I open the package, does anyone know if this upgrade to
Access2000 can be installed onto Office97 Small Business?            Thanks.

Hi,

This is a form letter sent out to all email lists owned by me.
It's purpose is to keep this list and others from being deleted
due to inactivity.

In order to keep this email list in active status and not have
it removed from Onelist's database it must be used periodically.
I and Onelist understand that this list may be seasonal and only
pass traffic during certain times of the year.

This message is time to be sent twice monthly. If this has been
the only message you received during the month please help by
starting a new discussion with the group. Please don't go
overboard with "test messages".

We must keep this list active so it is there for us when we
really need it.

If this list is already active please ignor this message.

Thanks, any questions please post them.
The List owner

Jay,

Put your calculation code into the AfterUpdate event of the fields Rate and
Hours and it should work.

Kind regards,
Werner

Jay Beckham <tanglewoodsoftware@...> wrote:

> ---------------------------------------------
> Attachment: 
> MIME Type: multipart/alternative
> ---------------------------------------------
Hi

Please excuse the really novice question but
apparently I am missing some basic bit of knowledge or
can't see the forest for the trees.

First let's assume I have a table with, among other
fields, the following numeric fields:  hours, rate,
and pay.

I create a form with this table as the control source.
I place the three fields on the form. On the [rate]
field I have an after exit event which multiples rate
X hours and makes the result equal to pay. And of
course this doesn't work.  If I create another field
and make it's source equal to rate X hours, it will
display the correct result.

So My question is how to I get pay into the underlying
table without running an update query?  Can I do this
within the form?

I will certainly appreciate any help. I am certain
that I am missing some basic bit of knowledge about
Access.

Also I am using Access 2000 and 97.

Thanks

Jay Beckham
Berkeley Springs, WV
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



Werner De Kuyffer
IT Consulting en IT Services
Pastorijveld 26
2180 Ekeren
Tel: 0495/63.22.10
Fax: 03/544.71.57
HRA: 337121
BTW: 508410058

____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1

Hi

Please excuse the really novice question but
apparently I am missing some basic bit of knowledge or
can't see the forest for the trees.

First let's assume I have a table with, among other
fields, the following numeric fields:  hours, rate,
and pay.

I create a form with this table as the control source.
I place the three fields on the form. On the [rate]
field I have an after exit event which multiples rate
X hours and makes the result equal to pay. And of
course this doesn't work.  If I create another field
and make it's source equal to rate X hours, it will
display the correct result.

So My question is how to I get pay into the underlying
table without running an update query?  Can I do this
within the form?

I will certainly appreciate any help. I am certain
that I am missing some basic bit of knowledge about
Access.

Also I am using Access 2000 and 97.

Thanks

Jay Beckham
Berkeley Springs, WV
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Hi,

This is a form letter sent out to all email lists owned by me.
It's purpose is to keep this list and others from being deleted
due to inactivity.

In order to keep this email list in active status and not have
it removed from Onelist's database it must be used periodically.
I and Onelist understand that this list may be seasonal and only
pass traffic during certain times of the year.

This message is time to be sent twice monthly. If this has been
the only message you received during the month please help by
starting a new discussion with the group. Please don't go
overboard with "test messages".

We must keep this list active so it is there for us when we
really need it.

If this list is already active please ignor this message.

Thanks, any questions please post them.
The List owner

Hi I have set the auto mail feature to send that form  twice every month. I
don't
think it will cause a pile up in anyones mailbox at that rate. As soon as I get
all my lists out of danger from the onelist delete catagory I might reduce it
down to monthly.

Fine business on the sending a hint or two but in my case with have 183 email
list that I own make it to hard to get attached to them all. I started this list
so it would be here when I needed it. I guess that's why we are all here.

There are 45 members here on the access list
85 on the ms_excel list
@5 on the procomm plus list
@40 on the power point list
50 on the PKunzip list
130 on the photoshop list
so on and so on

Matt List owner (LO)



Jerr wrote:

> From: Jerr <jerrito@...>
>
> Sue,
> I think is easier to move this group to:
> http://www.egroups.com/group/access-dev/
>
> this group has the advantage that the replies are also available by html and
> not only through e-mail. Besides their ideas can be shared with the ideas of
> this group, which will be more benefitial for everybody.
>
> Sue Widemark <gswidemark@...> wrote:
>
> > ---------------------------------------------
> >       Attachment:
> >       MIME Type: multipart/alternative
> > ---------------------------------------------
> Well, cute to print a form letter.  I do something less creative with my less
> active groups but perhaps more helpful like sending through a helpful hint or
> something?  (Not hinting or anything but...)
>
> Sue
>
> ms_access@onelist.com wrote:
>
> > --------------------------- ONElist Sponsor ----------------------------
> >
> > GET A NEXTCARD VISA, in 30 seconds.  Get rates as low as 2.9 percent
> > Intro or 9.9 percent Fixed APR and no hidden fees.  Apply NOW.
> > <a href=" http://clickme.onelist.com/ad/NextcardCreative4CI ">Click
> Here</a>
> >
> > ------------------------------------------------------------------------
> >
>
> Visita mi pagina http://jerr.ne3.net
> Ahora tambien puedes enviar tarjetas virtuales
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
>
> --------------------------- ONElist Sponsor ----------------------------
>
> GET A NEXTCARD VISA, in 30 seconds.  Get rates as low as 0.0 percent
> Intro or 9.9 percent Fixed APR and no hidden fees. Apply NOW.
> <a href=" http://clickme.onelist.com/ad/NextcardCreative5CI ">Click Here</a>
>
> ------------------------------------------------------------------------

Sue,
I think is easier to move this group to:
http://www.egroups.com/group/access-dev/

this group has the advantage that the replies are also available by html and
not only through e-mail. Besides their ideas can be shared with the ideas of
this group, which will be more benefitial for everybody.


Sue Widemark <gswidemark@...> wrote:

> ---------------------------------------------
> Attachment: 
> MIME Type: multipart/alternative
> ---------------------------------------------
Well, cute to print a form letter.  I do something less creative with my less
active groups but perhaps more helpful like sending through a helpful hint or
something?  (Not hinting or anything but...)

Sue

ms_access@onelist.com wrote:

> --------------------------- ONElist Sponsor ----------------------------
>
> GET A NEXTCARD VISA, in 30 seconds.  Get rates as low as 2.9 percent
> Intro or 9.9 percent Fixed APR and no hidden fees.  Apply NOW.
> <a href=" http://clickme.onelist.com/ad/NextcardCreative4CI ">Click
Here</a>
>
> ------------------------------------------------------------------------
>


Visita mi pagina http://jerr.ne3.net
Ahora tambien puedes enviar tarjetas virtuales

____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1

Well, cute to print a form letter.  I do something less creative with my less
active groups but perhaps more helpful like sending through a helpful hint or
something?  (Not hinting or anything but...)

Sue

ms_access@onelist.com wrote:

> --------------------------- ONElist Sponsor ----------------------------
>
> GET A NEXTCARD VISA, in 30 seconds.  Get rates as low as 2.9 percent
> Intro or 9.9 percent Fixed APR and no hidden fees.  Apply NOW.
> <a href=" http://clickme.onelist.com/ad/NextcardCreative4CI ">Click Here</a>
>
> ------------------------------------------------------------------------
>
> There is 1 message in this issue.
>
>  Topics in today's digest:
>
>       1. File: monthly.txt
>            From: ms_access-owner@onelist.com
>
>
_______________________________________________________________________________
>
_______________________________________________________________________________
>
> Message: 1
>    Date: 13 Feb 2000 08:43:04 -0000
>    From: ms_access-owner@onelist.com
> Subject: File: monthly.txt
>
> Hi,
>
> This is a form letter sent out to all email lists owned by me.
> It's purpose is to keep this list and others from being deleted
> due to inactivity.
>
> In order to keep this email list in active status and not have
> it removed from Onelist's database it must be used periodically.
> I and Onelist understand that this list may be seasonal and only
> pass traffic during certain times of the year.
>
> This message is time to be sent twice monthly. If this has been
> the only message you received during the month please help by
> starting a new discussion with the group. Please don't go
> overboard with "test messages".
>
> We must keep this list active so it is there for us when we
> really need it.
>
> If this list is already active please ignor this message.
>
> Thanks, any questions please post them.
> The List owner
>
>
_______________________________________________________________________________
>
_______________________________________________________________________________

--

Sue Widemark
http://www.users.uswest.net/~swidemark
alternate: http://suewidemark.freeservers.com

Hi,

This is a form letter sent out to all email lists owned by me.
It's purpose is to keep this list and others from being deleted
due to inactivity.

In order to keep this email list in active status and not have
it removed from Onelist's database it must be used periodically.
I and Onelist understand that this list may be seasonal and only
pass traffic during certain times of the year.

This message is time to be sent twice monthly. If this has been
the only message you received during the month please help by
starting a new discussion with the group. Please don't go
overboard with "test messages".

We must keep this list active so it is there for us when we
really need it.

If this list is already active please ignor this message.

Thanks, any questions please post them.
The List owner

Can anybody explain, what is going on w/ my Access 97?

I have spit DB: A.mdb - code, B.mdb - data. All tables from B.mdb linked
(attached) to A.mdb.
I need to repair B.mdb from code (from A.mdb).
Before now it wos working good - I opened A.mdb (B.mdb is still closed, because
I did not access any data from B.mdb), first function in Autoexec macro copied
B.mdb to local drive, repaired it, deleted old B.mdb and copied repaired B.mdb
to its place.
Today, I did not do anything w/ code, but when A.mdb begin to run, first
function cause error (somebody open B.mdb exlusevly) and I noteced B.ldb file
along w/ B.mdb.
Now, when first function begin to run - it automatically open B.mdb.

Again, I do not access any data from B.mdb at that time and it was working
yesterday.

If somebody know, please, help me.

Does anyone know the cure for this Word error message?  It happens when I try to
merge data from an Access query into a Word merge file using a button on a form.

I also get it when I go to the visual basic editor when I'm in Word.  It's a
non-lethal error in that I can just OK through the message and get to it.

It doesn't happen on anyone's workstation except mine - which is good because I
designed the form for other users.  But it still annoys me.

Please help!!

thanks

John

re: print function inside the database

What type of print function do you wish to create?
--

Sue Widemark
<mailto:gswidemark@...>
http://www.suewidemark.freeservers.com

At 08:09 AM 12/3/1999 +0000, you wrote:

>I have a database and would like to create a print
>function inside my database.
>Can anyone help?

I don't know exactly what you're attempting to do; if you want a
shareware/commercial tool to help, you might want to look here:

http://www.acc-technology.com/rrwiz.htm

There are also many ways to call the Print/Print Preview function, ie,
check Help under DoCmd, etc.

Hope this helps!

    --Brian



**************************************************
* BRIAN BATTLES               MIDDLETOWN, CT USA *
*     Microsoft Certified Professional (MCP)     *
*       MS Access / Visual Basic Developer       *
* brian@...        http://www.brianb.com/ *
* 860-347-9245 (home)    860-655-6456 (cellular) *
*   "If you can read this, thank a computer!"    *
**************************************************

Hi,
I have a database and would like to create a print
function inside my database.
Can anyone help?

Thanks.

I would use a combobox instead of a list box. They are more friendly to use.
Use the wizard to type the values you want.
After that turn on the LimitToList property of the combo box

Make sure that you use de RecordSource property of the form that you are
working on!

Private Sub Combo0_AfterUpdate()
     Dim strSQL As String
     'If the field is a text field
     strSQL = "SELECT tblTable.* FROM tblTable WHERE (((tblTable.Field0)= '"
& Combo0 & "'));"
     'Whereas if the field is numeric try this SQL
     strSQL = "SELECT tblTable.* FROM tblTable WHERE (((tblTable.Field0)= "
& Combo0 & "));"

     forms("FormName").RecordSource = strSQL

End Sub



At 11:56 AM 09/21/1999 -0700, you wrote:
>From: Sue Widemark <gswidemark@...>
>
>
>> My question is this:  How do you create a pop up dialog box that prompts
the user
>> for a set of skill codes, and, when a button is clicked in the box,
applies the
>> filter to the database.
>
>One way you could do it, is make a screen with a list box
>(containing numbers which the user could pick) and another
>list box which you fill from the first list box (this one
>would contain the picked numbers).  Then, filter from the
>results in that second list box.  The book, ACCESS 97: Macro
>and VBA Handbook by Susanne Novalis has an example, I
>believe.
>--
>
>Sue Widemark
><mailto:gswidemark@...>
>http://Sue-Widemark.webjump.com
>
>>

> My question is this:  How do you create a pop up dialog box that prompts the
user
> for a set of skill codes, and, when a button is clicked in the box, applies
the
> filter to the database.

One way you could do it, is make a screen with a list box
(containing numbers which the user could pick) and another
list box which you fill from the first list box (this one
would contain the picked numbers).  Then, filter from the
results in that second list box.  The book, ACCESS 97: Macro
and VBA Handbook by Susanne Novalis has an example, I
believe.
--

Sue Widemark
<mailto:gswidemark@...>
http://Sue-Widemark.webjump.com

Hello everyone! I am fairly new to Access so I am probably just missing a
simple step somewhere. I have tried searching the MS KB but have had no luck.

In my database I have a field that allows a person to input 4 digit numbers that
represent job skill codes (ie 1001, 1002, 1003).  The person can enter up to
10 codes.  This person should now be able to search the database for the
candidate that matches a certain set of skills (ie 1001, 1003). I can get the
filter to work properly, but only if you use the 'Filter by Form' and 'Apply
Filter' buttons on the toolbar, or go in a modify the query each time.  I want
to keep it as simple as possible for the end user.

My question is this:  How do you create a pop up dialog box that prompts the
user
for a set of skill codes, and, when a button is clicked in the box, applies the
filter to the database.

Any help or suggestions would be greatly appreciated

Thanx Olaf

I may be missing something but it seems to me that it would be better
to keep all of the data in one table and not bother with the
individual, single location tables.  You can add a field to your
master table to identify which location the record belongs to and just
filter and/or query whenever you need to look at the one location.

I realize this doesn't answer your question directly but I just had to
suggest this.

jt

>>> <Dean.Korson@...> 06/03 10:38 PM >>>
From: Dean.Korson@...



I am working on a inventory database that has one main database and I
want to
link it to many other databases. For example: the main database has
all of the
locations and all of the other databases are single locations. I
created these
other databases by copying the original database and deleting the
information
that does not go with the location I am creating the database for.
When I link
the database there is no problems, but when I go to put information in
one table
it does not update in the table that is linked to. If anyone can help
it would
be great.

Thanks!!



------------------------------------------------------------------------
How has ONElist changed your life?
http://www.onelist.com
Share your story with us at http://www.onelist.com

I am working on a inventory database that has one main database and I want to
link it to many other databases. For example: the main database has all of the
locations and all of the other databases are single locations. I created these
other databases by copying the original database and deleting the information
that does not go with the location I am creating the database for. When I link
the database there is no problems, but when I go to put information in one table
it does not update in the table that is linked to. If anyone can help it would
be great.

Thanks!!

It still takes lots of practice.  Good luck.
-----Original Message-----
From: N9NPP <n9npp@...>
To: ms_access@onelist.com <ms_access@onelist.com>
Date: Tuesday, April 06, 1999 11:35 PM
Subject: [ms_access] couldn't hold back


>From: N9NPP <n9npp@...>
>
>hi everyone,
>
>i couldn't hold back any longer.....i went and bought access 97 for
>DUMMIES!!!
>
>
>matt
>
>
>------------------------------------------------------------------------
>Have you visited the new ONElist home page lately?
>http://www.ONElist.com
>ONElist: The Leading e-mail list and community service on the Internet!
>

hi everyone,

i couldn't hold back any longer.....i went and bought access 97 for
DUMMIES!!!


matt

Hi,

I need some help with creating a database which will help me calculate
percentages based on a user's input. For eg.
Input for best score :
Input for today's score :
Percentage achieved :
Would this be able to be created with access?? I'm using Access 97.

Would appreciate if any help can be given Thanks.

Rochelle

Hi,

Just like to find out whether there's any foxpro programmers on the list by
chance, and wonder if any of you could help to enlighten me on the following:

1. What is one-to-many relationship
2. What is many-to-many relationship
3. What are relational databases

I hope that I can get some answers about these questions cos I'm really
confused about their differences.
Thank you.

Kaye

Hi,

I would like some help in creating a database program by using MS Access, which
can help a asthma patient keep track of his medications and also to monitor
his peak flow readings.
I would very much appreciate any help I could get from members of this list.
Thank you.

Newbie

Thanks!
-----Original Message-----
From: Dale K. Nargang <sco@...>
To: ms_access@onelist.com <ms_access@onelist.com>
Date: Wednesday, January 13, 1999 3:15 PM
Subject: [ms_access] Re: General help, please...


>From: "Dale K. Nargang" <sco@...>
>
>Try Sam's "Teach Yourself Access 97 in 21 Days"  www.samspublishing.com  or
>try "Get going with Access 95/97"  www.soeasyonline.com.
>
>-----Original Message-----
>From: Shel <shel@...>
>To: ms_access@onelist.com <ms_access@onelist.com>
>Date: January 13, 1999 1:15 PM
>Subject: [ms_access] General help, please...
>
>
>>From: "Shel" <shel@...>
>>
>>Hi!  I've tried to use Access 97 a number of times...I have lots of other
>>database experience under my belt...and even have 2 books on Access.  But
>>why does it seem so confusing, when trying to set up a relational
database?
>>Is there a simple step-by-step guide writen anywhere, in any book?
>>
>>Thanks!
>>
>>
>>:) shel
>>
>>
>>------------------------------------------------------------------------
>>To unsubscribe from this mailing list, or to change your subscription
>>to digest, go to the ONElist web site, at http://www.onelist.com and
>>select the User Center link from the menu bar on the left.
>
>
>------------------------------------------------------------------------
>To unsubscribe from this mailing list, or to change your subscription
>to digest, go to the ONElist web site, at http://www.onelist.com and
>select the User Center link from the menu bar on the left.

Try Sam's "Teach Yourself Access 97 in 21 Days"  www.samspublishing.com  or
try "Get going with Access 95/97"  www.soeasyonline.com.

-----Original Message-----
From: Shel <shel@...>
To: ms_access@onelist.com <ms_access@onelist.com>
Date: January 13, 1999 1:15 PM
Subject: [ms_access] General help, please...


>From: "Shel" <shel@...>
>
>Hi!  I've tried to use Access 97 a number of times...I have lots of other
>database experience under my belt...and even have 2 books on Access.  But
>why does it seem so confusing, when trying to set up a relational database?
>Is there a simple step-by-step guide writen anywhere, in any book?
>
>Thanks!
>
>
>:) shel
>
>
>------------------------------------------------------------------------
>To unsubscribe from this mailing list, or to change your subscription
>to digest, go to the ONElist web site, at http://www.onelist.com and
>select the User Center link from the menu bar on the left.

Hi!  I've tried to use Access 97 a number of times...I have lots of other
database experience under my belt...and even have 2 books on Access.  But
why does it seem so confusing, when trying to set up a relational database?
Is there a simple step-by-step guide writen anywhere, in any book?

Thanks!


:) shel