I have a command button with an "On Click" event procedure doing something
like this:
"DoCmd.RunSql" Update table_A where ... "
MsgBox" Update completed" "

Can anyone help me why I don't see Calendar Control ActiveX Object when I
click More Controls option in ToolBox. I am trying to add that activeX to my
form.
If it is problem because I don't have the required ActiveX File then when I

I have three tables,
the first contains "ClientID" and "ClientName"
the second contains "ClientName"(lookup wizard to the first table) and
"ClientDevices"

Do you have an idea of how to use a comman button to
control the updating of forms with new values?
Thanks,
regards,

hi --
i have a combobox on my switchboard screen in my a2k app'n. it's got a
litany of numbers ranging from
0,1,2,3,4,.....,99,100,105,110,115,....,195,200 like this.

I would like to open a form maximized.... whet is the correct syntax.
Thanks

I have a date range that the user needs to use.   10/1/2002 thru 9/30/2005.  
They can only use the dates in this range.  Nothing before 10/1/2002 and
nothing after 9/30/2005.  I have tried the "Between #10/1/2002# And
#9/30/2005#" and

Hi there! Using A02 on XP. Have a mainform fCkReturnMain
and subform fCkReturnReasonSub. There is a comments field
on my main form. The subform has 6 checkboxes to select
one or more reasons to return the check. If I check a box,

How can I set a MsgBox if a form's field isn't filled in when a button is
clicked? (The form works off a temp table and this button populates a
permanent table and this field is required in the permanent table)
TIA,

i'm trying to use the For Each...Next statement. the problem is the code is
in one
form and i'm looking at another. i can run the code if i hardcode the form
name but

hello,
Im making a database to store information for a student housing company
which stores data about rooms, students and payments etc.
Ive been struggleing on this payments form for over a week now and its on

Hi, can any one help
this has got to be easy as im new to access
I have a table with the fields roe, per, uw
I have a form with the same

I am attempting to write a code so that when a command button is clicked, a
field in the form is automatically populated.
In the "On Click" event procedure, I want to have code that indicates the
following statement be entered into the field "Coverage Area":

When I run the sql in following code I get 4 records (which is
correct)
When I check the "recordcount" it seems like TB only has 1 record
What am I doing wrong?

I don't know if I express myself correctly put I wan't to read one word at a
time in the line I'm reading.
I know the code below doesn't work, but it's just to explain myself.
if the line read is "Kalle Pelle Nisse"