MS Access, Persistent non-db data

Persistent non-db data

Author	Message
Bryo #1 / 3	Persistent non-db data Is there a way in Access to store persistent option variables that aren't part of the database? (I suppose you could kludge them into a database, but it would be unnatural). For example, in Excel you have Names that can be used. Is there any other such thing in Access? One of the things I want to do is save a mode on exit. Let's say there's three usage modes to a form that a user can select. Right now, I open with a default, and the user changes if desired. Is there a way to store the option so that it reopens next time in the same mode as closed so the user doesn't have to make the same selection each time? Using Access 2002... Thanks, Bryon
Mon, 29 Aug 2005 10:29:33 GMT

Sandra Daigl #2 / 3	Persistent non-db data You could create custom database properties and which you can update as needed: 'Create property (only once, initialized to 10) CurrentDb.Properties.Append CurrentDb.CreateProperty("MyProperty", dbLong, 10) ' Use the property lngX= CurrentDb.Properties("MyProperty") 'change the property value CurrentDb.Properties("MyProperty")=12 ' assign it to a new value -- Sandra Daigle [Microsoft Access MVP] For the benefit of others please post all replies to this newsgroup. Quote: > Is there a way in Access to store persistent option > variables that aren't part of the database? (I suppose > you could kludge them into a database, but it would be > unnatural). For example, in Excel you have Names that can > be used. Is there any other such thing in Access? > One of the things I want to do is save a mode on exit. > Let's say there's three usage modes to a form that a user > can select. Right now, I open with a default, and the > user changes if desired. Is there a way to store the > option so that it reopens next time in the same mode as > closed so the user doesn't have to make the same > selection each time? > Using Access 2002... > Thanks, > Bryon
Mon, 29 Aug 2005 12:40:07 GMT

Bryo #3 / 3	Persistent non-db data Ah!! Very cool. I'll pursue that. Thanks a million! Bryon Quote: >-----Original Message----- >You could create custom database properties and which you can update as >needed: >'Create property (only once, initialized to 10) >CurrentDb.Properties.Append CurrentDb.CreateProperty ("MyProperty", dbLong, Quote: >10) >' Use the property >lngX= CurrentDb.Properties("MyProperty") >'change the property value >CurrentDb.Properties("MyProperty")=12 ' assign it to a new value >-- >Sandra Daigle >[Microsoft Access MVP] >For the benefit of others please post all replies to this newsgroup. >> Is there a way in Access to store persistent option >> variables that aren't part of the database? (I suppose >> you could kludge them into a database, but it would be >> unnatural). For example, in Excel you have Names that can >> be used. Is there any other such thing in Access? >> One of the things I want to do is save a mode on exit. >> Let's say there's three usage modes to a form that a user >> can select. Right now, I open with a default, and the >> user changes if desired. Is there a way to store the >> option so that it reopens next time in the same mode as >> closed so the user doesn't have to make the same >> selection each time? >> Using Access 2002... >> Thanks, >> Bryon >.
Mon, 29 Aug 2005 15:25:03 GMT

Page 1 of 1

[ 3 post ]