I have a data entry form that has a Menu item to "submit" entries.  But, I
have found that if a user partially completes the data entry form and decides
to click on another form or a Menu Item, a record is automatically created
anyways without clicking the submit button.

in Beforeupdate in a bound cbobox
I want to test if the bound table already contains a value -
if doesn't contains a value, i want to allow the update
If the table already contains a value <> the update , i want to cancel the

Can you have 2 Lines per record in a Listbox instead of 2"
Thanks
DS

Hi, I'm working on an Access Project (front end) with MSDE (back end). I've
created a search form to open reports. I need to create a Where clause to let
the user enter two values: between ---- And ----
I'm getting an "incorrect syntax near the keyword 'between'.

Have a subform with a cbo box with following SQL in row source -
I want to change the available selections based on the value in txtbox -
txtHybPos but i can't seem to get my syntax correct - because Access doesn't
recognize

In using the following on the Open event of a form:
SetOption "Default Database Directory", "c:\Program Files\Operations"
I get errors from list and combo boxes that fire before this event and
cannot find the Databases they are set to, unless I Code the rowsource after

I have a listpage which is a subform in datasheet view that lists a subset of
records.  I have 17 records that show up on this listpage.  When the User
double-clicks on the record row, it opens the detail record form to the
record that was clicked.  My problem is that it will only ...

Does anyone know if it's possible to send either an SMS text message to a
cell phone or a page to a Numeric Pager through Access?  I'm not able to
install 3rd party applications, so this has to be done based on what I've
got.  I'm able to use Autodialer and MSN Messenger, but ...

I'm using this function to right align Currency in a listbox.  It works
great when all of the Prices are $0.00 or when all of the prices are
$00.00  but not when they are both.  Can anone see why?
Function PaddedCurrency(Num, Size)

i need to find a way to keep the access' close box disabled while certain
form is doing some work

I have a form that lists the different classes in a school.
We only teach English or Spanish.
A textbox 'txtLanguage' shows the language of the class.
A textbox 'txtClassRef' shows the unique reference no. for the class.

According to the Help, I should be able to create an array of variable
length by declaring it like this:
MyArray() as String
However, when I try to assign anything to it:

What would you put in the offset to get a record to move 7 records ahead from
the current posistion.  I guess I just need to know what to call to get the
current record's number.

I have an option group on a form that users select tween two choices. The
form says "Male" and "Female", but the values stored in the table are "1"
and  "2". In my queries and reports, how can I get the values to show as
"Male" and "Female" again?

I am having a problem with vba corrupting the database.  About once a week
when I am editing vba code, usually typing a line of code, vb will lock up
and I get the "Oh so friendly Sorry for the inconvience but you are out of
luck and do I want to send a copy to MS, form."  My ...