Reformat Results as a Form

Posted on 2002-06-06
Last Modified: 2013-12-24
I am using the FrontPage Database Results component to display some records with a filter.  Two of the values are Yes/No (the checkboxes in Access) but display in the results as "True" or "False".  Is there a relatively easy way to make them display as checkboxes (in a form) or even buttons (so as they could be updated.)?  
Question by:probelaw
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 7061755
Unless you know how to modify the Web Bot code then no.  You can do it with ASP.  Why don't you just create a duplicate form that pulls the info from the database and puts it in the fields.  Then you can update it that way.


Author Comment

ID: 7063364
I think the form as results is the best way to go...I didn't even think of that.  One problem though...using the checkboxes for a true/false value...

You can set the checkboxes to have an initial state of checked or unchecked...

<input type="checkbox" name="Ordered_County_RD" %>" checked>

How can I tell them to go with what the database record has (checked for true, unchecked for false)?

Accepted Solution

phuctran earned 100 total points
ID: 7163797
I don't remember exactly what will return from Access.  But this is the idea.

1. If after getting the recordset and the value of the field (boolean field in Access) is 1 or 0 (1: true, 0: false).  You use this sub

Sub IsCheckedBox(value)
  If (value = 1) Then
    Response.Write " checked "
  End If
End Sub

2. If after getting the recordset and the value of the field (boolean field in Access) is True or False.  You use this sub

Sub IsCheckedBox(value)
  If (value) Then
    Response.Write " checked "
  End If
End Sub

When you write the <input type= .." use this

<input type="checkbox" name="Ordered_County_RD" <%IsCheckedBox(TheValueFromDataBaseInRecordSet)%> >


Featured Post

Report: Liquid Web beats Amazon, Rackspace & More

A study by performance analyst firm Cloud Spectator finds that Liquid Web beats rivals Amazon, Rackspace and DigitalOcean when it comes to website and cloud application performance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

738 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