We have started writing an app in VB Express 2012 which queries a SQL database based on what is entered into a field for use with redeeming voucher codes. This then displays a form based on what is entered. We need the functionality extended to achieve the following:
Load a form depending on what data is return to display the data, this will be a choice of two
Update a field in the SQL when a button is pressed for the record returned above
Create a settings area where we can input the SQL connection details rather than having it hard coded and directory for output text file (below)
Have a site number in the settings area which is commited to a field in the SQL table when a record is updated
Output a text file of the returned data (3 fields max)
A full document spec will be provided along with the source VB files of app so far.