Application title

  • Thread starter Thread starter George R
  • Start date Start date
G

George R

I use this entry in the data source for an unbound text box on a form in
Access 2003: =[CurrentDB].[Properties]("AppTitle") and it works fine.
When I try to do the same in Access 2007 I get the ?Name response. The
application title does exist in the 2007 version. Also, when I type
?[CurrentDB].[Properties]("AppTitle") in the 2007 immediate window the
correct title is returned.
Is there a way to do this in Access 2007?
Thank you for your consideration.
 
To be honest, I'm surprised it works in Access 2003. I would have expected
that you'd need the following:

=CurrentDB().[Properties]("AppTitle")

Unfortunately, I don't have Access 2007 installed on this machine (nor
Access 2003, for that matter), so I can't test.

And of course that will fail if the AppTitle property hasn't been explicitly
set.
 
I cannot make your suggested entry work in either 2003 or 2007. An error
message appears as soon as it is entered the data source. The error says the
expression you entered has an invalid dot or bang or parentheses.

Doug Steele said:
To be honest, I'm surprised it works in Access 2003. I would have expected
that you'd need the following:

=CurrentDB().[Properties]("AppTitle")

Unfortunately, I don't have Access 2007 installed on this machine (nor
Access 2003, for that matter), so I can't test.

And of course that will fail if the AppTitle property hasn't been explicitly
set.

--
Doug Steele, Microsoft Access MVP



George R said:
I use this entry in the data source for an unbound text box on a form in
Access 2003: =[CurrentDB].[Properties]("AppTitle") and it works fine.
When I try to do the same in Access 2007 I get the ?Name response. The
application title does exist in the 2007 version. Also, when I type
?[CurrentDB].[Properties]("AppTitle") in the 2007 immediate window the
correct title is returned.
Is there a way to do this in Access 2007?
Thank you for your consideration.
Click to expand...
Click to expand...
 
Sorry, I made one correct but not the other.

=CurrentDB().Properties("AppTitle")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


George R said:
I cannot make your suggested entry work in either 2003 or 2007. An error
message appears as soon as it is entered the data source. The error says
the
expression you entered has an invalid dot or bang or parentheses.

Doug Steele said:
To be honest, I'm surprised it works in Access 2003. I would have
expected
that you'd need the following:

=CurrentDB().[Properties]("AppTitle")

Unfortunately, I don't have Access 2007 installed on this machine (nor
Access 2003, for that matter), so I can't test.

And of course that will fail if the AppTitle property hasn't been
explicitly
set.

--
Doug Steele, Microsoft Access MVP



George R said:
I use this entry in the data source for an unbound text box on a form
in
Access 2003: =[CurrentDB].[Properties]("AppTitle") and it works fine.
When I try to do the same in Access 2007 I get the ?Name response. The
application title does exist in the 2007 version. Also, when I type
?[CurrentDB].[Properties]("AppTitle") in the 2007 immediate window the
correct title is returned.
Is there a way to do this in Access 2007?
Thank you for your consideration.
Click to expand...
Click to expand...
Click to expand...
 
Sorry, but that doesn't work either (in 2003 or 2007). The only thing I can
make work is =[CurrentDB].[Properties]("AppTitle") and that only works on
Access 2003. Any other ideas on how to make it work in 2007?

Douglas J. Steele said:
Sorry, I made one correct but not the other.

=CurrentDB().Properties("AppTitle")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


George R said:
I cannot make your suggested entry work in either 2003 or 2007. An error
message appears as soon as it is entered the data source. The error says
the
expression you entered has an invalid dot or bang or parentheses.

Doug Steele said:
To be honest, I'm surprised it works in Access 2003. I would have
expected
that you'd need the following:

=CurrentDB().[Properties]("AppTitle")

Unfortunately, I don't have Access 2007 installed on this machine (nor
Access 2003, for that matter), so I can't test.

And of course that will fail if the AppTitle property hasn't been
explicitly
set.

--
Doug Steele, Microsoft Access MVP



:

I use this entry in the data source for an unbound text box on a form
in
Access 2003: =[CurrentDB].[Properties]("AppTitle") and it works fine.
When I try to do the same in Access 2007 I get the ?Name response. The
application title does exist in the 2007 version. Also, when I type
?[CurrentDB].[Properties]("AppTitle") in the 2007 immediate window the
correct title is returned.
Is there a way to do this in Access 2007?
Thank you for your consideration.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top