Push button, display error dialogue

[dianamon]

Hello!

Pretty new to openoffice- But I'm trying my best on a simple form to add customers into a database.
Everything works fine as it is now- But my workmates will have to use it as well and they're not very computer savvy.
Is there a way for my Push Button to open a dialogue box after it Saves and opens a new record?
It would be great if it could open a dialogue stating 'Customer added to database' . Even better if it could pick up on a Duplicate error or information not completed.
Right now there's no 'Violation of Unique record' message if you try and enter a duplicate record via the push button...

Any help is very welcome! Struggling with this for a bit too long now..

[dianamon]

I managed to get a message to come up when a customer is added to the database.
(while waiting for the topic to be approved ) Found this code in another topic and tweaked it:

Code: Select all

Sub helper
Const Helpheader="Added to Database"
Const Helptext= "You successfully added a new customer to the database!" 
Const OKbuttonOnly=0

MsgBox Helptext, OKbuttonOnly, Helpheader

End Sub
]

The only problem is displaying the 'Violation of Unique record' message...

[UnklDonald418]

I suspect you haven't received any responses to your question because it is a little too vague for anyone to offer much help.

Right now there's no 'Violation of Unique record' message if you try and enter a duplicate record via the push button.

Code: Select all

MsgBox ("Violation of Unique record",0,"Error")

can be used to display the message, but I'm guessing your problem involves trapping the error.
If that's the case perhaps if you uploaded a sample database file someone might be able to offer better help.

[Villeroy]

Like so often, there is a way to do it if you leave behind the embedded HSQL1.8
viewtopic.php?f=61&t=68434&p=306909&hil ... ed#p331154

[dianamon]

Thanks! I'll give it a go from the link you gave me.
The difficult part is that although everything in the database works fine right now, my workmates just don't understand openoffice at all... I'm trying to make it as user friendly as I can!