Re: form default from a second field

On Thu, 8 Sep 2005 09:16:01 -0700, "Arch"
<Arch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>In general, I am having trouble getting a
>grip on how to address cells in Access in a manner analogous to arrays in
>Basic or Fortran, to use them for defaults.

Well, since Access doesn't use "cells", I can see why you might be
having trouble using them... <g>

Tables *are not arrays*, and thinking of them as if they were will
just cause confusion.


John W. Vinson[MVP]
.

Relevant Pages

  • Re: Excel Chart Series Values Property Size Limitation
    ... I first started using named arrays as a method to 'delink' large series data ... The chart can remain user re-formatable and, if the right code is to hand, ... amend the data and/or re-source to cells. ... indeed the workbook could contain only ...
    (microsoft.public.excel.charting)
  • Re: getting the min and max of a list of numbers
    ... Since you're referencing individual cells Excel ... if we force the text and logicals into arrays then we'll get the ... Microsoft Excel MVP ... Im just wondering for future reference, ...
    (microsoft.public.excel.misc)
  • Re: Help! Plotting to scatter graph
    ... You need to qualify 'Cells' to the relevant worksheet, ... If your sets of values produces arrays as strings in the series formula ... Sub TestData() ... Dim chtObj As ChartObject, cht As Chart, sr As Series ...
    (microsoft.public.excel.programming)
  • Re: Excel Chart Series Values Property Size Limitation
    ... I only mentioned Named arrays as you had asked if was possible to hold ... 'large' series data not in cells. ... However you implied an 'invisible range' ... eg remove all cell links and reapply data as named arrays. ...
    (microsoft.public.excel.charting)
  • Re: Excel Chart Series Values Property Size Limitation
    ... "Peter T" wrote: ... I only mentioned Named arrays as you had asked if was possible to hold ... 'large' series data not in cells. ... Of course, chart data could be in cells in hidden columns, outside the ...
    (microsoft.public.excel.charting)