I need some help, to matching data!
eg: out of 20 elements: eg (10,2,4 17,24,5,30, 40, 50, 100, 23, 35, 200,
3501, 201, 245, 323,2000, 33, 44,265,etc)
I would want to know which of these elements eg: make up the sum 275??

Hello, I'm new to access, I've used vc++ and sql, but I was required
to program this project in access. I have two questions in one.
First let me explain my program. It's a huge database which takes the
accounting of a construction company. One of the most important things

Could someone please show me how to add additional columns to the
ListView sample download provided by Stephan Lebans
(http://www.lebans.com/vb_listbox.htm)? Thanks!

Does anyone know which function to run updated query in macro? I used
"OpenQuery" function, but it seems doesn't work. No error message.  The
query is correct because I could run it independently. Thanks a lot.
Mindy

I am putting web browser control in the custom vb application.
Now i want to fire click event of a button, available in navigated
page, after every 10 mins of interval.
Is there any way to do this ?

Is it possible to run a simple script to alter a table column in Access
database from an interger to a double? I have been writing C++ programs
every time we need to upgrade (modify) the Access database, but found
it cumbersome. I know I can change database definition via Access GUI

Having created and implemented a database, I wish to lock (prevent further
changes) a record when the data entry has been completed, by say having a
'completed' check box on the form that locks that particular record,
although new records can continue to be entered and edited ...

I have a main menu that opens several different reports.  I am adding
an OrderByOn, and currently have it set up for one report with the
following statements:
[Reports]![rptRoomDetails].OrderBy = strOrderBy

I have 7 fields to key to on a form. Is there a way to count the number
fields that have for example, a value greater than zero?

I need to append to an existing table from a FoxPro DBF and I can't get
the syntax right.
I can open a recordset:
cnxn.Open "Driver={Microsoft Visual FoxPro

I have a report that works just fine.
Now I would like to add the capability to choose selection criteria to
limit what is displayed.  I created several reports that do this, but
they used VBA to create SQL statements, then apply them.  Now that I

I wrote the code below to be called by a button on an open form (that has a
subform) when we need to create a new (Ghost) record using some of the
fields from the existing (current) record.
The form is based on a query that filters the form's recordset.  The

I've a nasty feeling that this can't be done, but I'll ask anyway.
Suppose you have a large table with lots of rows and columns.  Is there some
way to build a form that will split it vertically, so that both sides scroll
up and down together, but each half can be scrolled ...

Is it possible to create a sort of validation rule that will limit the
data entry in a field to even numbers only ?
thaks,
Caro

Hi Folk,
A local NGO has asked me to create a donor database for them (who paid when,
how much, etc...)
Does any of you gurus know of any databases out there that can do the job?