Author Topic: HyperNext Capabilities for Specific Requirements  (Read 2445 times)

bamby1983

  • Newbie
  • *
  • Posts: 1
HyperNext Capabilities for Specific Requirements
« on: January 24, 2012, 11:59:29 PM »
Hello HyperNext Community,

I've just looked through the HyperNext QuickStart guide and gone through the tutorials and forums and am a little unclear as to whether HyperNext has the capabilities for a specific requirement I have.

What I'm looking to do is to create an EXE program in HyperNext that will do all of the following:
1) Display a form and autofill some of the values by fetching data from an MS Access database
2) Write the form content to the same database after performing some validations
3) Autogenerate Excel reports in a particular format that I desire by fetching some information from the MS Access database and other inputs from a user interface

The database needs to be an MS Access-based on (though I can consider an Excel-based table as well if required). The report, however, will HAVE to be in Excel format, and will need to be more than just a table with rows and columns. There will be headers, branding, rich text formatting, a non-tabular format and possibly some graphs (the graphs are not 100% compulsory though).

I'd appreciate it if anyone could let me know whether these features are possible within HyperNext and if so, how I could go about implementing this.

Malkom

  • Administrator
  • Newbie
  • *****
  • Posts: 401
  • Here to help you
Re: HyperNext Capabilities for Specific Requirements
« Reply #1 on: January 25, 2012, 07:28:12 AM »
Hello bamby1983

I'm sorry but HyperNext cannot interact with MS Access and execute queries etc.

However, your second option sounds possible as others have used HyperNext to modify Excel spreadsheet by considering it just as a file.

These posts might help:-

http://www.tigabyte.com/smf/index.php?topic=234

http://www.tigabyte.com/smf/index.php?topic=14

http://www.tigabyte.com/smf/index.php?topic=178

It sounds do-able but complex as you want headers and special formatted text but if you started with a simple Excel spreadsheet, understood its format, experimented with reading/writing then you should quickly understand whether you want to use HyperNext or use another program that has the MS Access features.

Malkom


I am sorry but I do not have time to answer questions by PM or email.
If you post your questions in this forum then it might help others.