Re: Microsoft Access, Double Data Entry and breaking the Normalization rule

"hippomedon@xxxxxxxxxxxxxx" <hippomedon@xxxxxxxxxxxxxx> wrote in
news:1180558157.618085.168340@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

Interesting question. For me, it's always finding a balance
between
having a variable name that is short and easy to type (for queries
and VBA code) and having one that is too short to be recognizable.

Intellisense removes the need for most of the typing.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Sources for query parameters
    ... usually the ones that already run some VBA code. ... document variables and custom document properties. ... That could get quite slow in large queries. ... Then use that function in your query. ...
    (microsoft.public.access.queries)
  • Re: can I do an inline select case statement? syntax ?
    ... It only requires the correct join in your queries. ... > The vba code is referencing table that contains this statement. ... >> and select the second field for display. ... >> be a programmer to make modifications. ...
    (microsoft.public.access.gettingstarted)
  • Re: performance: query vs. class module
    ... efficient than using VBA code to do the same thing. ... > Are queries or class modules drastically diferent when it comes to the ... > want where trying to use queries is causing me more problems. ... > orders form is very similar to an application i'm trying to create). ...
    (microsoft.public.access.queries)
  • Re: compare data in identical tables
    ... I need a query or some VBA code, ... You may need a few queries, not just one, because of the utterly unreasonable ... Is there a Primary Key ...
    (microsoft.public.access.gettingstarted)
  • Re: OpenReport using WHERE criteria for nested queries
    ... works in queries (and in expressions that are evaluated as queries, ... the criteria of DLookup.) ... In VBA code, you need to use the IsNullfunction, e.g.: ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.modulesdaovba)