Newbi here....  I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number".  All the records do not have
the project number inserted as of yet.  Is there a simple means to insert a
project number in say 50 records at a time, another ...

I am using Access2003 and am trying to link an excel spreadsheet for use in a
drop down selector.  I have one column (acct#) which contains a lot of
numbers, but needs to be a text field (some entries say "TBD" or have
hyphenated numbers).  Access insists on keeping the column as ...

I am creating a new database that has assigned a file number, we have been
manually stamping these numbers on documents, now I would like access to
generate them, the number is a 6 digit number 59659, named Filed Number.  I
would like access to sequentially number newly enterted ...

I need to make my date fiel only allow the format to be YYYY-MM-DD HH:MM:SS
I also need the date field to be a text value
I have set the input mask to do this, but it still doesn't stop values to be
populated incorrectly from a query ie 2008-01-01 :23:59:9

I have the following in my query:
PART: Replace(Replace(Replace([bm_Data]![PART DESCRIPTION],",","*"),"'","ft.
")," " ","in.  ")
I keep getting an error of an invalid syntax.

Dear Sirs,
I tried to add a clock code to my DB form in VB – all out of a sudden I got
an electricity failure.
I tried to open my DB form again in design mode to continue but immediately

I am trying to find a way to let five people use an Access database at the
same time.  There seems to be several different options, but I am not sure
what the best way is.  If anyone has some good advice/pointers on this topic
I'd sure appreciate it.

Know this is real general...I work a lot in Access. Want quotes created with
word due to unstructured nature...there any good documents that would give me
some vision on using data from access to open a template in word that might
have address detail populated and some other ...

I am not able to get around the "Specify Table you want to delete records
from.." warning on the following:
SELECT ReportData.Acct
FROM ReportData LEFT JOIN DailyReport ON ReportData.Acct = DailyReport.Num

I want to test product packaging and need to ensure data provided is
accurate.  To do this I have two packages a "Master Pack" and and "Inner
Pack".  If my Master Pack is 10 and my Inner Pack is 2 I know I have 5 Inner
Packs and the math works out.  I'm good with that.  What I ...

I have designed an application that uses a linked csv file as the main table.
The reason for this is because another user creates this file and jsut puts
it into a designated folder on their computer.
Here is the issue.

How to make an OnMouseOver event for a button on a continuous form?
1. Is it possible?
2. Is it possible in Access 2003?
3. Can somebody give me a hint on how to do it, so that I can keep going?

I'm pretty much an access newbie, having only done very basic training how
the program works, but I've been tasked to make a fairly simple database for
my work. The database is somewhat finished now, but couldn't figure out
couple things.

I am in the process of developing a hairdressing
database for a friend, it had started off as a real
world project but due to certain pitfalls my friend
has decided not to go through with it.

What is fetch defaults?