I have a database that is full of names (for genealogy) and I am displaying
the names on multiple screens in one field by concatinating the name fields
together.  My fields are Last, First, Middle, Title.  The Last name contains
some business names, which means there are no First ...

I'm new to Access. I am trying to create a Lookup. I have linked
tables. When trying to go into the tables and change 'data type' to
Lookup Wizard it won't change because Access states "this property
cannot be modified in linked tables".

Hi I have the following in a list box called list0 on a form called
frmInsuranceSearch. Toward the bottom you will see a field called
qryInsuranceSearch.Active which contains a yes or no value.  If yes
will show in list box if no will hide in the listbox.

{{{{{{ access 2007}}}}}}
This  #Error appear to me when there is no records
All text box formula work correctly when there are records
My question is :

The following is a calculated field called "Markup" ... Markup:
(([NetSell]/[IPR])/([NetCost]))-1.
NetSell and NetCost are also calculated fields.
How can I set the criteria in the query grid to find Markup of less

I have been asked to look at a database at work that has a query by form
where the user can select a table to query. There are three columns of boxes
on the form. The first column are drop-down combo boxes that allow the user
to select the fields depending upon the table selected ...

I have a large application wherein I'd like to
run one of its functions as a batch job. The
application currently runs the AutoExec
macro wherein it determines a best fit screen

hi to all
My form has a command button (cmdPrintRpt) and an unbound option group with
several option buttons.  When I click cmdPrintRpt, it opens report rptSummary.
How do I pass the value of the option choice to the report using OpenArgs.