I have a form called Notes (called from another form with a command
button). On the Notes form I have a button to close the form and save
the data in a new record in the Notes table. That works just fine. My
question is -- how to code a second button on the Notes form to "Cancel" ...

I am having a little trouble figuring out the code to put in to just simply
add information I have entered in 3 or 4 text box fields to a table I have in
access.
Basically it's like this, I have 4 text boxes (date, forman, notes and

how can i open and query a report displaying only the months of the month of
the date in the textbox of the current record on a form?

I have a main form with a datasheet subform on it.  Records can be deleted
from the subform by selecting the record and then clicking on the delete
icon on the toolbar.  But I want a custom delete button.  And you can't put
a button on a datasheet.  So if I put a button on the ...

Below I have pasted the filter code that I have been using on a lot of
my continious forms.  It works great, and thank you to who ever
created this code.  I found it here on this site.
I would now like to use the same code to filter a subform that is in

I have a database that I had assistance in creating and was tutored with on
the code used.
The main form has buttons on it to select the station or cell name. The form
"frm_Job" that it calls up is the same form used for every cell. The form

Why are my subforms empty when query returns no data?   Is there a way
for my text boxes to show up and display 0 (zero) values if the query
returns no records?

I have a form / subform
the form contains a field with date values and the subform contains funds
and amounts entered on that date.  When my form is displaying a certain
record for a date, I want to be able to click on a button that will open a

I have a Main Form and a Subform.
The Subform has a Combobox called WorkerID, which shows 3 fields to select
the person you want to assign to that task.
Which upon selecting that person in the Combobox would auto-populate the

I have a form with two combo boxes.  The first one selects
the Area (AreaID) and the second selects the equipment
(EquipmentID).  In the SQL statement for the equipment
combo box is as follows:

I have a form with a button that has the following code:
Private Sub New_Story_Button_Click()
   DoCmd.OpenForm "Story", , , , , acDialog
   Me.Stories_Detail.Form.Story.Requery

Here are my tables for my database:
tblCustomer
custId (pk)
cfirst

Hi, I have a table "Value".
Sometime it has zeros and sometimes ones.
0
0

Private Sub Command24_Click()
On Error GoTo Err_Command24_Click
MsgBox "You are about to make changes to tables. Are you sure you want to
continue?" _

I recently split my mdb for front and back end.
One of the tables has a boolean field that displays as a checkbox. The linked
table displays the checkbox. When I do a maketable query on the linked table,
the resulting table no long has a checkbox, but 0's and -1's. There doesn't