Basically I have four db's that have completely different information,
except dates and mundane stuff, that need to either be imported into a
single db, or just queried at the same time for reporting purposes.
Any suggestions would be great. I know it is a simple answer, it is

i hope someone can help me with the code below, i am new to access and very
new at vba code but see it as a nessesary evil to do what i need.
the code below was supposed to delete arecord but before doing the delete
ask if i would like to send an email of confirmation, all 0f this ...

Does MS Access 2003 truncate text data fields at 255 characters? How do I
change the truncation of text data?

How can I prevent a record from being updated or inserted if two data
elements are null? I don't want to require the user to enter both data
elements, but I want to ensure that at least one contains a valid value be
before a record can updated or inserted into a table. This seems ...

I'm in the process of utilizing the upsizing wizzard to migrate to an SQL
server back end.  Can anyone suggest a good resource for me to read on what
to look out for in this process, or a basic step by step instructions?

I have a table of measurements made on a number of birds. For each record
there are the measurements and the date, location and identity of the
measurer. On any given occasion one person will measure a number of birds in
the same place on the same day.

Hi, I'm importing zipcodes with leading zeros from excel.
Access is reading them as number and dropping the first 0.  How do I keep
all digits including the first 0?
Thanks

I have Office XP Developer version and was wondering if there is any
advantage to using 2000 file format as compared to 2002 format.
The only thing I've noticed so far is that I can't seem to create a mde file
from the front end using 2000 format. However I've read in these groups ...

I am trying to design a database to administer a local league, I have
maintain stats for each team for each game.
I have the following tables:
Weeks

I am making a slide show and I want to use music behind my slide show how do
I do that. Not just for one slide but all of them?

I want to get the current stock level of a product. So I deduct the total
quantity of it consumed in the tblUse from the total quantiy of it supplied
in the tblSupply. This works fine for now. I use Access 2002.
My fear however is what happens when records in the tables are their

Hi, I want to know if it is possible to somehow copy all Autocomplete email
addresses into the contacts folder?  I wanted to send an EChristmas card to
anyone I had sent an email to in the past.
You suggestions would be appreciated.  Thanks

I've got tables in an existing db that I can export the definition for the
create in Access 2003. So, how come
xxx decimal(10,4) doesn't work? I've tried decimal (10,4), decimal [10,4],
number(10,4) and all of them don't work.

I have a table for my drawings(DWG) and a table for the customer parts that
can be made from my drawings (PRT).  Each DWG must have at least one PRT
associated with it but can have many PRTs.  Each PRT does not have to be
associated with a DWG, but one PRT can be associated with ...

I am creating a DB for my company (a simple one) and its for the employee
records. Each employee has an ID photo along with their records. I need to
create a field that will show each employee's ID photo whenever you look up
their record in the form view. i have all the ID ...