I sent a question about this earlier but since it has not shown up, I am
sending a shorter version.  I have a field in my database that is a combo box
and the SELECT statement in the row source looks up a value in another table.
Is it possible for the row source to contain a ...

I'm working on a document control database (assigns document numbers and
tracks a document from inception to release and through revisions and
signature approval process). Thanks to help from this forum, I've worked out
a multi-field "ID" system to meet the requirements for the ...

I am working with a linked FoxPro database.  This database is accessed and
updated through another program.  I am creating additional functions for
route planning and need to add new tables (because I cannot append the
existing table structure).  For example- The database stores ...

I have a third party data file (500,000 tab-delimited records) and need to
analyse a small number of fields, but there are over 400 fields and those of
interest are between 256 and 400 and so can't be readily imported into
Access 2003 !

I am using Access 2002.
I am trying to design a table that will store the input, and some output,
from a spreadsheet. I have 239 fields. Because newer records will get saved
into the same table, it will be much easier if I keep it all in one table

Every now and then a few records in some tables become corrupt.
How can I determine if corrupt records exists so that I do not end up with
ALL my backups containing corrupt records.
Is there a utility? or do I write a procedure to read thru all my tables?

I am a new user and have set up a database and relationships in Access 2007.
I was wondering if anyone could have a look at my design and offer any help
or suggestions, as I am finding it very difficult to comprehend relationships
despite all my looking and reading. If anyone is ...

Ever since Access 2.0, i have been using fields of type long integer
as a subsitute for date fields, since I don't need the time part most
of the time. Setting the fields format property (or the format
property of a bound textbox) to "short date" not only showed the

Does anyone know of some one who is able to build database at low cost as i
am just starting my own business

I have set a validation rules for a table and also for fields.  Now I need to
set another table validation rule to say:
    If field1 = “complete”, then field2 must be greater than zero (it is a
numeric field).

I have created a message box in the OnCurrent Event on the my main customer
page to obtain information the first time a customer calls.  Everything works
ok, but when everytime I do a filter or open the form initially, it runs the
event twice.  

Want to create dynamic height of a subform am working on. The source object
of the form varies according to what is selected in a combo box and would
want the form to adjust according to the source object.

I am using microsoft works 4.5 and am creating a database file.  Is there a
formula that can calculate age, and grade.  For example i will have a date of
birth column and i would like to have works automatically calculate age for a
another column.  Also I would like to be able to ...

I'd be grateful for any advice for a very inexeperienced newbie to databases:
I am busy trying to create a database to store data in sub sections, and
eventually spit it all out into a report, with some invoicing and
appointments facilities.

I have a "People" table that I would link to an "Orders" table.  The People
table has a record for each individual.  A record in the orders table will
have multiple "People" in it (e.g., Person Placing the Order, Technical
Contact, Budget Officer, etc.).  I would like to link the ...