 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / October 2007Question on comments in queries
Hello, Can anyone tell me if either of the following can be done, and if so, how? 1. Can you put comments in a query? 2. Can you embed an informative prompt to the user in a query? I have an Insert query (rarely executed) and I would like it to give an informative prompt to the user for input. The user must input a value to the query and I would like the user to receive prompt which clearly explains what he should enter. TIA, Rich 1. Not natively, in Jet. You can use the 'description' of the ACCESS query object, though. 2. Make the parameter coming from a FROM, from a text control on a form, to be more precise (or from any control returning a value). You then have VBA code behind the form to play with what you want do, in addition to use tooltip. Hoping it may help, Vanderghast, Access MVP > Hello, > [quoted text clipped - 13 lines] > TIA, > Rich |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.