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
 

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

Similar Threads

Make table query: [Enter 1] AS Test 1
User Prompt for Month to find Date Range 3
Using "and" for a parameter search in a query 5
Error on Access Query 10
Query based on multiple parameters - Access 2003 1
Crosstab query error 1
Another Query Modification Question 6
Query Criteria Help 5

Back
Top