setting page

[johnob]

Hi all,

Is There Anyway to Make a Settings Page in accrss , so that i can put in data that changes 1 or 2 times a year, but affects loads of formulas

thanks

john

 

[CJ_London]

yes - create a one record table with all the variables you require and base a form on that.

When used in queries, bring the table in - it does not need to be linked to any other table because it is only one record so will not cause duplicates etc.

 

[Old Man Devin]

You could also try adding custom database properties that could be used as the record source for a 'Settings Menu' form, which is a bit clunkier but stops you needed a dedicated table.