I have a Form & a Button on it for the user to Print the Form, which works
fine.
Private Sub cbPrint_Click()
 DoCmd.PrintOut

I have several fields in a form.  The recommended option field is a
calcuation that gives me a result of #1-#4.  My end-user is to select the
type of reports available to them depending upon the recommended option so I
need that combo box to only show the option availalbe to them ...

Hi guys
I am trying to create a subroutine that will loop through a recordset of
items and add them to a new record in a subform in datasheet mode.  However,
I cannot seem to get the action to goto the next record.  It "cannot go to

i have id in the first field and i dont want it highlighted when the 2nd
form opens because it(id field) isnt meant to be changed other than the
first form of 17(its a survey) because each following form just places the
ID value from the field on the first form onto all the forms.

Does anyone have code to stop the Access error pop-up when entering in a
phone number wrong. I would like to have my own error message pop-up.
thanks!

Hello!  I have created a custom sub that I want to set for the OnClick event
of several buttons on my form.  I don't want to have to define so many event
Subs just to have them each contain a call to my Sub.  My Sub is named
FindIt and I have tried setting the event property to: ...

i renamed my tables and forms
now the forms dont update the tables when filled out?
ie the form used to be Water: Sweet Grass
and the table was      Water: Sweet Grass

Below is an example of data in my excel sheet.
            A        B    C     D        E           F
Cell 1      ?
cell 2   Steve   1    to    10    13/2/04   britain

I have an application with a number of forms, some of which have a
recordsource that is a join of multiple tables.  The forms are all
bound forms.  Using VBA, I would like to be able to interate through
the controls on each form and determine: a) the controlsource and b)

When I use the exit on the switchboard it closes the database but leaves the
Access application open. Is there anything  I can do to click the exit button
and have the Access close too and return to the desktop?
thanks!

i want to select a value from my combo box and have it open the form
corresponding to that value.....ie combo box has 7 values....each is a
reserve(indian settlement) name, each reserve has its own form. so i pick
one of the reserves from the drop down combo box and then click the ...

I'm trying to use a UDF for the RowSourceType of a Combo Box in Access2000
(Windows2k).
I'm finding that the UDF is not being called multiple times as advertised in
code samples I have. The result is the I only get the one call to the UDF,

Hi, i need to know if it is possible to open a report on a page that is identical to the record number. For example, say someone is scrolling along the records and then they click on the print button that i have made. I would need that report to open on the corresponding record ...

im totally new to access, my 8 month project at work is to create a access
db. anyway i want the first form to close and open a new form when next is
clicked. i did that. but i also want the new form to open with the same ID
field as the first form.   this is what i have now and it ...

I have a command button in a form that creates a new Work Order.  I would
like it to add 1 to the highest number in the table, i.e., our Work Orders
are numbered W-100, W-101, etc.  I have tried placing the following code in
the BeforeUpdate event procedure, but nothing happens ...