The following code does not requery main menu.  Any help is
appreciated.
Private Sub Form_Close()
   If Me.Dirty Then

It seems that the check box value is -1 when it is checked.
Is it possible to have set value as one?
Your information is great appreciated,

I have a form that has two combo boxes, each one based on a table.  The combo
boxes are 'CustomerName' and 'ContactName'.
I want to choose a customer name and then only have the contact names for
that customer show up in the contactname field.  I will also need to be able

I may be posting this in the wrong place, so I'll apologize for that now.
This may be a simple question, but apparently I'm missing something.
I'm working with a simple database that ask the user to complete some basis
identification questions and then answer about 30 questions ...

Can somebody tell me if and how it is possible to change the domain from an
aggregate function for an SQL string?
I think about something as below but cant get it to work:-
MySql = " " _

Hi,
I have the following calculated field on my form which works as long as my
records contain [Trans_Type_ID]= 1 AND 2.
=Sum(IIf([Trans_Type_ID]=1,[Quantity]))-Sum(IIf([Trans_Type_ID]=2,[Quantity]))

I am trying to set a recordset programtically referring to a remote SQL server.
I have been sucessfull in setting the recordset but it does not apear to be
updatable. Is it posible to make a dynamic recordset that is updatable?
I am using the method descibed in the Access VBA help ...

I've been trying to figure out how to get the Active X listview control to
display a list of files in a folder, given the path of the folder on an
Access 2007 form.   I've looked all over for samples and am striking out
everywhere I look.  Any help will be greatly appreciated.

In microsoft word xp I have a file that comes up with all ooo and no written
text.
A message comes up do you want to unencode, then the letters come up but
they are all double space and have a root system word on the top.

I have a form with two subforms, and I'm trying to apply the same
filtering - set in one subform - to both.  I'm using the following code in
Subform1:
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)

Can someone tell me how I can get the number of records holded in the
recordset from with in VBA?
Something as:- intMax = me.recordcount
Thx,

I'm hoping someone can help me out with this.
I have a form that has a several pages (tabs?). One page is the main one
where customer information is entered; another tab is a customer checklist
that has a series of 23 checkboxes. Each checkbox is tied to a yes/no field

I need help with this soooooo Badly.  I have a form, within a form linked to
2differnt budget tables.  The first form there is  Budget ID, budget begin
and budget end(both mm/yyyy formats.  The sub form there is a budget ID,
record ID, Company, Account, current year budget amount ...

I am attempting to create a form to perform receiving of equipment and update
the asset tables with the equipment based on a location.  When the form is
opened the first time, the data in the recordset is invalid.  The
absoluteposition is -1.  When you make another selection the ...

I am getting this error and I tried Compacting and decompiling the database
and all that jazz and I still get this error. Its a 1 table database, nothing
complex going on here.
I have a form that I do a search on so information gets updated in my sub