[AccessD] Passing query "Between" date values into a form

Kostas Konstantinidis kost36 at otenet.gr
Mon Feb 14 01:27:23 CST 2011


Yes Asger
it works perfect

thank's a lot
/kostas

-----Original Message----- 
From: Asger Blond
Sent: Monday, February 14, 2011 1:21 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Passing query "Between" date values into a form

Was this response of any help to you?
Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Asger Blond
Sendt: 12. februar 2011 20:15
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] Passing query "Between" date values into a form

In your query add two named columns to the grid
Start: [Date from:]
End: [Date to:]
Then in your form add a textbox with ControlSource: =[Start] & " " & [End]

Asger


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Kostas 
Konstantinidis
Sendt: 12. februar 2011 15:30
Til: AccessD at databaseadvisors.com
Emne: [AccessD] Passing query "Between" date values into a form

Hi all,

The form I built is based on a query, and in that query I use
the simple "Between [Date from:] And [Date to:]".

What I want to do is to pass the values of the two parameters
into a textbox in the heading of the form so if the dates parameters are 
e.g.
01/01/2011 and 31/01/2011 , to be displayed them in the form..

I try ControlSource: =[Date from:] & “ “ &[Date to:]
It works in a report but not in the form


Many thank’s
/kostas
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 5871 (20110213) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com





More information about the AccessD mailing list