I have a lengthstay field (from tblGuests) on a form, and I want to make a
button that will add '1' to the lengthstay field value (value automatically
change after clicking on button), what code do I need to put in the OnClick
event?

I have been working on this assignment for a week. I am almost there but have
struck a bug. Even my teacher says it should work, but it doesn't.
The assignment is to create a database for a wedding photographer. The
photographer offers 3 photo deals, "basic" $400, "special day"  ...

I need to knock a small piece of code together attached to a button on an
Access Form that will open Excel, get some information from a few known
cells, then close Excel down again (OLE?).
Can anyone point me to some code on the net somewhere that would help me get

I have a form and i want to create a label (or button or anything else that
work), that is hyperlink and gets the values from three fields from a table.
assume that we have three columns column1, column2, column3 in a table.
the datas are colum1.data1, column2.data2, column3.data3.

  Ok need some expert advice here. I have the usual main/sub form setup.
On the subform though I would have like a layout of controls in lets say a
3x3
matrix. And after the first 3 controls had been filled I would need to

Using two unbound cbo boxes and an unbound txtbox
i want cboTwo's available selections to be based on cboOne selection
i set txtTmpPos = cboOne in afterUpdate
cboOne works properly and txtTmpPos changes properly when a new value is

I would like to use the ActiveX Calendar supplied with Access 2000 (my first
time using an ActiveX control).
1.  I am using it to supply a date to its control field ... when I click a
date in the calendar it only appears in the control field after the field

Access 2003 ... I have a bound checkbox, ckBox1
What I want to happen is on the changing of a text field nearby, if a
certain substring is within the value of that textbox, then the checkbox's
value should be set to True.

I have a form named "Home" that has a subform named "t_subcommittees " that
has a set of command buttons that opens another form named
"CommunityHealthYear" and this form has two subforms named "BU_CH" and
"f_PrimaryEntry".  

In Access 2000, is there a way (perhaps in code as there is no listed
property) to change the back color of a Tab Control?
I have found that you can set the backstyle to transparent which lets you
see through the pages, but the background of the tabs remain grey. I would

Is it possible that to do something directly after applying a filter
successfully? The only thing I found is the OnAppy event but this event
still occurs before actually applying the filter.
Thanks a lot.

I have some long SQLs in VBA using:
"SELECT from table WHERE id IN (1,2,3,4,5 etc)"
and they tends to get pretty long. What's the max length of an SQL
statement?

I have a table to track ID's and Passwords.  User's will check them out.  I
have the same table storing all records.  When user checks in an ID, i will
modify the status to "HISTORY", populate the checkin date.
In a continuous form, I have a command button on each record to check ...

I have the following code in a general module. What
test can I make prior to the use of the "Screen"
method when I don't know what's on the screen?
For example, I get a runtime error if I execute the

In an earlier post exchange with Douglas Steele,
I implemented an On Error routine to deal with
errors raised by the use of Screen.ActiveForm,
Screen.ActiveReport and Screen.ActiveControl