[MS_AccessPros] Re: Suggestion/Ideas plz, Customer wants a text box created with ALL changes

 

ok, how about this,

I can get the count of how many Fields are in each table as below

Dim db As Database
Dim strtbl As String
strtbl = "INFO"
Set db = CurrentDb
MsgBox db.TableDefs(strtbl).Fields.Count

is there a way I can retrieve the content of each individual field like walking a subscripted array ?

Terence

--- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@...> wrote:
>
>
>
> I have have about 40 tables in this database, which may or may be created d=
> uring an "Encounter". My customer wants all the data that is added into tho=
> se tables during that "Encounter" dumped into a text box, we are not concer=
> ned with format. We dont even care if there are associated label or just th=
> e data, I just need the stuff shoved in a box.
>
>
> There are aprox 400 individual elements, so I dont want to write code to do=
> them all. Any one have a clever idea?
> terence
>
> I am thinking something with a Star (*)...like a me.dumpbox =3D me.recordse=
> t
>
> or making some sort of a continuos for, or a datasheet, I just dont know ?
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 3
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___