Ask Your Question
0

Help "SearchListBox" and "NewRecord" Button in same Form ?

asked 2016-09-03 16:16:24 +0100

kirsch gravatar image

updated 2016-09-03 16:46:20 +0100

Ratslinger gravatar image

Help with dropdown boxes in LO Base forms

I was able to setup a Form for selecting and displaying records. But, in the real database, while trying to follow users requirements, I am unable to implement on that Form several BUTTONS like

  • NEW record,
  • DELETE record,
  • LAUNCH WRITER from inside the Form

Is it possible ? maybe not whithout macros.
So I have second Form, as a turnarround, just for deleting and creating records !

My simple exemple : http://r.kirsch.free.fr/LibO/LibO_Lis...

edit retag flag offensive close merge delete

Comments

LAUNCH WRITER is not clear. Do you mean a specific document or just a new document or something else?

Ratslinger gravatar imageRatslinger ( 2016-09-03 16:45:47 +0100 )edit

Just for convenience, open WRITER from inside the Form, for text writing/editing before sending to a malinglist by Email.

kirsch gravatar imagekirsch ( 2016-09-06 19:30:04 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2016-09-05 14:36:16 +0100

peterwt gravatar image

The way you have designed your Form prevents adding or deleting records even if you put the Navigation bar on the SubForm. This is due to the forms being linked on Id.

I have created a form FormNew which allows all these functions. It contains only MainForm with a navigation bar. When the Form is opened it will display all the records in the Table with the navigation bar to move between records. You can add or delete a record. If you add a record then click on Save Record in the Navigation bar after entering the data. The Id field is locked as it should not be modified as it is an Auto Value field. You can select a record using the List Box. This runs a Macro to Filter the records on the List Box selection.

Not sure what you mean by launch Writer. From a Button on the Form you can use the Action Property of the Button selecting Open document/web page and setting URL to the document by using the select icon to the right. This will allow you to select a document from a directory.

The modified database is here. LibO_Listbox_SelectionMod.odb

edit flag offensive delete link more
0

answered 2016-09-03 17:47:42 +0100

Ciao, you have to set Properties parameters like:

If my answer helped you, vote it with ✔ and with ∧ (here on the left)

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-03 16:16:24 +0100

Seen: 307 times

Last updated: Sep 05 '16