I haven't done any coding in about a year, so I'm a little rusty. I re-used
code from an old project to implement a pop-up calendar. The functions are as
follows:
Private Sub ActiveXCalendar_Click()

Good afternoon,
I use Windows 2000 and access 2000.  I have a form called "frmDaily Job
Report,"  on this form is a subform called "frmInventory" which has a
control called "Item."  Item is a Combo Box.

Could someone please advise me?
I use DoCmd.RunSQL SQLInsert in my code to insert a new record
SQLInsert = "Insert Into tblMSFID (MSFRef, MSFRev) " & _
     "Values (DMax('MSFRef', 'tblMSFID') + 1, '-')"

I have an order form, with a continuous order detail subform. The order
detail subform has a field 'QuantityReceived' (that can be edited), to
reflect how much of an item has actually arrived in a certain order. When
the user edits the values of the received quantities, I want to ...

On a form, I want (depending on what the user wants) to be able to change
the defaultvalue of a field in a table. (not the source-table of that form).
Is that possible? How do I do that?
TIA

I have a continuous form (FormA) I open from a pushbutton on FormB.
Once opened I can edit all records as much as I want.
Now I open my FormB in design mode and create a subform. Here I use
FormA as the subform.

Hi, I am using Access 2003 and when ever I open a form and the user click on
a particular control, I pop a message telling the user that he or she cannot
click on this control.
The problem is, the computer beeps when the message comes up!

I need to creating a form that has a combo box to select company names from
the list and I need to use the NotInList Event to add names.  Then I need 4
fields to auto populate.  This also needs to be data entry and edit form.
The auto populated fields will be the same for every new ...

When open a continous form, how can I set the field("Percent") for each
record in different color base on the value? Thanks.

How can I stop in-line code execution after a Docmd.OpenForm? Thanks.

I want to build a SQL statement according to a "filter by form"
selection of the user. So what I do is to capture the "ApplyFilter"
event and use the Filter property as a WHERE-clause for a query.
Unfortunately some fields are lookup values, even compound ones. So my

I am using a form that has a text box that indicates a value from a
table.  I want it to change the back color dependent on the value.
Using the Conidtional Formatting funciont (right click) this is easy
enough for 4 conditions.  However, I need to enter more.  With Excel, I

ok I know I have been pleading for help on this but I almost have i
complete. I just need help finishing it
I have two tables
tblNames

Through the years that I have been reading here, I have read and used
the solution of reseting references so functions in code work. If one
were to distribute an application how can you programmatically check
that all required references are set?

I have created a form containing a list of questions that require only
Yes, No or N/A responses. I now want to query the results to display
each question with total Yes, No and N/A responses given for each
question. The query will not summarize the data the way I would like.