Re: Best Practice for tables?

"Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx> wrote:

(tblCountry) - holds the Country names
(tblDispatchMethod) - the service the item is sent by
(tblSupplier) - who the item is mailed by

Don't bother with the tbl prefix. Basically it's a waste of time.

Another thing I came across that I instinctively do. When adding a
query while in the Query Builder I just hit the first letter of the
name of the query and zoom I'm there. No need to scroll, scroll,
scroll.

This works in all kinds of Access wizard type of list boxes.

Now what I could also do is resize the query window and drag and drop
from the database container window but that's a bit more awkward for
me.

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/
.

Relevant Pages

  • Re: Non-updateable query issue
    ... Microsoft Access MVP ... When putting together that query, ... "Duane Hookom" wrote: ... Say Fred deletes record 79 from Table1, ...
    (microsoft.public.access.queries)
  • Re: Parameters Question
    ... which is going against a Microsoft Access 2003 Northwinds database. ... Suppose user2 wanted to only query for a contact name of 'Aria Cruz' ... > his SQL string. ... >> Access 2003 database than it would be for SQL Server using OleDB. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: INSERT INTO Query Question
    ... query I get the following response: "Microsoft Access can't append all the ... records in the append query. ... the following error message as I attempt to run an append query: ... FROM [prospect list]; ...
    (microsoft.public.access.queries)
  • Re: Creating Forms from Update Queries
    ... Access forms and controls look, feel and work just like Windows ones - as a ... If you want to use a form, just create one, basing it on the query of your ... Microsoft Access 2003 VBA Programmer's Reference ...
    (microsoft.public.access.forms)
  • Re: Performance Tanks after Splitting Database
    ... or quickly scroll through a long list of "projects" to choose from, ... query that only included the fields I need for the "index"? ... Are you saying that your form loads all 3500 records? ... Another approach is to add a combobox in the header of the form. ...
    (microsoft.public.access.gettingstarted)