Hoping You Can Help Me to Save a Little Time.

  • Thread starter Thread starter krystle h. via AccessMonster.com
  • Start date Start date
K

krystle h. via AccessMonster.com

Hello,

I recently completed my database in access and I am in the process of "fine-
tuning" it. Within the database, I have a mass numbers of queries. After
further reviewing the database, I decided I didn't need all columns within my
queries to show. I know that you can "uncheck" the specific columns to hide
information. I have done this for some of the queries, but because there are
so many, I wanted to know is there an easier way? Possibly there may be some
kind of code available to determine the information I want to make visible
within all of my queries in the database. I truly hope you're able to help
me.
 
I assume your queries all start with:

SELECT * FROM Tablename...

Using VBA you can get the SQL of each query, replace the * with the field
list, then save the query.

I can't imagine how you'll know which fields to add to which queries, but
I'll assume you have that part already thunked out.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
 
Possibly there may be some
kind of code available to determine the information I want to make visible
within all of my queries in the database.
Click to expand...

That won't be available until the telepathic user interface comes out.
The current scheduled release date is <mmmpf> <spluttt>
TCP/IP ERROR
CONNECTION LOST

John W. Vinson[MVP]
 
Back
Top