I'm trying to change several controls to 0 if a certain condition is met
using VB code, but I keep getting an error stating that I can't change those
values.  Is there an easy to do this?
my current code looks something like this

I am converting an Access database to an Access Project (adp file). There is
an unbound form that has lots of controls with contol source like this one:
=-(IIf([AsAt] Is Null Or [Begin] Is
Null,Null,nz(DSum("[Amount]","Cashier","[DateOfPayment]>=Forms!TB!Begin And

I want to loop through the rows of a list box and get the values from
certain columns.  I am trying to use the column property but I don't know
what the second parameter is looking for.  I tried an int but it doesn't like
that.  Any help that you could give would be great.

I am setting up data access pages.  Everything is working as far as reporting
and queries.  The only problem is that the users are not able to input.  I
can perform the inputs, but the user cannot.  I am not seeing anything in
regards to permissions that would stop the users from ...

How do I convert a string to an integer in Access.
Thanks in advance
bbdobuddy

I am interested in using a hidden junction table data entry form to enter
data in some fields that have been vetted from another input form that deals
with the two primary tables.  The question is: can one unhide a form using
DoCmd?  For example, it is very simple to use DoCmd to ...

What does this term mean?  I'm trying to add color and the instructions say
"bcg_CreateRectangles "<MyFormName>", False - it says to run this
"subroutine", run it where?  I'm confused!!!!  (o:
Thanks!

HOW DO I REFERENCE A SUBFORM ON A TAB CONTROL PAGE TO A TEXT BOX IN THE MAIN
FORM

I need to reference a control in a subform on a page(tab) in a form.  I can't
find the right way to identify the page or is it even necessary

I have a control name Paid on a continuous form. In those controls I have
numbers. How do I clear all the numbers in the control with a command
button?
Floyd

In our database, we wish to have the following:
item #1 is either yes/no. Item #2 has 5 possible values, say, A,B,C,D, and E.
We want it to behave as follows:
if the user inputs item #1 as yes, then Item #2 will only allow C,D, or E as

I have a form (frmMain) based off table 1.
On this form is a button which opens up another form (frmSub) also based off
table 1.
I do this to reduce the clutter when entering data.

I have saved a form as a report.  The problem I am having is with both the
form and the report.  My form is a multipage form, I am using tabcontrols.  
When I select the record to print it, I only get the current page.  I saved
the form as a report.  It only shows the first page ...

Hi
I have a main form and subform,I want a new record to initiate on entry
into the subform, which I have on current event of the subform with
DoCmd.GoToRecord , , acNewRec

There was a power cut, when I started the computer again it couldn't find
printmaster.
Do you know what to do to take the machine back to another date, I have
heard it