Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms > Dynamic Query B...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 44666 of 46474
Post > Topic >>

Dynamic Query Based on Current Row

by =?Utf-8?B?Qm9uejA5OQ==?= <Bonz099@[EMAIL PROTECTED] > Aug 7, 2008 at 09:11 PM

Hello, I have a query that dumps 4 column values to a form with a button at

the end of each row. One of the fields is called "datesubmitted". I would 
like to execute a query based on the dynamic data of that current row’s 
respective "datesubmitted" field. 

For example when I click the button at the end of the row, it runs <sudo 
code> SELECT * FROM TableName WHERE date = "currentrow.datesubmited"
</sudo 
code>

Sorry for the bad explanation im just learning to use access.
 




 7 Posts in Topic:
Dynamic Query Based on Current Row
=?Utf-8?B?Qm9uejA5OQ==?=   2008-08-07 21:11:01 
Re: Dynamic Query Based on Current Row
"Albert D. Kallal&qu  2008-08-07 22:48:26 
Re: Dynamic Query Based on Current Row
=?Utf-8?B?Qm9uejA5OQ==?=   2008-08-08 09:05:01 
Re: Dynamic Query Based on Current Row
"Albert D. Kallal&qu  2008-08-08 18:11:37 
Re: Dynamic Query Based on Current Row
=?Utf-8?B?Qm9uejA5OQ==?=   2008-08-09 17:55:01 
Re: Dynamic Query Based on Current Row
"Albert D. Kallal&qu  2008-08-11 01:32:38 
Re: Dynamic Query Based on Current Row
Piet Linden <PieterLin  2008-08-09 20:49:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:49:35 CST 2008.