Article View: free.it.visual-basic
Article #2807Re: Ricerca Scadenza
From: Un marinaio
Date: Sat, 15 Feb 2003 15:01
Date: Sat, 15 Feb 2003 15:01
25 lines
1730 bytes
1730 bytes
On Wed, 12 Feb 2003 17:06:55 GMT "rinaffo" <rinaffo@libero.it> wrote:
> Ciao Ragazzio sono Rino
> Sto sviluppando un gestionale videoteca .
> volevo sapere come posso fare a far visualizzare tutti i giorni le tessere
> che scadono .
> Tenedo presente che uso una tabella access con questi campi:
> Nome
> Cognome
> Tel
> Citta
> Tipo Tessera
> Documento
> Cell
> DataInizio
> DataScadenza Tessera
>
> Grazie Rino.
>
>
Set rstMioRecordset = MioDataBase.OpenRecordset("SELECT * FROM MiaTabella
WHERE [DataScadenzaTessera] <=#" & DataDiControllo & "# ", dbOpenDynaset)
Spero sia ciò che cerchi!
Technical Details
Message-ID:
<CFN376676682047454@powernews.libero.it>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mailReferences:
<Pav2a.110509$ZE.3077142@twister2.libero.it>Show Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,CP1252 X-Google-Thread: f94ee,850e2a4169e1f3fb X-Google-Attributes: gidf94ee,public X-Google-ArrivalTime: 2003-02-15 07:01:50 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!news.mailgate.org!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=WINDOWS-1252 From: Un marinaio <a.m.trani@libero.it> Message-ID: <CFN376676682047454@powernews.libero.it> Newsgroups: free.it.visual-basic References: <Pav2a.110509$ZE.3077142@twister2.libero.it> Subject: Re: Ricerca Scadenza User-Agent: Codeforge Sophax 1.5 Lines: 25 Date: Sat, 15 Feb 2003 15:01:20 GMT NNTP-Posting-Host: 151.24.190.195 X-Complaints-To: abuse@libero.it X-Trace: twister1.libero.it 1045321280 151.24.190.195 (Sat, 15 Feb 2003 16:01:20 MET) NNTP-Posting-Date: Sat, 15 Feb 2003 16:01:20 MET Organization: [Infostrada]