hypuk
10-07-2009, 09:56 AM
Hi
hope you're ok.
I've created a userform in Excel and wanted to know how I can get the information entered into the userform into a database?
Here's the scenario.
I want the userform to collect data I.E Hotel booking request
Then once the user has entered all of the information into the form, they click a button, form is closed and a unique reference number is generated in a dialogue box.
Then the booking team can access a booking queue where all the submitted booking requests are,
We have already have this kind of thing in place and Visual Basic and SQL are used.
If you can point me in the right direction that would be fantastic.
I'm new to VBA and SQL however I pick things up quite quickly
Any help would be much appreciated.
Thanks
Mark
hope you're ok.
I've created a userform in Excel and wanted to know how I can get the information entered into the userform into a database?
Here's the scenario.
I want the userform to collect data I.E Hotel booking request
Then once the user has entered all of the information into the form, they click a button, form is closed and a unique reference number is generated in a dialogue box.
Then the booking team can access a booking queue where all the submitted booking requests are,
We have already have this kind of thing in place and Visual Basic and SQL are used.
If you can point me in the right direction that would be fantastic.
I'm new to VBA and SQL however I pick things up quite quickly
Any help would be much appreciated.
Thanks
Mark