By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,087 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,087 IT Pros & Developers. It's quick & easy.

Inserting Subform Data in Table

P: 43
Hi!

I am having a problem here..I have a form and in that form I have a subform..Inside that subform it has data..I wanted to insert that data in a table..is it possible?please help me..


tank you in advance!

-cassey
Jan 28 '07 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,429
Yes it's possible.
Unfortunately, without information as to how the forms are joined; what the Record Sources are for the forms (or even if they're bound forms); if not bound how the forms are populated; The layout of the bound tables if bound; etc it's not easy to tell you the best way to do what you need to do.
Jan 28 '07 #2

P: 43
Yes it's possible.
Unfortunately, without information as to how the forms are joined; what the Record Sources are for the forms (or even if they're bound forms); if not bound how the forms are populated; The layout of the bound tables if bound; etc it's not easy to tell you the best way to do what you need to do.
thank you for the reply..
Actually the main form is the search form and there are multiple fields I need to search and the result will display in the subform..I need to export that result in excel but the recordsource of my subform is a stored procedure and whenever they need to search it will ask for parameters..by the way I am using adp access..I am thinking, whenever they search i will create a temporary table and insert the result of the subform on the table I created so that when I click the button export to excel I will just call the temporary table I created.

thank you in advance


-cassey
Jan 29 '07 #3

NeoPa
Expert Mod 15k+
P: 31,429
Just a bump for the moment I'm afraid.
Struggling to keep up with the volumes but I've got this bookmarked for a revisit.
Jan 30 '07 #4

NeoPa
Expert Mod 15k+
P: 31,429
Your solution should work.
You can do it with the existing query / Stored Procedure though if required. It will be complicated though, if you have filtering to apply.
First you need a QueryDef (saved query) to return the required results from the Stored Procedure. If the filtering (WHERE clause) needs changing this can either be done in place or on a temporary copy of the QueryDef which can be deleted when finished with. When the correct QueryDef is ready then simply export this Querydef to Excel in the usual way.

This is a lot more involved so you may well prefer the temporary table method. If not, and you need further clarification of how this should work then post back explaining which bit(s) you need help on.
Jan 31 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.