I have created a form, STATE INFORMATION,  that automatically populates a
subform, STATE SUB,  when a STATE is selected from a combo box and
repopulates the subform on every change of state....simple.
I am wanting to add another combo box called REGION on the same STATE

I have a crosstab query which is two joined tables giving a sum of
hours worked.
Now on my form I want to be able to select certain fields for a
criteria.

I have had some recent issues with database corruption.  I tried to fix my
database using the Compact and Repair, but no avail, so then decided to just
create a whole new database, and then copy and paste all of the objects from
the old database to the new one.  According to an ...

Attempting to set up validation at form BeforeUpdate. Am checking a combo
box, if it's "" or Null, then Serial and Order can be left Null or "" (Serial
and Order are both Txt) All controls are bound.  
PartID looks at Part Table with 2 columns, only using  description in form,

Hello All;
I have a list box on my form that has a prefilled list from another table,
and I have it coded so that this list autopopulates from this table. However,
there are two fields that I would not like to see on the dropdown list, and

Can Access 2000 even support transaction processing? I have an area in an
existing application that would be ripe for a begin/end and rollback if user
cancels the process...   I am currently just using DAO in this app. It is
scheduled for redevelopment in VB .net 2005 and using ...

Hi to all,
I would like to know on how to assign a value to a declared public variable
in a single module only, ( say a variable module) meaning without going thru
all other procedures to assign the same value to the same variable that are

I've got a very strange problem.  Basically, I have an access table of
data, which users can input values into via a form.  Some parts of this
form have vb code to enable the user to input a shortcut for a word,
such as "e" for "English" and then the VB code will convert it into the

I have three check boxes and one combo box. If I have only 0 or 1 check box
checked I want 'hello', otherwise if I have > 1 checkbox checked I want
'goodbye'. Can anyone help me? where would I put the code, and what would the
code look like? Thank you, Ryan

I have a code that needs to requery in order to work.  But I get this
annoying message when it runs:
"You must save the current field before you run the Requery action."
is there a way to make it save the field?

I'd like to add a string to some existing text in a memo box, but I'd like
the string to appear on a new line.  Any ideas as to how I can achieve this?
Many thanks in advance
Eusi

I am trying to use this sql  to return the number of records in a query and
show it in a text box.
It shows the text not the value!  Any help would be appreciated.
Text23.Value = "SELECT Count(tbl_TempCalendarData.MeetingID) AS

I'm importing 2 tables in my db from elsewhere. When the tables are imported
I'd like to sort on a field called date, however the data resorts itself on
import on another field.
In code, how can I sort a table's data based on a field?

Hi friends,
I have been searching the discussions and the web and found one of Allen
Browne's posting that was close to what I was trying to get at but I still
get nothing filtered onto the report.

Hi. A small problem here..
I have a form for enetring customer data. And on this form is a
ComboBox for selecting the ZIP code. Under the cboZipCode there is a
txtState that I use only to displays the name of the selected ZIP