Go Premium for a chance to win a PS4. Enter to Win


Reformat Results as a Form

Posted on 2002-06-06
Medium Priority
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

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 400 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
Suggested Courses

824 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