MS ACCESS Web Form - command button to open document from record

Posted on 2007-09-28
Last Modified: 2013-11-28
I have a form that I've converted over to HTML, but now some of the commands don't work bcs its obviously in a differnt language (originally done in VBA through Access).

The code that I was using to open a document link from the record was using the followhyperlink method...code i was using here...Application.FollowHyperlink txtFilePath <where txtfilepath is in the record as tblRecord / Document Link column.

How would I do this in HTML?
Question by:iceman_dci
    LVL 39

    Expert Comment

    I think if you just make that data a hyperlink ref on your web page you will not have to do anything ... the file should just open.

    <a href="file://c:/book1.xls">book1</a>
    LVL 84

    Accepted Solution

    No points for me:

    When you convert to a Web Form (or Data Access Page, as I believe they're called) then basically Access simply creates a standard HTML form that displays your data ... so, as Steve points out, you can use any web-based language on that form/page.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now