I'm really stuck on how to design this application, so I thought I'd see if
anyone had any general ideas on how to proceed.  I'd say I'm an intermediate
level Access developer.
I volunteered to help my kid's school (a small non-profit) with a tremendous

hi guys and girls
I have 2 problems that are driving me crazy!
1/
I have a front end mde, and back end mdb, that I have packaged and

Is it possible to read the processor number of a PC from MS Access.

in access 97
on form open i have :
Me!frmContent.SourceObject = "frmabout"
Me!frmmenustart.SourceObject = "frmmenuaanmelden"    

       I'm trying to accomplish the following on a form on which i have
removed navigational buttons (I apologize in advance if this is too many
questions);
       The two easy ones are....

I have a Microsoft Access database on a web server that supports Access
databases.  All I want to do is have a couple of users be able to enter data
into the database via a browser.
This is not for a database driven web site, just for data entry.

Simple question re .findfirst
Is it true it does not use any indexes and really the best option with
a SQl backend (ignoring using Stored Procedures which at this stage
has not been funded) is to open recordsets with specific SQL to

I have notice one problem with it.
1) the aligment tools are not working (toolbar) maybe it's because i use
the Canadien French version of Access ?
Therefore the context menu is working very well.

Our company has just merged with another and as a result we've merged
our customer databases. The data was stored in each database slightly
different so there were some issues with the merge. Namely, one person
may be listed several times under different addresses or slightly

I have a table with rainfall logged on 15 minute intervals. I want to
make a report that shows only those DAYS when there is actually
rainfall, ie if a particular day has any rainfall at all I want to
print all the records for that day.

hi , i want to secure my Db.
I would like to set 3 groups with differents password.
And each of these password would result in having differents button
visible.

I've heard it's best to have a meaningless primary key (such as an
autonumber field) as opposed to a pk that contains volatile data.  This
sounds reasonable enough.  In fact, I think I'd need a good reason *not* to
use an autonumber field for a pk.  But how do I normalize with an ...

I have a series of 100 select queries (each represents a separate
business rule).
Each is run after a rule is tested.
OnClose of each query, I need to run a report with only the results of

I have a system that lets users input service events (much like
appointments at a Dr.'s office).  Oftentimes a particular person will
have 30 or 31 appointments in a month, as all events are consecutive.
All that is logged is days of service, not duration or anything.  For

I would like to run two queries together with the results together in
one report.
I would also want to extract only the duplicate records or have only
the duplicate record show up in the results.