Everytime I add a record my Database size goes up 20kb is that a lot?
Also a form I had loaded fast, but as I add records it keeps getting
slower, any way to fix this?
Thanks

When I was experimenting with pictures, I put a fleur de lis on a page.  Now
every time I try to get a fresh new page that picture shows up.  I have tried
everything I know to permanently get rid of it so it won't show up everytime
I want a new sheet but have yet to discover what ...

I am working on a clinical database requiring national harvest and structure
dictated by national entity.  They require fields which have a parent-child
relationship to be part of the same table.  Is it possible to set up a
form/subform for the parent-child fields if the fields ...

Hi,
is there anything like 'if' or 'case' in jet SQL
thanx
alek_mil

In Access:
I clicked tools\startup and changed (un-checked) a box to try and get just my
form to open with out the database window..
Now the only options I have up top are File, Window, and help...

Is it possible to convert time that are in long integer format eg.
92003 and 153504 to time format hh:mm:ss AM/PM. The problem is that the
data in the field are not the same length. Some of the time are 5
numbers and 6 numbers. The ones with 5 numbers has the 0 missing in

I am trying to discover average donations per participant at events we run.
Tables in the Query:
   BasicContactT    (Name, address, etc.)
   EventT                 (Date, Time, Location, Type)

I have a database with photos and reports (jpg).  I wanted the reports and
photos to be viewed on a form; however, an icon is displayed.  How do I
display the records and photos on the form?  What am I doing wrong?
I have four fields; Photo 1, Photo 2, Photo 3 and Report record.  ...

Can some one assist with deleting duplicate records based on lowest number.
If field F1 are equal then only keep the record with the highest value in
field F0.
This module works partially.  If there are more than 2 duplicates for the

I'm very new to access.  I have a company that has a data base for open
projects.  They print this out each week for a weekly meeting and it can be
about 50 or more pages.  In order to keep this down to a dull roar they
delete the records that contain closed projects.  I'm sure ...

Hello:  I am familiar with Min and Max.  What I want to do is to display the
most recent records from a table.  For example.  I have 3 accounts (A, B, C)
Each accounts has 4 records each..  I would like a query that would only
display the most recent record for A, B, & C.  So ...

I am trying to finish writing some simple program.
My problem is that when I try and change the arguement from SELECTION
CHANGE to CHANGE, it doesn't work. Can someone help?
Private Sub Worksheet_Change(ByVal Target As Range)

I am having a few problems.
First off, I do not want data to appear when I make a selection change,
but rather when I pick an item to appear automatically.
Whenever I try and use CHANGE rather than SELECTION CHANGE, this

Is it possible to delete a table on exiting a form or on exiting Access 2000
Thanks for any help

In my program form, after entering all informationand click save. I get "Name
not found in this collection". When remove the Data.mdb file and replace it
with a new blank Data.mdb file, it works perfact.
Can anyone help?