Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form?

X

xyzer

I would like to produce a query that produces for me the date value in a text box in a form. Is this possible to do with DLOOKUP?
thanks
 
J

John W. Vinson

I would like to produce a query that produces for me the date value in a text box in a form. Is this possible to do with DLOOKUP?
thanks

You'll have to explain the context. Where is DLookUp getting the value? What
does the query have to do with it? What's the Recordsource of the form, and
does the data in the form have any connection to the desired date value?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
X

xyzer

The end goal is the bring in the date in the text box to an Excel Spreadsheet through Microsoft Query. People go into the form and change the date to what they want and run reports off of that date. The text box is not bound because when I bound the text box it no longer defaults to today's date, which I want it to do. If I could bound the text box and still keep it defaulting to today's date everytime someone opens the form that would solve my problem, as I would just pull the bound record. So now the alternative (I think) is to produce a query that will give me that date so I can send it on to excel (the report ends up in Excel, just want the as of (text box) date to go along with it).
 
A

Access Developer

I fear you are going to find that MSQuery works against Fields in Tables in
Databases, not against Forms and Text Boxes, so you'll have to use a
different approach.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

The end goal is the bring in the date in the text box to an Excel
Spreadsheet through Microsoft Query. People go into the form and change the
date to what they want and run reports off of that date. The text box is not
bound because when I bound the text box it no longer defaults to today's
date, which I want it to do. If I could bound the text box and still keep it
defaulting to today's date everytime someone opens the form that would solve
my problem, as I would just pull the bound record. So now the alternative (I
think) is to produce a query that will give me that date so I can send it on
to excel (the report ends up in Excel, just want the as of (text box) date
to go along with it).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top