Using Office Link

G

GregB

I have a form that displays the invoice and has a subform that is linked by
master/child properties

and whenever I use The anaylse with excel, it only exports the main form and
not the linked subform information. How do I get around this?

It is really fusturating and I would have to redo my database. What do I do?
Thanks
 
G

GregB

well how would I goabout that? I can't do it manually becuase the form is a
query that asks for the user's input a date range. For example january
through febuary.

So how would I go about doing this
 
C

Chris Reveille

export the same query that the form uses

GregB said:
well how would I goabout that? I can't do it manually becuase the form is a
query that asks for the user's input a date range. For example january
through febuary.

So how would I go about doing this
Click to expand...
 
G

GregB

well correct me if I am wrong but then the user will have to do the input the
same data twice

They have to input data range to get to form and then... I have to have
another button or some object that will run a new query that contains both
the form and subform fields to get the data?

Isn;t there another way.
 
C

Chris Reveille

if your store the dates the person is entering on the form in a text box than
the query can reference those dates
In you criteria for date
between [Forms]![NameOfForm]![NameOfTextbox] and
[Forms]![NameOfForm]![NameOfTextbox]
 
G

GregB

ok I had it as a prompt but I guess I am going to have ot change it.

Thanks!

Chris Reveille said:
if your store the dates the person is entering on the form in a text box than
the query can reference those dates
In you criteria for date
between [Forms]![NameOfForm]![NameOfTextbox] and
[Forms]![NameOfForm]![NameOfTextbox]

GregB said:
well correct me if I am wrong but then the user will have to do the input the
same data twice

They have to input data range to get to form and then... I have to have
another button or some object that will run a new query that contains both
the form and subform fields to get the data?

Isn;t there another way.
Click to expand...
Click to expand...
 
Top