Ask Your Question

Base FormFilter-Result Export? [closed]

asked 2017-04-27 12:55:48 +0100

cool gravatar image

Hallo, I have filtered my data. How to export the filter-result to calc? Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-01 16:06:35.372688

3 Answers

Sort by » oldest newest most voted

answered 2017-04-27 13:29:44 +0100

pierre-yves samyn gravatar image


Click Data Source as Table tool in Form Navigation toolbar: this opens a pane that displays the table data. Click at the intersection of the row and column headers to select all records. Keep the left click and drag-and-drop in Calc.


edit flag offensive delete link more

answered 2017-04-27 14:07:57 +0100

cool gravatar image

updated 2017-04-28 03:11:36 +0100

EasyTrieve gravatar image

Hi, "Keep the left click and drag-and-drop in Calc" works! But the result does not look the same, see screenshot ->

Bauart_fk in base shows the name, in calc it shows the foreign key number.

edit flag offensive delete link more


@cool Does the data come from a subform?

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-04-27 14:35:32 +0100 )edit

Yes, from other table.

cool gravatar imagecool ( 2017-04-27 14:39:25 +0100 )edit

answered 2017-04-28 03:14:55 +0100

EasyTrieve gravatar image

updated 2017-04-28 03:15:53 +0100

You're grabbing and dropping a Form's Table Control. Try grabbing and dropping a Query (from the icon to the left of the name of the query). I think this will give you what you want.

You will have to build your query to show the looked up values, not the keys (i.e. relate the tables in the query).

edit flag offensive delete link more


Hi, I use a form-based filter, not a query.

cool gravatar imagecool ( 2017-05-02 09:15:38 +0100 )edit

Question Tools


Asked: 2017-04-27 12:55:48 +0100

Seen: 93 times

Last updated: Apr 28 '17