I am designing a database that shall store some hundred thousand rows of
data.
I want to use the graphic facilities in Excel to create an XY-diagram with
10 simultaneous curves. When I tried to create such a diagram in Access the

I have a list view that I would like to change the data of a cell by
celecting the cell.
This is what I have, but it always return me column 0
Public Function GetRowColumn(ByVal Item As MSComctlLib.ListItem) As String

from some other post I have read that textbox value can be changed throught
the format event of a report section.
If this is true, why this code wont work?
<code>

Hello, need some assistance. I have this access database where it grabs raw
data from an oracle database and user will
upload file onto my database. Now this database will take that raw data and
spit out several excel sheets, depending on

I am writing a procedure to import text files to tables in the database.
Tables in the db have neames like Routes, tblFirm, etc..
The export function I wrote appends the current table name to include the
UserName and an underscore to the front of the table name: i.e.

For a long time, I have been trying to overcome a problem in access and can
not find help on it. It is becoming a serious issue for my client and I am
not able to find a way around. I have a db in Access 97 for a translation
company. you can imagine that a translation company ...

I get a zero and a blank when I write err.number and err.description into my
error MsgBox.
If I write error$ I get a message with no number.
There wa a similar question posted on 11/21 and I tried the suggested

Any clever ideas on licensing/enforcing concurrent users for Access apps I
distribute? How about this:
Have a table in the BE that has a LicenseID field (or, better yet, embed the
license in a custom DB property)

I'm using Access 2003. I have a very simple data base that several user will
need to use. The database is on a file server and a few user will access this
database.
Basically I need to increment a number (+1, starttng at 500) everytime a

I have an excel template that I transfer data to from an access query. Once I
have done this I would like from within Access to save the excel template as
a new excel workbook (new path and filename each time it is run). The
template has 3 worksheets to be saved/copied to the new ...

I have a main form and subform. Subform is continious and mainly for data
entry. Is there a way to move cursor verticaly in the subform (like with
"down" key) with tab. People find it much easier with data-entry. So we'd
start with first record in subform - move down on tab until ...

I have Acrobat PDFWriter installed in my system.  I used the following code
to print my reports in PDF format.  When I ran the code, it produced the
first report with no problem.  Then, it poped up a window and waited for the
response and the file name was not what I expected.  ...

I am trying to create a input mask for currency, what I would like it to do
is when I type 1234567, I would like the input mask to place the "$" in front
automatically and also the decimal place so it looks like this $12,345.67,
I also would like the field to be empty until I ...

I have a small database in Access 2002 which records commission payments
made to a loan broker.
The following query searches for any months that a commission payment
was not received for a particular Loan number. In this case Loan number 1.

Is DAO 3.6 supplied with MDAC 2.8 ? (even though it is not supported).
Thanks