i have some items like text boxes, buttons, list boxes, etc on a form.
my requirement is when the form loads, only one button should be
displayed. if and only if i click that button, the remaining items
should be displayed.

i have a subform that i filter based on some combo boxes at the top of the
main form that the user can type into.
i have a search method that is called using the following:
call searchMethod(Nz(box1.value, ""), Nz(boz2.value,"") , ..... )

Hi Huys,
I need to close a database if it is open. This code needs to be on a
seperate database. I have an installer database that when prompted closes the
front end database, deletes the file and copies a new file in its place (new

Hello and thanks in advance.
I can't seem to get a main form's GotFocus event to fire.  I have a few
detail forms that are opened in acDialog mode, and figured that after the
main form got the focus (when the detail is closed) that I could put a

Dear Friends,
I have an unbound form (FormB) whch is opened by the "Not in List" event of
a combo box belonging to an already open form (FormA).
The problem I face is that the code in Not in List event continues to run

Is it possible to make more than one selection from a combo box list? i.e.
say the list contains 10 items, I want to be able to select say 5 of the 10.
Is there a way of doing this?
Thanks.

I have tried both the below code :
If DCount("*","TablName","[SerialNo] = " & Me.SerialNo) > 0 Then
Msgbox("Records were found")
It worked perfectly on one of the computer mdb.

I have made a database at work but there are many users who are not very
savvy with access... On some forms I have a list of recent records they can
navigate to by double clicking... the users usually use the scroll wheel to
"try" and move down the list... this of course just ...

I have a form with 4 acOptionGroup. Each one has 4 options and the color of
each option is black.
Question:
For each option selected, I would like to change the color from black to

I created a form which I want to open when I click a button on my switchboard. Easy enough. I set the command to open a form and the
argument to the form's name.
When I do that, though, the switchboard stays open. I would be satisfied if I could minimize the thing, but I would ...

I have a function that returns String1 & String2 & String3.
Depending on other conditions, I would sometimes like String2 to show in
italics, and sometimes in red, and sometimes both.  Can I do this from code?

I'm using Access 2003.  I have a combobox whose row source is a query that
has 2 fields.  The combobox is bound to the first field (or column, as access
describes it), and is displaying the second field in the picklist.  The
records in my query are like this (double quotes used ...

Thank you for your response.  Unfortunately, the option you suggested
did not produce the desired result.  Perhaps if I explain further
what
I am trying to do, you can offer some alternatives.

I have a form that i created that display each form as a row in a continous
form. What I need is to have one text field on one row not visible when a
check box is checked. Does anyone know how to do this? Thanks!

I have a form I need to filter by a PayDate field. I need to get the most
recent PayDate and then display only the records whose most recent PayDate is
more than 60 days ago (from current date).I have two tables, Clients and
Payments. One to Many relationship from Clients to ...