I need to save from table to Calc

[ypersyntelykos]

hellow i create a database
this database they use 4 different user which put new records or delete some records or change some records
i create a form for new records and another form for change/delete records
all this save it in one table so
i need to save all the data from this table in a sheet of calc how can i do it with a button from these forms ??

thanks

[ypersyntelykos]

any suggestion ??

[Villeroy]

Register your database.
Open the Calc document or Calc template.
Hit F4
Drag the table icon into a sheet. Now the data are linked to the database.
Add (conditional) formatting, charts, calculations, whatever.
Save the Calc document.
################################
After the database table has changed, open the Calc document (you may use an URL button on a form)
menu:Edit>Refresh

Auto-open macro to refresh all import ranges:

Code: Select all

Sub onOpen(e)
dr = e.Source.DatabaseRanges
for each db in dr
db.refresh()
next 
End Sub