I have some code in the Forms Before_Update event.  This code has always
worked when I use it before moving rows, but it does not work as
anticipated when I try to close a form (from the X in the ControlBox). When
I close a 'Dirty' form and select No, I am presented with the "Cant ...

I have this statement that keeps giving me a compile error on
CDDiscountManID so I'm assuming once again the syntax is wrong...it's in the
first two if parts.
Thanks

I'm trying to create a form with buttons populated by a recordset without
actually displaying the recordset.  I want to use each recordset item as the
caption on the corresponding button.  I'd like to display the buttons in
rows of 10.  The buttons will also be filtered by ...

Ok so I have a form with information displayed in it from one of my tables in
the DB.
If I have two empty text boxes and I want to enter data in one textbox and
have it display in the other textbox on the same form.

Is it posssible to sort the column heading  of the crosstab query? I
have a crosstab query and I want to sort the column heading name
produced by that query, I just want to control the sequence of column
heading name.

I've been looking for information about this from all the usual haunts and
haven't found an answer.
I'm creating an application which is to be run by many users, who all use
different screen resolutions. I have designed in 1024x768 which is the

I have a log-on screen where a user enters their username and I capture
their CONTACT_ID value.  When they log-on, I want another form to open that
only shows their assigned projects they need to work.  There are 4 different
types of projects -- 2 are assigned on a main form and ...

I have a form I filter for a particular event.  I want to provide the user
with a list of people registered for the event in which they will confirm
whether they will still attend.  I have provided several "yes/no" check boxes
for them to note their response.  I need to then keep ...

I have a form with a check box and a text box on it.  To close the form the
user clicks the "X" located at the top right of the form.  
What I'd like to do is have code that executes on the On Close event which
does not close the form if the user has checked the check box but has ...

Trying to find out what the following actually does?
DoCmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70
I have seen several posts all over the place but all have the point where
the 3 is replaced by an actual menu name.

Is there a way to return a zero value in a subform text box if a query
value it is bound to is null?  When the query value is null, the text
box doesn't show up, and I'd like to have it there all the time.

Two questions:
Where can I go, if anywhere, to get a good grasp on the possibilities and
limitations of openargs?
I have the same questions for writing strings. Where can I go? I can never

Can you have multiple sources on a form?  I have a form that I want to use
multiple sources on but get the #Name? error when I put the second source on
the form.   I used the Expression Builder to put a query field on the form,
it is as follows “=DayCount!xMon”

I have two tables which I want to merge.
Table 1 has date and expenses as two fields.  The table has all 365
days records in it.
Table 2 has fields as date and revenues in region A.  Some of the

I have the following group of code, but I keep getting a "no current record"
error.  I realize that there will be instances when there is not a record
that comes up via the SQL, but I need it to just populate a zero (0) value in
that field when it happens.   Doesn't the if isnull ...