Basic DB. Nothing fancy. Got two questions.
First, is there a way to automatically have the DB open to a new
record?
Second, is there a way to hide the Records listing that shows at the

Dear sir or madam,
Now I have a huge problem which need your help. I have
designed a database for stock control for my company.
After I've done it,I put it in the sever and share it to

I am fairly new to Access 2000 and am wondering if there
is a good online tutorial, or book.

How can I filter a database to leave only instances of the same entry
more than once in column b where column a is different?  That is,
where column a shows candidates and column b shows contributors, how
can I display only the rows where the same contributor made

I can't seem to master this, here goes:
I got years listed in 1 row as follows:
2005 2006 2007 2008 2009
0%     X       X      X    10%

Help!
I am trying to set up a database at home but i want to be
able to use in on my pc at work. The 2 computers are not
linked except by email and i dont seem to be able to save

hi,everyone. I have no idea about following signs,[ ]![ ]. The only thing I
know is that they are very important for making rules whatsoever. Could
anyone tell me what category they are belonging to, they are controls?, or
just signs. And more such signs exist? if positive, then ...

Could someone direct me to how to do a AS400 connection?
First tinmer doing this kind of thing.

I have some code that gives as a result the path of a file in my pc.
This code gives several  pathes separated with comas in a single string.
what I want to do is to send each path to a field in one table named xxx.
This code uses a for next to get the string, so I imagine if inside ...

I have a database setup with various tables and forms to store data for a
small autoelectrical business. I have Three tables for Job information.
JobCard, JobDetails and VehicleDetails. JobCard - one to many - JobDetails.
VehicleDetails - one to many - JobCard.

Ive got a query where the contents are sorted by 3 paramter queries.
The first is on the client type field. It can either be yes or no, or leave
it blank to get see all records. This is using Is Null
The Second and Third parameters are a between date and date. Ive also added

I have this problem (previously discussed in this NG) where a database
object keeps dissappearing. I have now converted all my database work to an
ADO type structure (previous was DAO) but it just changes the name of the
problem. Now I have my Connection object that keeps shutting ...

I have an MDB with my tables and then a seperate MDB with the forms,
modules, etc. I am using ADO for my database connections etc.
What I want to know is ... can I use the Dlookup function in my code? I
think not, as my tables don't actually exist in the MDB where I am coding in

the ingredients of question come as follows:
i have two a2k databases. we'll call them 'A' and 'B'. 'A'
has been around for a long time and has lots of records.
'A' currently requires its user to input a field, call

I have a main form and sub form in Form1.I set up the main
form in form header and sub form in form details. The
default view of my subform is datasheet. My subform is
bringing  all the history of a specific person according