Re: Complex? reporting problem

Stuart,

As much as I love VBA, I don't think that you need it here.

Re: your day of year conversion to your "switch value."
I presume that your switch value is relative to the month where the
day of year is occurring? If so, you can build this conversion using
tables and queries.
First, you must create a table that associates each day to a "switch
value." Due to the nature of our calendar system, this could be
tricky, and will require an update each year.
Second, in your query build a new field based on the link from your
original table (with the day of year) to your new table with the day
in year to month in year conversion.

Re: modifying colors based on values.
To the best of my knowledge, reports in Access are black and white.
You cannot generate a report with a red or green text or background.
On the other hand, you can change the color of a field in a form (or
subform). To access this functionality, select the field in design
view and select Format > Conditional Formatting. You will probably
want to use an expression (i.e., Expression Is) to generate your
condition.

Re: research recommendations
I'm pretty sure that your standard "Access Bible" has some starter
information on generating VBA modules. You can also create a macro,
then dig into the code behind the macro (I know you can do this in
Excel, pretty sure its possible in Access, although I haven't ever
done it).
If the intro stuff doesn't satiate your needs, then Access 2002
Desktop Developer's Handbook is a very good source for learning more
complex code development. It doesn't have 'everything' but it has
almost everything you'll need to tap into all of the features of
Access. From what I can tell, this book is the standard.
Finally, you can also check out the Access web (website). Dev Ashish
and compatriots provide alot of good code to build from on the
website. I will say that copying and pasting code is a bad habit.
Invariably something will pop up that doesn't work to your liking and
you'll be forced to revisit the code and change it. Revising code can
be tedious and time consuming, especially if you layer new code on top
of the code you are fixing.
.

Relevant Pages

  • NYC History -- Switch to 2L From 3L Exchanges, 1950 Installation?
    ... Did Chicago switch? ... According to the NYT for 1922, the conversion to dial was a very ... two central offices converted, in I think, 1949. ...
    (comp.dcom.telecom)
  • Re: Authentic sound of telephone ringers [telecom]
    ... 'node addressing', time-slot management, etc. -- that are in the 'conversion ... -or- a set designed for a specific network. ... Circa 20 years ago, I saw a phone set that looked like a 2500, but had an ... you had dial-tone from the 'home' switch, ...
    (comp.dcom.telecom)
  • Re: Problem when another app activated from macro
    ... > control to it and several other controls, ... > However if you switch to some another application manually ... could try "show" on the form (in VBA). ... AppleScript: The Definitive Guide ...
    (microsoft.public.mac.office.word)
  • Re: VBA changes in Word 2003?
    ... Does a conversion utility exist to convert to VBA? ... You can examine the code to see how many WordBasic objects are used, ... require a significant rewrite, requiring significant expertise. ...
    (microsoft.public.word.vba.general)
  • Re: VB6 vs VB .Net
    ... I'm gradually going to convert all my VB and VBA into VB .NET. ... > VB6 has a limited future potential, ... > generate those kinds of articles THREE YEARS AGO. ... > it doesn't any more, switch to anything else, *anything at all* other than ...
    (microsoft.public.vb.general.discussion)