constant values

[Lukas]

I have a very simple question, which I am not able to resolve though.

I have created a query, which combines records from two tables. Works nicely.

Now I would need to add several columns with either

a) fix values, which will never change
b) values which apply for all records, but which I would like to enter
within a form every time I would like to run the query.

The background is that I will use access as a mapping tool, so an original
file will be uploaded and result in a table with the same name always. The
query now takes the mappings for another table and combines the information
to result in a file, which I will extract and load into the target system.
So this is the reason, why some characters will always be the same and
others need to be adjusted any time I run the query.

Currently, it always gives me the pop up, asking for the missisng values,
but I would like to have this easier in a nice form, so it gets easier to use.

Thanks for your help,

Lukas

 

[Allen Browne]

Type an expression like this into the Field row in your query:
[Forms].[Form1].[Text0]

Provided you have Form1 open (not design view) before you run the query, and
the form has a control named Text0, the query will read the value from the
form instead of popping up the Parameter dialog. You could even put a button
on your form, and use the OpenQuery action in its Click event.