Re: calculate values in a form

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Steve" <sorry@xxxxxxxxxxxxxxxxxxxx> wrote:

BTW, the last idiot that responded uses 50+ characters for field names,
table names, query names, form names and report names and thinks that is
cool!!! He is probably very sad his own name is so short!!!

<chuckle>

Very occasionally I will use table, query, form and report names that
are 50+ characters long. Not, to my knowledge, field names. However
when you're dealing in an app with 160 tables, 1200 queries, 450
forms, 350 reports and 70,000 lines of code sometimes you have to get
a bit wordy.

The relationships diagram is the full 4' width of the relationships
window and about 3' tall. Stephen Lebans had to make me a special
utility to stitch the relationships windows together just so we could
print it. The maximum report size is 22" x 22", IIRC, and that was
way too small.

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: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • RE: subtraction
    ... You can also manually check the Microsoft Access executable version number ... I'm using access 2000 and windows XP ... >>> The query is too complex to be opened in the QBE grid. ... >>> as a Record Source for either a report or a form, so I'm not sure why you are ...
    (microsoft.public.access.reports)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)