Hi All,
pls have a look at the attached db.
I did not find the solutions for:
1- search text (see form "FRM_QUERY_t1_t2")
Grid must be updated with a "LIKE %textSearch%" query, after "search" button action (this action should call a macro/function "searchByText_S1_AND_S2".
2- "double-click" for record details
Again in "FRM_QUERY_t1_t2", I want to:
- open "FRM_t1" on specific "id t1", when "double-click" on "id t1" value
- open "FRM_t2" on specific "id t2", when "double-click" on "id t2" value
- open "FRM_t1_t2" on specific ("id t1", "id t2", "name"), by "double-click" on "line record"
Your help will be appreciated.
TY,
CCJ
Search text and "double-click" for record details
Search text and "double-click" for record details
- Attachments
-
- db.odb
- (38.23 KiB) Downloaded 143 times
OpenOffice 4.1.5 on Windows 10
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: search text and "double-click" for record details
Look at this Example for a way to search without a macro
Filter/Search with Forms (leveraging SubForms)
Filter/Search with Forms (leveraging SubForms)
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: search text and "double-click" for record details
Thank you for you reply.
l need to do it with a macro.
l need to do it with a macro.
OpenOffice 4.1.5 on Windows 10
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: search text and "double-click" for record details
When there is a way to accomplish what you want without macro code
If you are intent on writing some macro code the use the method explained in the example and write macro code to replace the Push Button.
Makes no sense. Writing Open Office macros requires good knowledge of the API. Looking at the macro you included with your example it appears you don't have that.l need to do it with a macro.
If you are intent on writing some macro code the use the method explained in the example and write macro code to replace the Push Button.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11