Question on comments in queries

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
 
M

Michel Walsh

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
need to create a parameter query that will show the records betwee 6
Query Criteria Help 5
Query for YTD Total 6
Query using two separate query totals 3
Parameter Query Text 2
Criteria = Like "*this*" With Prompted Entry 5
Using "and" for a parameter search in a query 5

Top