Re: Startup Question based on date

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 00:22:38 -0500

Assuming that you upgraded from ACCESS 97, then you need to set a reference
to DAO library in your ACCESS 2002 database. In Visual Basic Editor window,
click Tools | References and select Microsoft Data Access Objects (DAO) v3.x
from the list. 

-- 
        Ken Snell
<MS ACCESS MVP>
"Stephen Lynch" <raider1raider@yahoo.com> wrote in message 
news:RfUQd.80787$bu.52468@fed1read06...
> Upgraded access to 2002 and I cannot get this to work.  Basically I have 
> about 10 queries that run when I first open my database so, I wrote this 
> to check the date that I updated the table and if it is today then 
> maximize the startup form and not run all of the queries. I open the 
> database multiple times a day and do not want to wait for the queries to 
> rerun.
>
> Can anyone help me. I search and I think that now it support ado and this 
> is dao or something like that.
>
> Here's what use to work:
>
> If Format(DBEngine(0)(0).TableDefs("MasterHoldings").Properties(2), "Short 
> Date") = Format(Now(), "Short Date") Then
>    DoCmd.Maximize
>    Else
>
> Run my queries
>
> Thanks in advance
>
> Steve
>

Relevant Pages

  • Re: Run action query in back-end from front-end database
    ... whatnot in the back end database. ... The queries are housed in the back end ... The reason I have the upload tables in the back end is that it will be on ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ...
    (microsoft.public.access.externaldata)
  • Re: My switchboards wont work with WinXP !
    ... > You do not have a reference set to the ADO object library in this ... > unless of course you have ADO code in your database, ... > The Switchboard form that the wizard made for you uses ADO code ... I did not say to close the database after unchecking DAO. ...
    (microsoft.public.access.forms)
  • Re: Run action query in back-end from front-end database
    ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ... With any code module open, select Tools | References from the menu bar, ... consider putting them in a temporary database. ... The reason I have many queries in the back end database is because it does ...
    (microsoft.public.access.externaldata)
  • Re: Do I need to reinstall?
    ... dbOpenDynaset and the Database object are DAO objects. ... you should either remove ADO or explicitly reference you object model: ...
    (microsoft.public.access.reports)
  • Re: Acc2003 Code will not compile
    ... and including Access 97 included a DAO reference by default in new MDBs. ... Access 2000 and Access 2002 don't include that reference by default. ... > Tried to compile in another Acc2000 database for first time in Acc2003, ...
    (microsoft.public.access.modulesdaovba)
Quantcast