I have a number of fields used to calculate a final total on a form. If any
subform field values have no entry the field will be null, how can I get my
fields to enter 0 if the value is null?
Thanks

If you import a table or other object, Microsoft Access adds a number to the
name if it conflicts with an existing name. For example, if you import
Employees and Employees already exists, Microsoft Access renames the imported
table or other object Employees1.

Everything in my database is "cm" - I wanted inches.
Can I change this - if so "how"?
Thanks !!

I need to be able to insert 4 pictures 4 x 6 into my database - I also need
to be able to print these 4 pictures in a report also need them to be 4 x 6
on my report.
I have created 4 fields in my table for pictures with the data type of "OLE

I execute a query to populate a combo box.  When the user selects one of the
entries in the combo box, four text boxes are populated from the selection.
One of the text boxes is populated from a memo type field.  Needless to say,
the memo field is truncated at 256 characters.  I ...

I can easily retrieve a specific record in a form by using a list box
populated with the list of items.  But when I save this as a data access page
I lose all ability to search for any specific record.  I can only use the
navigation buttions to truck through the database.    I'm ...

Hi I know there have been a million and one threads about requerying forms,
sub forms and tabs, but I can't seem to get mine working.
I have a main menu form called Main_Menu_Tabbed for which I have a tab
called Phone_Log, within Phone_Log is another tabbed sub form which contains ...

I need someone to verify my understanding of referential
integrity.  I have a form based on a table with two FK's
relating it to two other tables.  There will be an entry
in either one or the other of these fields.  

how do I do to prohibit the entrance of a record if it goes of the same
customer and with the smaller date than 30 days?

I am distributing my application and it is important to me to capture and
store the date the program is first opened on another computer.   How can
this be done?
Thanks,

I've set up a form that uses data from 3 different
tables, and I'm now unable to enter data in the form or
change existing data.  I can do it in the table but not
the form.  Any ideas about what I need to do? Thanks!

I have looked at all the examples and read through many threads and can't
figure out what I am doing wrong.  I have a form based upone a table called
"Controls".  I want to lookup a value called "TPLong" in a table called
"TopPDetail" based upon TopPDetails field "TPShort".  In ...

Here is what I have on a form:
=DSum("[NI]","[tblProductionData]","[ProgramType]='" & [ProgramType] & "'
AND [PostcardPhase]='" & [PostcardPhase] & "' AND [Resort]='" & [Resort] & "'
AND  [Team]='" & [Team] & "' AND [CallCenter]='" & [CallCenter] & "' AND

I have some nested subforms that contain information...I also have an add
doctor button. The goal is to have the form requeried on the fly...but it
doesn't seem to be updating all the time. (?!) Here's the code on the OnClose
ppty of the add doctor form:

Can I populate a data entry form via a multiselect list box? Example, user
selects 5 items from listbox and these values then would populate 5 records
on a data entry form with the values from column 1 in the listbox.
Listbox would look like this