Best Practice for tables?

[Tony Toews [MVP]]

David,

Tony said in his post just above that you "...gets a slight bit snarky..."

What does "snarky" mean?

Steve

We're attempting to have a polite discussion here.

Move that kind of cr*p to another thread.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Douglas J. Steele]

A little too complicated for you, is it Steve?

The two statements are consistent with one another.

"Most of the time we agree" implies that some times we have a difference of
opinion.

"I hold a contrary opinion to most on this topic" implies that this is one
of the times that there is a difference of opinion.

I guess they must not have taught English at your engineering school.

 

[Tony Toews [MVP]]

You said elsewhere --
<<And I hold a contrary opinion to most on this topic. As I do others. So
my attitude varies somewhere between tough and who cares.>>

You said here in reference to MVPs--
<<Most of the time we agree.>>

Which is the true answer; number 1 or number 2?

Depends.

Two different question, two different answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

BTW Tony you always give

Responded to in a thread titled Question by Steve.

This has been a quite nice discussion so far so let's move your off
topic questions elsewhere.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Gina Whipp]

But if you read one of my other postings extra key strokes aren't a

problem for me.

I read that AFTER I typed my reply.

 

[Gina Whipp]

In my opinion it's much, much easier to work with the parent

form/report and the sub form/sub report next to each other in the
database container window.

I never thought of it like that... However, I use the description in the
container window to associate the forms with the subform, which may also
include the query, module, etc... that it is attached to.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Tony Toews [MVP]]

I read that AFTER I typed my reply.

<smile> I've done that myself occasionally.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I never thought of it like that... However, I use the description in the
container window to associate the forms with the subform, which may also
include the query, module, etc... that it is attached to.

Now I never look at the description and the dates as I have the list
view set. I want as many objects as possible on my screen.

Interesting how we, or in this case, I've been doing certain things in
certain ways that I have to start going back and explaining why doing
other things facilitates this thing.

If you get my drift.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Gina Whipp]

If you get my drift.

Yes I do...

In my case I find it interesting, the people I get to help me from time to
time have no choice but to do it my way. So anytime I get to have a
discussion about different ways helps me to understand/learn why other
programmers choose another way and perhaps enlighten me to a technique I
never considered.

 

[Tony Toews [MVP]]

Yes I do...

In my case I find it interesting, the people I get to help me from time to
time have no choice but to do it my way. So anytime I get to have a
discussion about different ways helps me to understand/learn why other
programmers choose another way and perhaps enlighten me to a technique I
never considered.

Yup, always interesting to get some tips. For example, I once whined
about how sometimes Alt+Tabbing from VBA code window to form view in
A2003 only got up the property sheet. Someone responded that, umm,
was it Alt+F11 would work.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Gina Whipp]

Okie dokie now... I didn't know THAT!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Tony Toews [MVP]]

Okie dokie now... I didn't know THAT!

Thanks. Blogged.
http://msmvps.com/blogs/access/arch...bbing-from-vba-ide-to-access-2003-window.aspx

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Arno R]

In my opinion it's much, much easier to work with the parent
form/report and the sub form/sub report next to each other in the
database container window.

But then I routinely work with databases with hundreds of objects.

Hmmm, quite a 'discussion' here with Steve ;-)

Yep, I do the very same here.
FrmCustomers
FrmCustomers_sub

Regarding queries:
Sometimes I use a couple of 'sequential' queries to perform a certain job.
I name them so that they will be grouped in the container
qryInvoice_1
qryInvoice_2
qryInvoice_3
(The underscore here is important to distinct from duplicates created 'behind my back' when importing from other db's)

Arno R

 

[Tony Toews [MVP]]

Yep, I do the very same here.
FrmCustomers
FrmCustomers_sub

Whereas I would use

Customers
Customers - Payments sbf
Customers - Notes sbf
Customers - Invoices sbf
etc, etc.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

Correct.

I view myself as one of the "learned" advisors.

That means you don't often (or ever) use virtual tables. I couldn't
code one day in Access without writing SQL with at least one virtual
table, and queries with spaces in the names make that completely
impossible. You could get the same effect with the underscore
character.

 

[David W. Fenton]

Look at the object names. Queries have spaces in them and are
longer. Tables don't.

Huh. I didn't notice.

How do you process a list of tables and queries in code, then? Do
you use InStr()?

 

[Rick Brandt]

But querydefs and tabledefs have a shared namespace, i.e., you can't
have an object of the same name in both collections, and the Access
UI in some contexts presents a combined list of both. In a large
project, how do you tell which is which in those lists?

Speaking for myself I have never looked at a list of queries and tables where I
did not already know the name of the item I was looking for. How else would I
know which one to select? That being the case, I already know whether it's a
query or table.

I just fail to see where this is an issue.

 

[Tony Toews [MVP]]

Huh. I didn't notice.

How do you process a list of tables and queries in code, then? Do
you use InStr()?

Why would I need to?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

That means you don't often (or ever) use virtual tables. I couldn't
code one day in Access without writing SQL with at least one virtual
table, and queries with spaces in the names make that completely
impossible. You could get the same effect with the underscore
character.

What do you mean by "virtual table"?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Grover Park George]

Almost the first thing I learned from one of my earliest Access
mentors was the "rename/copy" trick to ensure that I got the right
spelling of an object name to use elsewhere. It's become second nature
to the point where, even if I know the object name, I usually do the
rename/copy method almost out of habit.

My own naming conventions are quite traditional. I use three character
prefixes for tables, queries and reports and suffix ID for key fields.
However, I strongly believe the only crucial convention is
consistency.

George Hepworth, MS Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.