Saving Public Variable

[Guest]

I have set up a Public Variable in a module called trees like this

Public Book As String

That I use at various times on different forms during the use of the
database to store a piece of text the user as input earlier.
Is there a way that I can save it so that the next time I open up the
database it is still using the same piece of text without putting it into a
table?

David

 

[pietlinden]

I have set up a Public Variable in a module called trees like this

Public Book As String

That I use at various times on different forms during the use of the
database to store a piece of text the user as input earlier.
Is there a way that I can save it so that the next time I open up the
database it is still using the same piece of text without putting it into a
table?

David

No. your only other option, AFAIK, is to use a custom property, which
is essentially a table with a single entry. And then you need DAO to
get to it

 

[Granny Spitz via AccessMonster.com]

Is there a way that I can save it so that the next time I open up the
database it is still using the same piece of text without putting it into a
table?

You can create a custom database property and save the text to this property
when the user inputs it. Have a startup form's code read the property and
set the Book variable while initializing your app.

 

[Guest]

In addition to a custom property, you could write the text to a .ini file, or
even write the value to the registry using the GetSetting / SaveSetting
methods:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_tentipsvba.asp

or using a more advanced method:

How To Use the Registry API to Save and Retrieve Setting
http://support.microsoft.com/kb/145679


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

How do I call that custom database property in vbscript?

 

[Granny Spitz via AccessMonster.com]

How do I call that custom database property in vbscript?

Access doesn't use VB Script, hon. It uses VBA, Visual Basic for
Applications. You need to create the custom database property first like
this:

Set prp = CurrentDb.CreateProperty("Secret", dbText, "Area51", False)
CurrentDb.Properties.Append prp

Later, when you need to set the property:

CurrentDb.Properties("Secret") = "UFO Landing Zone"

When you need to read the property:

var = CurrentDb.Properties("Secret")

 

[Guest]

Thanks.
And thanks for clearing up the VBA thing for me. I'm still quite new.

David

 

[Granny Spitz via AccessMonster.com]

Thanks.
And thanks for clearing up the VBA thing for me.

You're welcome, David.

I'm still quite new.

Then the hardest part is still in front of you. <g> But we'll help if you
ask.