[AccessD] How to import row number from Excel Sheet ???

Michael R Mattys mmattys at rochester.rr.com
Thu Mar 1 12:07:56 CST 2007


The problem is most likely disambiguation;

use dbs As DAO.Database, rst As DAO.Recordset, etc

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, March 01, 2007 11:09 AM
Subject: Re: [AccessD] How to import row number from Excel Sheet ???


> Hello All,
>
> I have an A97 db that users run reports out of...number of different
> machines...same db.  New machine won't run of compile...errors on "Set
> dbs=CurrentDB".  Error says restricted word or function or uses Automation
> not available in Visual Basic.  The only difference I can see is the new
> machine has a reference to DAO3.6 and the other machines have a DAO3.51 
> and
> I can't set a reference to 3.5 on the new machine.
>
> Any ideas?
>
> Thanks,
>
> Mark A. Matte
>
> _________________________________________________________________
> Win a ZuneT-make MSN® your homepage for your chance to win!
> http://homepage.msn.com/zune?icid=hmetagline
>
>


--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list