i need to create a recursive function that allows me to create a different
table (with the same fields) depending on an answer entered into the current
table. how do I do that?

I am looking for something within my form that will add a number to the
highest number in the table for every new record that will be used as an
identifier.  Autonum is not a reliable way of doing this.  I am trying to
have the numbers auto enter for a new record and save with the ...

There's a Prospects table which stores the details of all the prospects in
US.(US operations).Now my senior wants me to design similar form for Indian
operations.Almost all the fields for US operations and Indian operations are
same except 5-6 fields.Do I need to take another ...

I know forms/reports are ultimately just manipulating a table, but here's
what I would like to do and hopefully you can help me. What i would like to
do is create a form for users to manipulate (and ultimately a report with the
same design) which contains an upper header where ...

Eg change entry "Business Systems Administrator" to "Business Support
Administrator"

I'd like to modify a Column in a table that is setted as Double into Decimal
with 4 places.
I try the command ALTER TABLE tab_final ALTER COLUMN txt DECIMAL (15,2) but
it didn't work. Is there some way to do it.

I am redesigning a Vendor Directory database that I put together a few years
ago before I knew much about design.  In brief, one or more certificates are
associated with each vendor, so rather than having Cert1Type,
Cert1ExpirationDate, Cert2, etc. fields on the main forms (and ...

I'm working on a project that deal with a large number of identical
word documents. Eeach one has the same fields and same formate. The
only changes are the field information such as. Name, Address, Phone
Number, etc..

Hello, I'm trying to find out what's the best way to approach developing this
database.
I'm trying to develop a database that has some data in it already that
includes a description for selection and in addition would have additional

What would be the best method to produce a random question test generator
using MS Access 2003?  My problem is this...I ave a pool of different tests
with many questions and answerssd but have no easy method of generating a
test which is different from the previous to prevent ...

I have tried searching on this board for an applicable answer but was unable
to find one that would suit my needs.
I'm trying to create a database that has quantities of parts that belong to
components. Each part has a name and a part number. Each of these parts may

I want to create a table that holds information about contracts and one of
the columns will be a scanned image of a contract .tiff file.
What is the best way to create the table and column so I can type the path
of where the .tiff files reside and ultimately have the user just ...

I have downloaded pictures from my phone to my computer, with no problem. But
I can't figure out how to download them to a CD. Can anyone please help me? I
am using windows xp.  

I have an Access Database that runs on XP (Access 2002).  There are
multiple queries that pull multiple job codes.  In other words each
query has multiple job codes.  I'd like to take those queries and
combine into one query.  Ultimately, what I'm looking for is to make a

The solution to my last problem was to use an Append Query.  This has worked
for most of the tables I wanted to add to my BIGTable.  However, several
tables that I want to Append gave me the following error message:
Microsoft Access can't append all the records in the Append Query ...