I'm trying to figure out how to cancel/abort adding a new record if the user
selects a particular value from a comboBox. The form is a continous form
where the user can go directly to the comboBox and select one of three
values. If the user selects a specific value, I need Access ...

I'm working on automation for a bulk data import function that will be used
repeatedly.  I'd like to find a way to SAVE the warnings that Access often
displays during execution of an "append" query.  These would be useful
history for the user to review and it would be very ...

Hiya,
I have two different back-ends; my back-end containing the live data and
then a dummy BE that i use to when working on the system so as to ensure i
dont change the live data.

I am in a form (Winners) that views data via two list boxes "first_data" and
"first_data2" that was entered in a different form (Reg).  There is a command
button that opens Reg so the data can be corrected if needed.  How do I get
the two list boxes to update when returning from ...

I have a table with a column called priority.  Each record (task) in this
table has a priority associated with it.  For example, if there are 100 items
in the list, there are 100 priorities, from 1, 2, 3, ..., 100
However, there are times, when a user needs to re-prioritize some ...

In Ken Getz's Access 2000 developer handbook vol I, ch8 p521, he mentioned
that
"...form data manipulation in an mdb file will require DAO knowledge in
Access 2000 (we think that's the only place in Access 2000 that you're

Isn't there some loop that allows non-sequential numbers? I thought I had
come across or actually used something like:
For n = 0 to 4, 6 to 10
Next n

I have created a DB in the new format. I needed to use the Attachment
datatype in some of my tables.
I also need to have user level security. If I convert, I dont think the new
features in 2007 like the Attachment datatype will be available. Is this only

I am trying to creat a query that will check my data and bring back the lines
that have wrong data.
Eg.
i need the query to bring back were in the data there is a even number and a

I am trying to create a listbox to search for records. The example I am using
is from www.databasedev.co.uk/list_box_searching.html.
I am using this code but it just will not work.
Private Sub ShowRecord_Click()

I want to sum all values in the profit field of table T and write it
to Table Sys.
I have instantiated object d as a DAO database object and various
other UPDATE queries are running fine, but only when I calculate from

I have a form with several fields and i'm using recordset clone property to
insert into an two dimension array variable( array_var(x,x) the name of the
field and the value of the field.
What i'm trying to do is to add a record on a table (Table1) with the values

hello my dear mates on the red battlefield oj Access programing!I Need your
help in finding good articles of command bar matters And how could I trap
click event from A COMMAN BAR BUTTON??? good code excerpt would be espcially
apreciated.

hoping to find some solutions over here.
The problem I encounter is that during running the loop trough the recordset
rs_Ord, an error message pops up at record 2366 when I'm at possition:  
rs_Spok.Find (SrchStr); indicated with comment.

Having some issues deleting records from a table based on a text field in
that table.
I want to delete all fields in the table 'tblTags' inserted by an auto
process, creatively designated by the text "auto" in a field 'DataEntry'. The