I am working with Lebans (very cool) calendar in a form
When my user picks a date I want the form to show scheduleing information
for that date.
what I am getting is the form things I am trying to add a new record and

I've got a form that is bound to a query. This form is a follow-up for a
work order. I have placed an option group on the form, with 5 options, to
determine the final status of the work order. I want to make sure one of the
options is selected before the user moves to another ...

I would like to automatically add an entry to a status table after the user
adds an idea to the idea table.  How can I do this without the user seeing
anything.  If I do a docmd.runsql and then run an insert record command, the
dialog box asking if I really want to do this comes ...

I try to select either page 0  or page 1 of a register in a form according
to a bool value blTmp
   If blTmp Then
       Form_frmCustomer.RegisterAddress.Pages(1).PageIndex = 0

Not sure what the problem is here.   I want the After Update action on a
combo box to store a value in a table.  I have a subform linked to that table
and a text field on the subform I am trying to update.   Here's my code
Private Sub txtServerPath_AfterUpdate()

What event is fired when one uses the Access add new record selector? I
need to put code in that event. I would like the resulting blank form
to autopopulate with information.
Thank you?

Greetings all!
I have a table named “Foster homes” which tracks (strangely enough) foster
home data including a text field containing the foster home license number
(field name Lic#) in the format CFxxxxxxxxxxx where x is a number.

I need to search for " Double inverted commas how3 do i do it?
Thanks
in advance

I have a form where users enter client payments into a payments table based
on charges in an activity table.  For the purposes of my question, the
relevant bits of table structure are as follows:
tblActivity

When I use the code below in an AfterUpdate event on a form, I get an error
stating that the Append query "didn't add 1 record(s) due to key violations."
The primary key of tblPayments is an autonumber field... is there something
inherently wrong in this statement, or am I missing ...

What event is fired when one uses the Access add new record selector? I
need to put code in that event. I would like the resulting blank form
to autopopulate with information.
Thank you

Someone left the organisation and had set up a access database.
Data is entered with a form and the form is also printed off.
There are a lot of checkboxes on the form  only a few of which are checked
in each record.

The borrowed code below returns type mismatch error when attempting to
evaluate .FindFirst
I assume it is because IngMyVar is an integer, and the code was written for
a string.  However my knowledge of syntax is weak, and I haven't stumbled

Hi new to forum..looks great..also v new to Access and SQL etc...
I have created a form whereby you input your search criteria into a text box ,
click on a command button and it submits the query and returns and answer in
the data sheet below.

I take a long tiem for this but i'm still not get a correct answer the sql
string like this
strSQL = "SELECT Table1.one, Table1.two FROM Table1 WHERE Month([two])=1
I want return most of record with the month = criteria but it only return 1