Question about a default table or method

[John Marshall, MVP]

Steve is upset with me because I keep reminding him that these newsgroups
are for free support. The only reason he tries to answer questions is to
provide an excuse to solicit business. These newsgroups are provided by
Microsoft as a means for users to obtain free support from each other. steve
santos (AKA PCD) assumes that they were provided so that he could solicit
work.

You originally asked for "a variable that will last for a session." Global
variables will do this, but there are caveats.
1) Anything classified as data should be in a table
2) The information may be volatile and the variable may get out of sync with
the table.


John... Visio MVP

 

[Joe Cilinceon]

Thanks Allen a touch more than I need since this is a single location
application. I will however look at your approach and do appreciate it.

 

[John Marshall, MVP]

I guess as a failed gas station attendant, you did not excel at reading. Joe
originally asked for "a variable that will last for a session.". Global
variables will do this, but there are caveats as I mentioned..

John... Visio MVP

 

[peregenem]

"miscellaneous" Table has worked well for me, too.

A single row table of constants is a standard SQL trick which works
well. Of course you have to ensure it never contains more than one row
e.g.

CREATE TABLE Constants (
lock CHAR(1) DEFAULT 'x' NOT NULL PRIMARY KEY,
CHECK (lock = 'x'),
other columns...
);

 

[Joe Cilinceon]

I guess as a failed gas station attendant, you did not excel at
reading. Joe originally asked for "a variable that will last for a
session.". Global variables will do this, but there are caveats as I
mentioned..
John... Visio MVP

Actually John I asked for the best method to set default values in an
application, be it as a public variable or Lookup Table. I didn't know and
really still don't know which method will work best for my needs. I gotten 2
different methods of doing what I want and will try both before deciding. It
really amounts to about 5 or 6 default values, such as sales tax rate, late
fee charges, lock cut fee, admin fee, lien fee and nsf check fee. I use
these charges thru out the application for calculations and it would be nice
not to have to rewrite these values in code every time they change. I hope
that is clearer.

 

[John Marshall, MVP]

I would go with tina's suggestion. It places anything that may change over
time in a single location and avoids the problem of using duplicate
information that may get out of sync.

John... Visio MVP

 

[Ken Snell [MVP]]

I concur. These types of data are best kept in a table. That also allows use
of a form for the updating of the values very easily.

 

[PC Datasheet]

Joe,

Another point that you might consider ---

Your case is a good example of storing a calculated value rather than
calculating it on the fly. Say you have ExtendedCost = Cost * Sales Tax
Rate. Since Sales Tax Rate will vary, it would make things simpler to store
ExtendedCost each time rather than calculate it on the fly.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

 

[PC Datasheet]

Dimwit,

Ask your mother to read Joe's response to you. Dimwit keeps getting dimmer.

 

[Joe Cilinceon]

If I'm following what you are saying here, I think I already do that. I
store amount paid, charges covered and in some cases the rate things cost at
that time. I also have several functions I use in place of doing it over and
over again such as getting the last day of a month etc.

 

[John Marshall, MVP]

You really are hopeless. He did say "a variable that will last for a
session."

John... Visio MVP

 

[PC Datasheet]

Did your mother read this to you?

What is the best way to have defaults in one location but available to the
whole application. Some examples would be Sales Tax rate, Late Fee charge in
addition to things like scanners/printers or other things used with in the
program.

--

Joe Cilinceon

Joe told you that that's NOT what he said!! You must have gotten the
engineering degrees you claim you have out of a crackerjax box because you
can't read!!! Or did your mother read all your school work to you? Whatever
school(s) you claim you got engineering degrees from certainly were not
prestigious since they apparently admitted illiterates!!!

 

[John Marshall, MVP]

Now your signing with Joe's name?

Joe's original message is at the bottom of this message, try reading it
again.

John... Visio MVP

 

[StopThisAdvertising]

Now your signing with Joe's name?

Joe's original message is at the bottom of this message, try reading it
again.

Hi John,

I think we *are* succeeding driving Steve *very* nuts ... ;-)

I am almost starting to feel pity for him. Sad individual that is.
I see *no* support left for him except sometimes his own 'creatures' ??

He definitely needs outside help, from a *real* resource, don't you think?

Arno R

 

[PC Datasheet]

Here it is, Dimwit, from the bottom of this message just as I previously
copied it in my response to your dimwittedness. And no I am not signing
Joe's name. That's Joe's signature on his post you dimwit. Can't your mother
read either?

Get someone to read this to you because apparently no one in your family can
read!!!!!!!!

You must have faked something to get an MVP. They certainly would not make
an illiterate an MVP!!!

Is this why you don't answer questioons in the newsgroups because you can't
read?

 

[John Marshall, MVP]

Sorry steve, I'm not going to play your childish games. You can name call as
much as you want, but I'll just stick to the facts. He does say "available
to the whole application".

John... Visio MVP

 

[John Marshall, MVP]

I'm not trying to drive him crazy, just trying to get him to respect the
newsgroups spirit of FREE cooperation.

John... Visio MVP


Hi John,

I think we *are* succeeding driving Steve *very* nuts ... ;-)

I am almost starting to feel pity for him. Sad individual that is.
I see *no* support left for him except sometimes his own 'creatures' ??

He definitely needs outside help, from a *real* resource, don't you think?

Arno R

 

[PC Datasheet]

You're the dimmest of the dimwits!!!

You previously said over and over ---
You really are hopeless. He did say "a variable that will last for a
session."

John... Visio MVP

and now you say ----
He does say "available to the whole application".

Did you finally get someone to read to you?

You make no useful contributions to the newsgroup and all you do is pollute
the newsgroups with your prevarications (that's lies, dimwit).

 

[PC Datasheet]

And by the way, dimwit, Joe told you he did not say "a variable that will
last for a session" and you still like a dimwit kept insisting he said that.