quries start with ~

[Roy Goldhammer]

Hello there

On any time i check all the quries in queryDef objects there are some quries
start with ~

what are they? and whay when i create new mdb file and import all objects
from older mdb this queries aren't passed?

 

[Brendan Reynolds]

They are queries that Access creates automatically. For example, if you have
combo boxes or list boxes with SQL statements as their RowSource property,
or Forms or Reports with SQL statements as their RecordSource property,
Access will create queries from these SQL statements using that naming
convention. It doesn't matter that they don't get imported into a new
database, as Access will re-create them.

 

[John Spencer]

They are
- queries that are being used as row sources for listboxes and comboboxes
(the SQL is directly entered in the row source)
- queries that were created as record source for reports and forms (the SQL
is stored in the record source of the report/form)

What you see are the queries you have created as queries and stored as named
queries.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Marshall Barton]

On any time i check all the quries in queryDef objects there are some quries
start with ~

what are they? and whay when i create new mdb file and import all objects
from older mdb this queries aren't passed?

Ignore them.

Those are querydefs that Access creates from form/report
record source or list/combo box row source properties that
are set to an SQL statement. They are not imported because
they will be recreated as needed when you tun the new copy
of the mdb.