I m using C#.NET and i m connected with oracle with OLEDB. I m try to
add my user defined table in a list box from my MS-ACCESS databse.
My connection string to connect with MS-ACCESS is
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +

I have a number of spreadsheets, each with between 1000-6000 rows (each row
is a property) and they all need to be combined into a single database. Each
spreadsheet contains slightly different information and 80% of the
properties in spreadsheet_01 also appear spreadsheet_02. ...

I have 9 digits in form of "111020402". Then I have another 9 digits
in form of "111020403". I have 100,000 records of these two 9-digit
numbers.
I want to filter this as follows:

I built a nifty little SPAM killer with Access linking into Outlook
while I was at work the other day (boring day, loads of time to
kill...) but now I'd like to use it at home where we use Outlook
Express.

I use Access 2007 and have the following problems: when exporting
banal select queries (either to Excel or to a csv file) I find that
exporting often doesn't work and creates a file with the WHOLE
dataset, i.e. including those rows which the criteria of the query

hello cdma enthusiasts.  long time no speak.  i have an .adp which is
connected to a sql 2k back end from which i need to export a table to
a tab delimited text file.  the export text wizard apparently doesn't
allow you to store export specs (makes sense since it has no local

I am trying to develop a simple and efficient to calculate averages. For
example I want to calculate the averages of the Values for rows 1 and 2
and use ID 1 as the row with the average result.
Table Exmple

I need some help, and im not very good at this.
I have a Yes/No field and i need to make access 2003 write DONE i a tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

After changing all the variables in a table from long to double.
you get 9.1====becomes==== 9.19999980926514
ok I checked microsoft and they had a workaround.
export the values to excel...then import them back into the new table.

Dear reader,
In a Make-Table query the TickBox from the master table transfers in to a
binary value in the new table.
How can I force the Make-table query to keep the TickBox in the new table as

I would like to lookup a value (entered in cell D1) in the table
below. For example if it were between 0 and 2 it would return R1, if
it were between 3 and 5 it would return R2, etc.
(starting in column A1)

I am in the midst of trying to convert about 25 Access 2000 to Access 2003.
The new environment consists of Office/Access 2003 and Outlook 2003. When
converting the back ends I have no problems. When converting the front ends
I get the following issues and error. If I try to ...

I have a database which stores information about certain products.
The products (tblProducts) are made up of product contents
(tblProductContents). The product contents may be used in one or more
products. So tblProducts is on the one side of a one to many with

I have meet a problem for CreateObject("Scripting.FileSystemObject").
I uses this code to get the information of the harddisk
I have 10 user using the same code. All where working fine excpet for 1. When
i was using it prompt this error:

Could anyone tell me how to restrict the date range for items that
appear on a report? Old items from previous years appear on the
report. I was asked to have only this year's items (and beyond) listed
on the report. How do I do that?