ADP & MDB Diferences

[scott]

I recently created my first ADP application and I'm converting my old MDB
forms, reports so they can run in my ADP project.

In my MDB app, I used the below code on the "Form Open" event to change the
title bar, but I get an error when I try to run it in my ADP project saying
"Sub or Function not defined".

I have the same reference libraries loaded, what am I doing wrong?


CODE **************

Me.Caption = CurrentDb().Properties("AppTitle") & ": " & PrintDay(Date)

 

[Dirk Goldgar]

I recently created my first ADP application and I'm converting my old
MDB forms, reports so they can run in my ADP project.

In my MDB app, I used the below code on the "Form Open" event to
change the title bar, but I get an error when I try to run it in my
ADP project saying "Sub or Function not defined".

I have the same reference libraries loaded, what am I doing wrong?


CODE **************

Me.Caption = CurrentDb().Properties("AppTitle") & ": " &
PrintDay(Date)

CurrentDb refers to the current Jet database. In an ADP, there is no
such database. For your purposes, you should change to

Me.Caption = CurrentProject.Properties("AppTitle") & ": " &
PrintDay(Date)