Access to Base

[jando]

Hello, would a good man be found. I need to run a search form in an external file in Libre OFFICE. was created in MS ACCESS. Thank you very much in advance. I have absolutely no idea how. I tried to convert, save, export etc. but I can't handle it; / PS. maybe someone saw or met the functionality file in the open office?

[Sliderule]

Find a Base database file attached, with the file name of: Database Search.odb . This is an Embedded Database file, using HSQL Version 1.8.0.10 as the database backend.

1. Find two tables defined, just as in your Access database
2. Your Access database that you posted contained very few records in it
3. Any Forms or Reports from your Access database MUST be recreated, if you wish to have one or more Forms or Reports in your Base ( *.odb ) file . . . they canNOT be 'imported'

Database Search.odb

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

[Villeroy]

Or connect the mdb file with OpenOffice:
File>New>Database...
Connect to existing database
Type: MS Access
Point to the mdb
Save the database.
Now you can see the tables in the Base document. Nothing has been converted, copied nor imported. The data are still in the mdb.

[jando]

Hello dear thank you very much for your time and help for me. I encountered problems trying to recreate the form (attachment), but I don't know how to complete the macro code. I do not know how to insert a class module (the author described that he used some templates). Can you help me?

[Villeroy]

Do yourself a favour and stick with MS Access.

[jando]

You don't even know how much I'd rather not get up and stay with MS ACCESS; / Unfortunately I can't ...

[Villeroy]

Then find an expert who is capable to remake that database.

[jando]

despite everything thanks for help and advice. Or maybe you met a form in base open office that searches from several tables and displays search results?

[Villeroy]

Or maybe you met a form in base open office that searches from several tables and displays search results?

I do not meet them. I make them.

[jando]

hey, it's me again; / I'm learning, but I have a disadvantage that I focus on the details that I meet along the way and try to understand them. Unfortunately, it takes me a long time. And I have to solve my problem quickly. Could you help me. Forms I have found are attached. I need to modify them. As an ideal I'm striving for, I've attached the access file (Universalsearch). I have several tables, they have different layouts of columns and headers. I need to search by text or numbers in all tables, in all columns and display results. I will be very grateful. Best regards, Kate Jand'o

[Villeroy]

I'm learning, but I have a disadvantage that I focus on the details that I meet along the way and try to understand them.

You don't have to suffer from this disadvantage. You could also learn things properly.

[Villeroy]

Not bad so far. Try this

Code: Select all

SELECT "PersonID" AS "PersonID", "FirstName" AS "FirstName", "LastName" AS "LastName", "PhonePrimary" AS "PhonePrimary", "EmailPrimary" AS "EmailPrimary" 
FROM "tblPeople" 
WHERE UPPER("FirstName") LIKE UPPER(:SearchBox) || '%' 
OR UPPER("LastName") LIKE UPPER(:SearchBox) || '%' 
OR UPPER("EmailPrimary") LIKE UPPER(:SearchBox) || '%' 
OR :SearchBox IS NULL 
ORDER BY "LastName" ASC, "FirstName" ASC

The UPPER function converts both sides of the comparison to upper case so the comparison is case insensitive. You could also use field type VARCHAR_IGNORECASE like you already did with the LastName.

Documentations for the embedded HSQL: http://www.hsqldb.org/doc/1.8/guide/ch09.html