I have a form to create a progress report card for students. Along with the
form controls to gather information to create a printed report, I also have a
command button to save the record to an underlying table.
Is there code or some way that I can check on form close as to ...

I got a [Combo709] on my [Main] form with some values ("A", "B", "C", etc.)
which i want to use to open different forms. The forms names are: "F_A",
"F_B", "F_C", etc.
I was trying to make a button for this, but when I click it, I get a message

I have a strange situation, and I wonder if anyone else has run into it.  I
have a form with a couple of controls and a subform.  I have a menu with a
button which runs a macro to open the form.  This works fine.  But if I open
the form in deisgn mode, and view or update the code ...

I made a calendar and in each day I used a listbox to display task that
needs to be completed. Everything works fine, but with one glitch.
Keep in mind, there are multiple listbox present.
If you set the background color to a dark color in the listbox, when you

I have two tables, both have a unique field (AFS).  How do I code a textbox
that shows only those AFS's that match in both tables?

Access97
I presently use an mdb to disable/enable the Shift on StartUp key on
other mdb/mde files.
This obviously means that anyone else can do likewise with appropriate code.

Does anyone know how to open a query from the switchboard and have the
results displayed on a form?  I figured out how to have a button on the
switchboard open a query, but it always opens it in datasheet view, which I
don't want the users to have access to lest they copy the ...

Hi, all;
So far I've managed to muddle through in the code window, but now I'd like
to learn to actually USE the code window well.  The help is, well, not.
So I was wondering if anyone could send me to a tutorial that has a detailed

The query itself runs perfectly and returns the right records. Any
suggestions as to how to set a form.recordsource and cmb.rowsource to this
SQL string would be appreciated.
Thanks

The last 2 lines of my code are:
db.QueryDefs("qryFrmPlanning").SQL = strSQL
frm.Requery
"frm" is a form based on the query "qryFrmPlanning". However, in order to see

I require the ability to lock records in a form.  For example, we had an
event XXX. The event XXX is complete and everything is processed. Then YYY
event comes up. However, people that register are entered in the middle of
XXX's events. I would like the ability to lock XXX ...

I work with the english version of Access 2K, so when I set the column
widths of a listbox/combobox dynamically, through code, I have to use the
"cm;" unit. When the application is run over the Greek localized version of
Access, this gives a runtime error, because in Greek, the unit ...

I have the following code in the on_Open event of a form opened from another
form;
If IsLoaded("frmCustInfo1") Then
       lngCRefNum = [Forms]![frmCustInfo1].[CID]

My users only have Access 97 on their machines.  Is there a way that I can
install Access 2003 on the network and users can use it without having Access
2003 on their machines?
Also, is Access 2003 compatible with win98 ?

I created a database inside frontpage and used frontpage to generate ASP
forms. When I uploaded the sytem to the server (with ASP extensions) the
forms just display as script. The forms view fine inside of FrontPage. What
do I need to do?