Add Field to Query through Code?

G

Gibson

I have a backend mdb and a frontend mdb. I have added a field to a table in
the backend using code. Now I need to update a query in the front end that
feeds a form to include the new field added to the table in the backend.
Can this be done through code thus the adding of the field and updating of
the query is done in at the same time as it were?
 
M

[MVP] S.Clark

Open the querydef object and update the SQL property. See the help file for
a general example.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query through code? 1
Updating Query with code 1
Append Query via code: Data getting lost 2
Query joins not created in front end query grid 2
Invalid Argument - Append Query 1
lost joins in frontend 3
Update pass through query of report recordsource 2
backend table not showing in linked table manager 1

Top