Re: cycle thru recordset filed collection

Seems to me it would be easier to use a query and populate a calculated field
in the query based on the options on the form.
--
Dave Hargis, Microsoft Access MVP


"Mark Kubicki" wrote:

thanks for all so far...

the intent is that there is a form that the user chooses options on:
prntNotes (Y/N) ' print notes
prntOptions (Y/N) 'print options
inclAddlInfo (Y/N) 'include additional information
....

I have a report where I dynamically build the text to be displayed; so the
code in a subroutine strGenerateDescription may (loosely) look like this:

BuildText = ""
IIf(varPrintNotes, BuildText = BuildText & ( frm!luminairType.Value
+ ", PLEASE NOTE THAT: " + frm!Note.Value, )
IIf(varPrintOptions, BuildText = BuildText & ( "ADDITIONAL OPTIONS:
" + frm!Option.Value, )
strGeneratedDescription = BuildText

where the value of the text box on the report is set to
strGeneratedDescripotion

since this evaluated with the same criteria for each recod in the report, it
seems to make sence to gather it into a set of variables ONCE, rather than
checking the values at each record


"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B6AEF127-CA2B-4060-BE1D-2F3C294C989C@xxxxxxxxxxxxxxxx
The concept interested me, so I tried every way I can think of to do this,
but it just will not work.
The closest I could get was one of two ways. One is to use a VBA
collection
object. This was the easiest, but then there was no way to know the field
names. What I did was use the field name as the Index property of the
collection, and the field value as the Item property of the collection.
So
if you know what field name you want, you can retrieve the value using the
field name as the index. But this doesn't make much sense, because if you
already know the field name, it becomes pointless.

The other was creating a two dimensional array with the field name in the
first element and the value in the second, but then you are right back
where
you started, you have to know the field name.

Now, in either case, if you know the field name you can retrieve the
value.
As I said, this is easier using a collection.

But, I can't figure out how you intend to use this. You description is a
bit vague. If I understand, you want to allow users to define Default
Values
for some text boxes on a form. Each field in this table will be used to
populate the Default Value property of a text box corresponding to a field
in
the table. You want the value of the table field to be the value for the
Default Value property of the text box control.

Let me know if this is correct and I can suggest a way to do that. It
would
also be useful if you let me know if the number of fields in this table
will
vary and if it will be used for more than one form.
--
Dave Hargis, Microsoft Access MVP


"Mark Kubicki" wrote:

I want to cycle thru the field collection creating a variable based on
the
name of each filed and then assigning the value of the field to that
variable. The table has only 1 record, which consists of a series of
user
defined default values (these values are used when generating, with code,
the value of a textbox in a report).

ex:
in Table1, there exists fields:
PrntNotes - value in record 1: True
PrntOption - value in record 1: True
PrntDescription - value in record 1: False)
...

What I ought to wind up with is a set of variables:
varPrntNotes - value: True
varPrntOption - value: True
varPrntDescription - value: False

thanks in advance...
-mark






.

Relevant Pages

  • RE: Sorting in Query and Report involving look up combo box
    ... Dave Hargis, Microsoft Access MVP ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ...
    (microsoft.public.access.reports)
  • Re: Access reports or Word Document
    ... Query A and Query B are related on the Primary ... create a report based on Query C. ... using one query to populate the header section and populate ... It is also easier to do complex formatting in Word. ...
    (microsoft.public.access.gettingstarted)
  • Re: Access reports or Word Document
    ... Query A and Query B are related on the Primary ... create a report based on Query C. ... using one query to populate the header section and populate ... It is also easier to do complex formatting in Word. ...
    (microsoft.public.access.gettingstarted)
  • Re: Including data from another table in a Report
    ... Russell Pascoe wrote: ... table to populate the address column. ... create a query that joins the two tables on the addressID ... A good rule to follow before creating a report is to first ...
    (microsoft.public.access.reports)
  • Re: Access reports or Word Document
    ... using one query to populate the header section and populate ... like the main body of the report to appear. ... It is also easier to do complex formatting in Word. ...
    (microsoft.public.access.gettingstarted)