I have a form that has a command button that opens another form on click.
This other form has a combo box from which I select an option for further
view.  This combo box's row source is a select query.  If my select query has
no data, in the on-click event of the first form, I would ...

Ok I looked through the all of the posts and really didnt find answer. I have
a table that has a field "strDate" that holds the date the record was
entered. The default value of the field is set to Date(). All works well as
long as only a new record is entered. What I want to do ...

When giving users the option to modify information in a table, is it better
to have the fields on the form bound to the underlying table or to use
unbound fields and then add/modify the data on the click of a 'update' button?
Is there a preferred way of doing this in the ...

I have a database that tracks 3 levels of information: people; each person
has zero or more assets; each asset has zero or more fixes. The natural way
to present this to the user would seem to be as a subform for fixes nested
within a subform for computers nested within a form for ...

I would like to be able to reset a combo box rowsource to reflect the
changes in the records being seen on the form. I change the form
recordsource and then would like to have the rowsource of the combo box to
be the same.

I have a form and subform. When the user selects criteria on the form, the
subform reflects the criteria.
I need to export the results to excel, but I must be doing it wrong, because
it exports all the records, not just the selected results.

I'm sure the error is obvious... but I'm just not finding it; would someone
take a 2nd look for me?
this is to pass a string to the form_open (below) instructing it to either
make a formfooter visible or not...

I'm new to Access and know very little about the program yet. I need to
do two things with my data base. 1st is I need to be able to sort in a
numerical rather than a ASCII order. How can this be done?
2nd is I need a macro assigned to a hot-key that will allow a block of

I have a button on a form that contains a subform. The subform displays
continuous forms with only one field displayed. It doesn't have have record
selectors displayed (I've made it appear like a combo box) When I click on
the field in the subform I would like the whole field to ...

I have a button on a form that contains a subform. When I click on the button
the selected record on the subform is deleted from the underlying bound
table. Is it possible to stop the message box appearing, advising that a
record is about to be deleted, using code for this ...

I'm sure the error is obvious... but I'm just not finding it; would someone
take a 2nd look for me?
this is to pass a string to the form_open (below) instructing it to either
make a formfooter visible or not...

I've got an application that has been working in a multi-user office
environment for several years (A-XP).
Now the organization wants to allow remote (w/INTERNET access) and
temporarily dislocated (disconnected) users to access the database, make

could some one give ma a 1-line executive summary explaining why i should
use a switchboard over a simple form with command buttons... (or direct me
to where i might find a discussion)... (i'm perplexed, and coming up blank)
thanks in advance,

I have a form whose footer should not always be visible...
I thought that I could pass a value to the form's load event thru an
OpenArgs property assigned at the command to open the form
sigh... (doesn't seem to work)

I have a string like 1.0.1 that I need to increase the last digit to 1.0.2
for example.
How can I isolate the last digit after the 2nd period in a string like
"1.0.1"?