Results 1 to 12 of 12
  1. #1
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124

    Add javascript and html code in form

    Hello guys



    I am quite naive for access and coding etc. I want to add a javascript code and html code in my form which will run a plus minus drop down menu in my form, so I have a html file, three .js files in a folder which I need to add all together to run that menu in my form.
    Any suggestions?

    many thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    What is plus minus dropdown?

    Duplicate topic https://www.accessforums.net/forms/p...enu-27248.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    Its similiar to drop down menu but in javascript with a plus sign on left side, which when you click shows the menu and the plus sign changes to minus sign. I am sure you must have seen and used it in forms before.
    I have made a similiar menu in HTML and javascript because my criterias are more than 200 and that too in different categories, so the best way to show them compactly in a form is plus minus drop down. But the problem is I dont know how to add that menu in the access form.
    Any help will be much appreciated.
    many thanks

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    Can't say I have seen that before. Want to provide a picture?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    Click image for larger version. 

Name:	untitled.JPG 
Views:	15 
Size:	31.2 KB 
ID:	9007

    it looks something like this. when you click on plus sign the menu expands and you can choose criteria to select.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    I think general terminology would be Treeview.
    There are not a lot of examples, but you may find something on Youtube, or Google.

    I found this on Google, it may give you some ideas -- but it isn't js nor html

    http://www.pointltd.com/Downloads/Details.asp?dlID=36


    http://www.access-programmers.co.uk/...d.php?t=111534

  7. #7
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    Thanks
    The treeview which you are mentioning only allows you to navigate through the list. But the plus minus drop down menu which I showed you allows to navigate as well as select any of the criteria from the list and enter it as a data in the database. You can see there is a search box as well at the base of the list which allows to search any of the criteria by name, so its a kind of dual facility to look for criteria and enter it in your database. I have found another way to make that kind of plus minus drop down but I am yet to find the way to use it in access form.
    I am not sure but I think in access it may not be possible to use HTML codes.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    The only Access/VBA use of HTML code tags I know of is in building HTML formatted string for body of email. These tags are just part of the string, and not actually executed by VBA. Also, XML code tags are used in building custom ribbon for Access2007/2010 but this code is in a special system table, not in VBA.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    I have a form with a Treeview with a list of sites.
    I have username, password and hyperlink to the site involved.

    To me, I open the form click the site name, just to make sure I remember the username and password and navigate to the site.
    Attached Thumbnails Attached Thumbnails treeviewSample.jpg  

  10. #10
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    Hi
    I have tried a lot to find the way to insert the HTML and javascript drop down menu in access form, but i could not. So I have decided to use combo box as drop down menu, but I dont know which way is better to put criterias in the prooperty of combo box whether by entering in row source or creating a table, as I have got more than 200 criterias to enter.
    Another query, is there anyway to show categories and subcategories in one combo box, like if I have to show 15 different type of surgeries (sub-category) under category Gastro intestinal surgeries and 30 in orthopedic surgeries and 20 in head and neck surgeries, which should look like -

    Gastro-intestinal
    1
    2
    3..and so on
    Orthopedics
    1
    2
    3..and so on

  11. #11
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725

  12. #12
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124

    hi

    Quote Originally Posted by orange View Post

    Best option so far, I am loving it!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. connection through javascript
    By vijaymohan in forum Access
    Replies: 0
    Last Post: 05-13-2012, 07:59 PM
  2. Export to HTML Button on Form
    By iProRyan in forum Forms
    Replies: 2
    Last Post: 04-26-2012, 11:41 AM
  3. "javascript:doSubmit('HELPPLEASE')"
    By redbull in forum Programming
    Replies: 2
    Last Post: 03-30-2012, 06:42 AM
  4. Replies: 0
    Last Post: 03-24-2011, 11:09 PM
  5. HTML Editor
    By mystifier in forum Forms
    Replies: 3
    Last Post: 11-11-2010, 05:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums