I would like to carry out a search based on the crtiteria selected on my
form. Please let me know if this is possible or an alternative solution.
The forms record source is based on a query called "qryCandidates"
On my form, I have a combo box "cboSearchType" linked to a table ...

How can I make a conditional statement in a text box? I have a recollection of
using "iff" but it does not seem to be working.
Right now I have
=[txtSize]/25.4

I created a form and don't want users to be able to scroll to the next
question without answering the one they're on.  I was able to use the
mousehook module when I run 2007, but when I run 2003 it scrolls through.  I
have the dll file in the same folder and the modules in the on ...

Thanks in advance for any advice you can give me on this...
I have a problem with users trying to find records (using a single form
view):  they always seem to "forget" to click find or ctrl+F before entering
their criteria, therefore they are overwriting existing records.  The ...

When I switch a database to OFICCE 07, I get in one of the forms after any
botton is clicked the following error "The expresion On Click you entered as
the event property setting produced the following error: User-define type not
defined."

I have created a form that accesses a table.  This form should allow a new
record to be added or to update and existing record.  How do I select a
record from a list of all opportunities in the table or add a record if that
is the intent?  Should I create another form that has a ...

I have 3 bound controls txtBW_Ver with a control source of BW_Ver, txtOE_Ver
with a control source of OE_Ver & txtTW_Ver with a control source of TW_Ver.
I have an unbound text box with a control source of
=[txtBW_Ver]+[txtOE_Ver]+[txtTW_Ver]

I have a control, txtmemnumber, which is a number and which I want to advance
the last value by 1 when I create a new record. I have used the Dmax function
in the Default value like this:
=Nz(DMax("txtnextnbr","tblmemnbrs",""),0)+1

I am new userof access and I am creating a for where I have two fields.
Ex. Score A (Combobox - 0, 1 or 2)
    Score B (Combobox - 0, 1 or 2)
Total Score (Text Box) - (I want to create expression here so total score

I have a db with a combo box for searching for a given invoice #.  If not
found, I would like to go to a new record.  How would I code this in VB?

I have a database that in Table form it shows the subdatasheets that make
refrence to the main table. It is basically a Menu ordering system. Goes
something like this:
MenuByCycle (Contains: Cycle and year), MenuByDay (Contains: Day), MenuByDiet

I am trying to develop a dispatch program using microsoft access, the only
thing I lack is the ability to enter the time/date automatically by clicking
in a field.  I've noticed on other similar websites, members say that it
cannot be done in access, butI have seen this done in ...

I have a list of customers, and in a separate table a list of categories. I
understand how to create a one-to-many relationship and a lookup. What do I
do if the customer can belong to more than one category?
I have created “many-to-many” relationships before e.g. between a ...

I am creating a database for my business contacts. Some belong to a company,
where I would have several contacts from the same company. Some are private
individuals. How do I design the database so that the address fields for the
company contacts “belong” to the company while the ...

I used a macro to create next record and previous record buttons.  When I
reach the last record, a blank form for a new record is loaded then I get the
default message for a macro error and when the first record (for the previous
button) is reached, I get the default message for ...