Using Office Link

[Guest]

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

 

[Guest]

Create a query based on the form and export that.

 

[Guest]

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

 

[Guest]

export the same query that the form uses

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

 

[Guest]

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.

 

[Guest]

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]

 

[Guest]

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

Thanks!

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]

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.