HI All,

Is it possible to populate a cell from a cell (if that’s what it’s
called) in an Access file?

The access file is called qcpProg.mdb in a directory level one above
the excel file.

The data is in the tProduct table, UnitCost field (currency), with the
Product Code field (text) that is equal to Joseph4.

It would save me a lot of manual updates if I could do this.

Thanks!

Michele

Hi Michele,

In excel 2000, I use Data Get External Data New Database query.

Would that work in your case?

Dan

"mjones" wrote in message
...

It says 'record(s) cannot be read; no read permission on tProduct.'


....then you likely have some different type of security set up in Access.
I'm not a big Access user, so I can't offer much help there.

You could try some of the other connection string listed here for Access:
http://www.connectionstrings.com/access
Look at the strings for "Microsoft Jet OLE DB 4.0" The one I used was
"With database password".

Tim

On Feb 10, 10:49*pm, "Tim Williams" wrote:
"mjones" wrote in message

...

It says 'record(s) cannot be read; no read permission on tProduct.'

...then you likely have some different type of security set up in Access.
I'm not a big Access user, so I can't offer much help there.

You could try some of the other connection string listed here for Access:http://www.connectionstrings.com/access
Look at the strings for "Microsoft Jet OLE DB 4.0" * The one I used was
"With database password".

Tim

Wow, this is frustrating. I tried some of the options on Tim's link,
but I'm not skilled enough to understand what to do. There is a user
(michele) and a workgroup system file (qcpSystem.mdw in the same
folder as the access database). Can anyone help with the updated code
to add this information?

I had a third friend look at it (an Access programmer) and she didn't
know what the problem was either.

Is Option Explicit supposed to be at the top of the module?

I tried copying the code into a blank spreadsheet. Same thing. Sign.

Thanks again everyone and anyone who can help,

Michele

"mjones" wrote in message
...
Yeah, yeah!!! It works!! Yeah, yeah!!
Thanks a bunch!!


At last! Good to hear.

Tim

On Feb 13, 12:16*am, "Tim Williams" wrote:
"mjones" wrote in message

...

Yeah, yeah!!! *It works!! *Yeah, yeah!!
Thanks a bunch!!

At last! *Good to hear.

Tim

Hi Tim,

I hate to bug you again, but is there a way to make the GetUnitCost
keep the format of the cell it's in, or at least format it to a number
or currency with 2 decimal places? Some of the costs are coming out
with 4 decimal places.

Thanks again,

Michele

Sorry - a formula can't directly impose any formatting on the cell which
contains it: it can only return a value.

You'll need to format the cell the usual way.

Tim



"mjones" wrote in message
...
On Feb 13, 12:16 am, "Tim Williams" wrote:
"mjones" wrote in message

...

Yeah, yeah!!! It works!! Yeah, yeah!!
Thanks a bunch!!

At last! Good to hear.

Tim

Hi Tim,

I hate to bug you again, but is there a way to make the GetUnitCost
keep the format of the cell it's in, or at least format it to a number
or currency with 2 decimal places? Some of the costs are coming out
with 4 decimal places.

Thanks again,

Michele

On Feb 15, 8:51*pm, "Tim Williams" wrote:
Sorry - a formula can't directly impose any formatting on the cell which
contains it: it can only return a value.

You'll need to format the cell the usual way.

Tim

"mjones" wrote in message

...
On Feb 13, 12:16 am, "Tim Williams" wrote:

"mjones" wrote in message

....

Yeah, yeah!!! It works!! Yeah, yeah!!
Thanks a bunch!!

At last! Good to hear.

Tim

Hi Tim,

I hate to bug you again, but is there a way to make the GetUnitCost
keep the format of the cell it's in, or at least format it to a number
or currency with 2 decimal places? *Some of the costs are coming out
with 4 decimal places.

Thanks again,

Michele

Naturally, I thought to format the cell directly in the spreadsheet,
i.e. Format Cells Number with 2 decimal places, but it just ignors
the format. The values shown look like 15.2263 where some have 2
decimal places, others 3, etc.

Tim, your code is great and I've found another good use for it except
this time, I've getting a few duplicates in the ProductCode field. A
tie breaker is needed. Can I adjust he code to say select Referrer
from tClient where LName and FnameF. In other words, could I say in
the cell =GetUnitCost(A1) except have two values like (A1,A2)?

Thanks again!!