is it that complex?

Article View: comp.databases.ms-access

Article #197

Back to comp.databases.ms-access Previous Next

#197

From: asd987
Date: Sun, 23 May 2004 11:06

37 lines
2339 bytes

Hi,

I have a problem to print the correct data to a file.

I have two tables:
1. "names" with the records
-  "id" (autonumber / primary key)
- "description" (text)

2. "things" with the records
- "date" (date)
- "object" (memo)
- "name" (this refers isong lookup to table "names" the record "id")


I do:

print #1, rstfile2!date
print #1, rstfile2!object
print #1, rstfile2!name

As expected I get a number on the third print-command. I tried several
things to get the "description" of the "id" printed but didn't succeed.

Even when I do a

Select Case rstfile1!id
Case rstfile2!name
Print #1, rstfile1!description
End Select

while looping rstfile2  it doesn't work. Above that I think it could be done
much more easy than using the Select Case and looping-story. But how?

Thanks,

Sjoerd

Technical Details

Message-ID: <c8q0k8$47o$1@news2.tilbu1.nb.home.nl>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!news2.telebyte.nl!newshub2.home.nl!newshub1.home.nl!home.nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,26e13a2853c27e7e,start
X-Google-Thread: 102b1d,26e13a2853c27e7e,start
X-Google-Thread: 11387c,26e13a2853c27e7e,start
X-Google-Thread: 111a5a,26e13a2853c27e7e,start
X-Google-Thread: 101bdd,26e13a2853c27e7e,start
X-Google-Thread: fe218,26e13a2853c27e7e,start
X-Google-Thread: 1128b1,26e13a2853c27e7e,start
X-Google-Thread: 113a89,26e13a2853c27e7e,start
X-Google-Attributes: gidff0ac,gid102b1d,gid11387c,gid111a5a,gid101bdd,gidfe218,gid1128b1,gid113a89,public
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!news2.telebyte.nl!newshub2.home.nl!newshub1.home.nl!home.nl!not-for-mail
From: "asd987" <asd987@home.nl>
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,dk.edb.database.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.office.access.forms,microsoft.public.office.access.formscoding
Subject: is it that complex?
Date: Sun, 23 May 2004 13:06:43 +0200
Organization: @Home Benelux
Lines: 39
Message-ID: <c8q0k8$47o$1@news2.tilbu1.nb.home.nl>
NNTP-Posting-Host: cc91542-a.hnglo1.ov.home.nl
X-Trace: news2.tilbu1.nb.home.nl 1085310408 4344 212.120.101.44 (23 May 2004 11:06:48 GMT)
X-Complaints-To: abuse@home.nl
NNTP-Posting-Date: Sun, 23 May 2004 11:06:48 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409