Is there a way to create an autonumber by year, month,
day, then sequential number for that day? Something like
YYYYMMDD###
I'm wanting to "try" and build a database to login lab

I was wondering what is the best way to clean and repair databases tables
that may have been corrupted.  The tables are linked and compact and repair
was unsuccessful on some of the tables.  Here is my plan:
1. Re-establish the links

I have an Access DB that grows as the users use it. It
starts out at 8000 kb and then grows to 111,000kb by the
afternoon. I compact and repair, but I do not understand
what is causing this. Please help!

I have an application that does updating and reporting.
When the user selects his name, a subset of his records
are captured. My question is this: Do those records reside
on each PC or do they stay on the network drive?

I need to be able to italicize individual words in a memo
field for occasional export and publication.  I would
like to be able to do this without linking to objects
outside access or using html-like coding.  Any advice? pk

I wish to record all my paper files -- simple, easy to use -- in Excel or
Access

I am having trouble with the design of my database. I am
also having a problem attaching my dbase file i'm sorry
but you cant look at it! Anyway .... my problem is this:
when I do a query or form it wont allow me to change

Ok, well, I've been reading a few threads about Primary Keys, and the use of
natural vs. surrogate keys. Sadly, a little learning is a dangerous thing,
and I've realized, (yet again.. will it never end!<groan>), that I've got a
problem with the design of my tables. When I created ...

Can anyone tell me why suddenly numeric fields in a very simple database have
started rounding up & rounding down - ie I enter 4.25 and it displays 4.00,
1.75 displays as 2.00.  I tried every combination of decimal places, format
etc but nothing seems to stop it.  I've never come ...

Hi all, I haven't used access for a while and was wondering how you append
data to existing data in that field.
I'm using web forms to enter data into a database, so I want info entered
via the web form to be added to the existing data in it's field in the data

I have built a database using social security # as the primary key. Is there
a way for me to simply enter the ss # of an existing record to go to that
record ? I am using Access 2003.

I have created a database with switchboards.  I navigate the database by
clicking buttons that lead to other switchboards until I get to the
form/query that I need.  The problem is that I cannot put more than 8 buttons
on my main switchboard.  I could create forms that will ...

I have a small problem in that in my database, some fields
are the same. I.E.
The Chief Exec company address, is the same as the
company. What would be nice would be to forward the

I am creating a purchase order Database and am hoping to
use autonumber with the prefix "STA-04".  Is this
possible, and if so, how?

Is there an easy way to have a field default to the data that was entered in the same field of the previous record?? Thanks