Writing a simple query, and I want a new filed to return true or false
based on if there is info in that field.
For example, my table has a place to store a phone number.  I want to
create an expression in my query called PHONE_ENTERED and if the phone

I'm creating Address book.
Header of the main form (frmAddress) contains combo box (cboFilter) to
filter records by Occupation on main Form(Ocupation1). That's working. Combo
box also have "Show All" in one row.

I designed a form that allows the user to enter dates, and click a
checkbox so that certain forms may be loaded.  However, I have had
trouble getting the right information to load.
I would like to enable certain reports to be displayed as the user

I have created menu bars for my access application and now would like
to transfer many pieces of code in modules so that they can run using
macros. I beleive this is the only way I can make run my code from the
menu bar. Correct?

I would like to use Access to do what I'll call build kits (pick n
pack) What I have created so far is 3 tables as listed
Individual Forms Table - This is a list of all things that might go
into kits that are listed by a unique number.

Hi ppl
I have created a form based on a query. the query call the max number
from the table and adds 1 to it....
This is the only field the query calls.  the rest of the fields on my

Hi ppl
the foll: code calls a query that inserts the data into a table through
parameters...
is my sql statement correct...  My table is created in design view....

I have this scenario
- 2 separate db's (filename = dbOne.mdb" and "dbTwo.mdb") both with a
table called tblMapped in it
dbOne.tblMapped looks like:

Thanx to all the help I have received from this group, I can now
successfully print a form that has been split into two reports at the
one time.  However, I am suffering from severe brain fade in regard to
printing only the current record the form is showing.

I create two fields in my old table. One is D_Status of type Yes/No
Checkbox and the other is DDate of type Date. In my table there is
already records in it. I set the default value of DDate as Date() (as I
need the current date). My problem is when user open the form and click

I have asked this question before, but I could not get the suggested
solution work.  So I will give more details this time.
I have an append query that adds several hundred records to a table into a
text field.  Next to this text field is a separate Number (Single) field

Should I:
--------------------
     Dim sqlA As String
     sqlAll = "DELETE * FROM tblName;"     '....or whatever!

I have a simple databased developed on Access 97.  Recently I converted it
to 2003 but not work on a parameter query.  The program starts with a
opening form.  When I press "Esc" key, it will open a form that connects to
a parameter query.  The parameter query box appeared.  Once I ...

I have a table with records where each record has 14 tick boxes.  Simply
speaking, I want a report which shows each record for which any of the tick
boxes is not ticked.  It sounded simple until I started to try to do it.
The only records I don't want are ones for which all 14 ...

I would like a user to be able to click a button whilst viewing a
record within a form and see the /same/ record in a report.  By default
Access shows the first record in the table because no query has been
used.  How do I prime a query with the current record?