Re: Accessing filenames programatically

Answered in microsoft.public.access.modulesdaovba

--
Brendan Reynolds (MVP)

"MYKLIV" <MYKLIV@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1FE59747-428A-4939-8164-A51A30AD84C1@xxxxxxxxxxxxxxxx
>I am trying to access the fields in an access table, through an ado
> recordset, (which works), but I am trying to loop through the filenames in
> the table progamatically. The fieldnames are as follows...
>
> Mon_type1
> Mon_type2
> Mon_type3
> Tues_type1
> Tues_type2
> Tues_type3
> Wed_type1
> Wed_type2
> Wed_type3
>
> I have tried doing it by filling a couple of array's as...
>
> Text(2)
> text1
> text2
> text3
> ...for the textbox name...
>
> Day(2)
> Mon_
> Tues_
> Wed_
>
> and
>
> Field(2)
> type1
> type2
> type3
>
> concatenating the day & field from the array's together
>
> fieldname = Day(x) & Field(x)
>
> and then looping through and painting the form with something like...
>
> forms!frmInfo!!(text) = (fieldname)
>
> and looping through something like that, but access is having problems
> with
> (fieldname) even though it is enclosed with paren's. I have looped through
> the textboxes on a form like this successfully and thought that looping
> thfieldnames would be just as easy, but it doesn't seem to be working out.
>
> Does anyone know how to refer to this ? Is it even possible ??
>
> Ideas ?
>
> TIA !!!
>
> Michael


.

Relevant Pages

  • Accessing filenames programatically
    ... recordset,, but I am trying to loop through the filenames in ... ....for the textbox name... ... fieldname = Day& Field ... and then looping through and painting the form with something like... ...
    (microsoft.public.data.ado)
  • accessing fieldnames programatically
    ... recordset,, but I am trying to loop through the filenames in ... ....for the textbox name... ... fieldname = Day& Field ... and then looping through and painting the form with something like... ...
    (microsoft.public.access.modulesdaovba)
  • Re: Annoying decimal point
    ... Try using an expression in the textbox on the report, ... replacing X with [FieldName] ...
    (microsoft.public.access.gettingstarted)
  • Referencing textbox
    ... Im trying to set value of a textbox, ... Fieldname is positively correct. ... Dim txtBox As New TextBox ... Dim obj As Naturgas ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: how to count a recordset
    ... "Select countfrom TableName where ContitionX" will return a count of the ... FieldName, you would use something almost like what you proposed: ... >> the number or records in the recordset. ... > Set moConn = New ADODB.Connection ...
    (microsoft.public.vb.database.ado)