If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#51
|
|||
|
|||
Best Practice for tables?
"Gina Whipp" wrote:
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. 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/ |
#52
|
|||
|
|||
Best Practice for tables?
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]" wrote in message ... "Gina Whipp" wrote: 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. 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/ |
#53
|
|||
|
|||
Best Practice for tables?
"Gina Whipp" wrote:
Okie dokie now... I didn't know THAT! Thanks. Blogged. http://msmvps.com/blogs/access/archi...03-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/ |
#54
|
|||
|
|||
Best Practice for tables?
"Tony Toews [MVP]" schreef in bericht ... 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 |
#55
|
|||
|
|||
Best Practice for tables?
"Arno R" wrote:
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/ |
#56
|
|||
|
|||
Best Practice for tables?
"Tony Toews [MVP]" wrote in
: "Steve" wrote: Repeatedly MVPs advise posters not to use spaces in object names and here you are going against "learned" advise and putting spaces in query names???? 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 http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#57
|
|||
|
|||
Best Practice for tables?
"Tony Toews [MVP]" wrote in
: "David W. Fenton" wrote: Now I have a much larger system with 160 tables, 1200 queries, 450 forms and 350 reports. But that would be rather long for folks to look at the names. 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? 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()? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#58
|
|||
|
|||
Best Practice for tables?
"David W. Fenton" wrote in message
. 1... "Tony Toews [MVP]" wrote in : Now I have a much larger system with 160 tables, 1200 queries, 450 forms and 350 reports. But that would be rather long for folks to look at the names. 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#59
|
|||
|
|||
Best Practice for tables?
"David W. Fenton" wrote:
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()? 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/ |
#60
|
|||
|
|||
Best Practice for tables?
"David W. Fenton" wrote:
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/ |
Thread Tools | |
Display Modes | |
|
|