Can't get rid of ~sq_ files in list box

  • Thread starter Thread starter jzeitzer
  • Start date Start date
J

jzeitzer

Using MSAccess 2002, I have a list box that allows people to open saved
queries (querylist in the Row Source Type). Problem is, besides being
populated by a list of saved queries, there are a number of files that start
~sq_c or ~sq_f (then the name of some old form). I've tried to
compact/repair the database and these files are present anywhere in the
database that I can find, but I still can't rid of them from the list. Any
ideas? -Jamie
 
Those queries are the stored queries for comboboxes' RowSources, listboxes'
RowSources, forms' RecordSources, and reports' RecordSources.
 
jzeitzer said:
Using MSAccess 2002, I have a list box that allows people to open saved
queries (querylist in the Row Source Type). Problem is, besides being
populated by a list of saved queries, there are a number of files that start
~sq_c or ~sq_f (then the name of some old form). I've tried to
compact/repair the database and these files are present anywhere in the
database that I can find, but I still can't rid of them from the list.
Click to expand...


I thibk the queries that start with ~ are the ones where you
used an SQL statement in a Row or Record Source.

Try setting the RowSourceType to Table/Query and the Row
Source to:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type = 5
And Left(MSysObjects.Name, 1) <> "~"
 
Worked like a charm... thanks!

Marshall said:
I thibk the queries that start with ~ are the ones where you
used an SQL statement in a Row or Record Source.

Try setting the RowSourceType to Table/Query and the Row
Source to:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type = 5
And Left(MSysObjects.Name, 1) <> "~"
Click to expand...
 
Back
Top