INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Add a column to An existing QUERY via code

Add a column to An existing QUERY via code

(OP)
I have quite a large number of mdb databases that i need to adjust an existing query
The field is allready in the table used by the query
The field name is PubDetail the mdb is name Web1.mdb the table is Master1



I intend to load the databses into an array and loop through
the databases and adjust the query in each via code

Woukd appreciate some help with the code to do this...i seem to be
able to find code to alter a table but not a query ???



Regards Trob70

RE: Add a column to An existing QUERY via code

(OP)
I have come up with a solution !!

Delete the existing query
Create a new query

I guess this is the best solution ?????

Regards Trob70

RE: Add a column to An existing QUERY via code

Is this an actual VB6 question? Sure smells like something for one of the many Access forums here.

RE: Add a column to An existing QUERY via code

Hi Trob70,

Checkout the QueryDef object.
You can change the underlying SQL statement of a query. Example:

CODE

Dim qdef As QueryDef
Set qdef = yourDb.QueryDefs(NameOfQueryToBeChanged)
qd.SQL = "SELECT ..., PubDetail FROM Master1"
qd.Save 

Cheers,
MakeItSo

"Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

RE: Add a column to An existing QUERY via code

(OP)
MakitSo

Thanks for the tip

The code did the job..
Had to alter qd.Save to qd.close


Regards Trob70

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close