🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #154

Re: Access Parameter Problem

#154
From: Trevor Best
Date: Mon, 08 Jul 1996 00:00
22 lines
1298 bytes
On Tue, 02 Jul 1996 09:56:10 +0100 in comp.databases.ms-access, Haehlen
Mike <NHHLEM@ascom.ch> wrote:

>Hi,
>does anybody know how I have to transmit two parameters for a data field 
>from visual basic to access.
>(SQL: ... (Temp1.Datum between [param1] and [param2] ...)

I haven't tried, so don't take this as a dead-bang-sure answer but
opening the querydef and setting the parameters in there may help.

                    \|||/
                    /   \
                   C o o D
-----------------ooO--u--Ooo-------------------------------
I have the simplest of tastes, 
       I'm easily satisfied with the best.

trevor@easynet.co.uk - Microprism (UK) Limited
Opinions my own, not my employers.
http://easyweb.easynet.co.uk/~trevor/
Technical Details
Message-ID: <31e059f4.5200130@news.easynet.co.uk>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <31D8E42A.61A6@ascom.ch>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10843a,ff4c50bbd939a149
X-Google-Attributes: gid10843a,public
X-Google-Thread: ff0ac,ff4c50bbd939a149
X-Google-Attributes: gidff0ac,public
From: trevor@easynet.co.uk (Trevor Best)
Subject: Re: Access Parameter Problem
Date: 1996/07/08
Message-ID: <31e059f4.5200130@news.easynet.co.uk>
X-Deja-AN: 164217411
references: <31D8E42A.61A6@ascom.ch>
organization: Microprism (UK) Limited
reply-to: trevor@easynet.co.uk
newsgroups: comp.databases.ms-access,ch.general