Question on comments in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top