Access to ASP Problem...

[Bill Carson]

If anyone can help:
I just created a data base in MS ACCESS, which is very basic. Its a
list of users eg. names addresses etc.

However on this list is 6 columns with checkboxes, the boxes
representin if an individual user posseses a right or no. Check being
yes, no check being no.

I tried a conversion utility called ASP runner to publish the database
onto an intranet., no problem there it did the job. The pages are now
running on an intranet enviroment for certain people to see.

The problem is that the checkboxes that were present in the access
database, are now being diplayed as yes/no on the ASP pages.

Can anyone tell me how to get the ASP pages to display checkboxes?
Sorry if this is simple stuff, but I am relatively new to ASP. Been
seraching the web for an answer, but havent bee able to find anything.
Thanks In Advance.

[Larry Linson]

"Bill Carson" wrote

The problem is that the checkboxes
that were present in the access
database, are now being diplayed as
yes/no on the ASP pages. Can anyone tell me how to get the
ASP pages to display checkboxes?

I'm 100% confident that someone can; I'm not nearly that confident that, on
any given day, you'll find someone _here_ who can. This newsgroup is about
Microsoft Access, and ASP is quite a different thing, even if it can use the
same Jet database that Access does.

There are quite a number of newsgroups devoted to .asp and web
applications -- those would be the place to ask. I'd say your plight does
point out one of the _disadvantages_ of relying on a utility to create your
web pages -- if you don't know the underlying or output language, you may
have to accept what it generates.

I use Front Page to generate static web sites because it is so quick and so
easy compared to writing the HTML from scratch. But, if need be, I know
enough HTML that I can go in and, with liberal use of reference books, make
changes.

When you find an appropriate newsgroup, you'll need to give them some
detail, including which language(s) is(are) used in your .asp pages -- if
classic, that'd likely be vbscript or javascript? Indeed, are they "classic
asp" or ASP.NET? What is the vbscript or javascript code that shows the
Yes/No?

If you haven't already got a favorite USENET .asp newsgroup, you might want
to look in the microsoft.public... sponsored newsgroup hierarchy. You can
get them on a free news server at news.microsoft.com.

Larry Linson
Microsoft Access MVP

[Bill K. Ramsey]

Bill Carson <fr***@verizon.net> wrote:

If anyone can help:
I just created a data base in MS ACCESS, which is very basic. Its a
list of users eg. names addresses etc.

However on this list is 6 columns with checkboxes, the boxes
representin if an individual user posseses a right or no. Check being
yes, no check being no.

I tried a conversion utility called ASP runner to publish the database
onto an intranet., no problem there it did the job. The pages are now
running on an intranet enviroment for certain people to see.

The problem is that the checkboxes that were present in the access
database, are now being diplayed as yes/no on the ASP pages.

Can anyone tell me how to get the ASP pages to display checkboxes?
Sorry if this is simple stuff, but I am relatively new to ASP. Been
seraching the web for an answer, but havent bee able to find anything.
Thanks In Advance.

Please post the code for your asp page(s). I can most likely help, as
I write ASP code to MS-Access and SQL Server databases all day long.

However, Larry's advice is sound: you should try the
microsoft.public.inetserver.asp.general
newsgroup.

However, before you do, post the code to your page. Because they will
admonish you if you don't.

Bill

--
Bill Ramsey
bi*********@insightbb.com

[kling0n]

try changing your input type to "checkbox"
i get most of my asp help from microsoft.public.inetserver.asp.general
;microsoft.public.scripting.vbscript on msnews.microsoft.com and
web.server.scripting and web.asp on news.devx.com

rh

"Bill Carson" <fr***@verizon.net> wrote in message
news:pe********************************@4ax.com...

If anyone can help:
I just created a data base in MS ACCESS, which is very basic. Its a
list of users eg. names addresses etc.

However on this list is 6 columns with checkboxes, the boxes
representin if an individual user posseses a right or no. Check being
yes, no check being no.

I tried a conversion utility called ASP runner to publish the database
onto an intranet., no problem there it did the job. The pages are now
running on an intranet enviroment for certain people to see.

The problem is that the checkboxes that were present in the access
database, are now being diplayed as yes/no on the ASP pages.

Can anyone tell me how to get the ASP pages to display checkboxes?
Sorry if this is simple stuff, but I am relatively new to ASP. Been
seraching the web for an answer, but havent bee able to find anything.
Thanks In Advance.

[Bill Carson]

Input type is exactly what it was.
I had to add a line of code "data type 11 input type checkbox".
Im going to post the exact code here Monday because I cant remember
exactly what it was.

I actually have another minor issue, that similar.
I will elaborate more on it once I have posted the code here.

Would like to thank everyone for their responses.

BC
On Thu, 6 Nov 2003 13:58:27 -0500, "kling0n"
<kl*****@nospam.mailandnews.com> wrote:

try changing your input type to "checkbox"
i get most of my asp help from microsoft.public.inetserver.asp.general
;microsoft.public.scripting.vbscript on msnews.microsoft.com and
web.server.scripting and web.asp on news.devx.com

rh

"Bill Carson" <fr***@verizon.net> wrote in message
news:pe********************************@4ax.com.. .

If anyone can help:
I just created a data base in MS ACCESS, which is very basic. Its a
list of users eg. names addresses etc.

However on this list is 6 columns with checkboxes, the boxes
representin if an individual user posseses a right or no. Check being
yes, no check being no.

I tried a conversion utility called ASP runner to publish the database
onto an intranet., no problem there it did the job. The pages are now
running on an intranet enviroment for certain people to see.

The problem is that the checkboxes that were present in the access
database, are now being diplayed as yes/no on the ASP pages.

Can anyone tell me how to get the ASP pages to display checkboxes?
Sorry if this is simple stuff, but I am relatively new to ASP. Been
seraching the web for an answer, but havent bee able to find anything.
Thanks In Advance.

[Andy]

Bill,
This is simple.
The guys should not be so hard on you.
Any Access programmer should have some working knowledge os ASP.

Place this in your ASP code with each field that has a checkbox that
you are placing on the ASP page.
"field" will represent the access field.
It is referred to by the recordset name.
In most cases, it is the name of the table or query that generates the
page.
Depending on which program you used it should look like
rst!field
or
rst(field)
Both are acceptable in ASP.
Here is the code.

If rst(field) = TRUE THEN
Respone.write "<INPUT TYPE='checkbox' SELECTED>"
Else
Respone.write "<INPUT TYPE='checkbox' >"
End If

Remember that ASP will interpret YES/NO as TRUE/FALSE.

Hope this helps.
If not let me know.
Andy

[Bill Carson]

Thanks Andy.
I am going try this code tommorow and will keep you posted.

You might be able to help me with one other slight related problem.
ILL post it tommorow after im done playing around with the code.

Thnaks once again.

BC
On 8 Nov 2003 18:36:58 -0800, an*************@acedsl.com (Andy) wrote:

Bill,
This is simple.
The guys should not be so hard on you.
Any Access programmer should have some working knowledge os ASP.

Place this in your ASP code with each field that has a checkbox that
you are placing on the ASP page.
"field" will represent the access field.
It is referred to by the recordset name.
In most cases, it is the name of the table or query that generates the
page.
Depending on which program you used it should look like
rst!field
or
rst(field)
Both are acceptable in ASP.
Here is the code.

If rst(field) = TRUE THEN
Respone.write "<INPUT TYPE='checkbox' SELECTED>"
Else
Respone.write "<INPUT TYPE='checkbox' >"
End If

Remember that ASP will interpret YES/NO as TRUE/FALSE.

Hope this helps.
If not let me know.
Andy

[bcarson]

This is the line of code that was added and it works fine.

if Field.Type=11 then
GetData = "<input type=checkbox disabled name=""" &
Field.Name & """" : _

if Trim(CStr(Field.Value))="True" then GetData = GetData & " checked "
: _

GetData = GetData & ">"
However now I have another small issue:

The check boxes diplay fine with the correct data eg. check or no
check.
But each user has an edit field hyperlink which takes you to that
users information in an editable format..
When I go to edit a users information, the previusly saved checks, are
not carrying into the edit page.
I have to place the appropriate check marks again, if I dont, and then
do a save, there are no checks
in any of the boxes.

What I would like is for all the previously saved information to carry
into the edit page,including the apporpriate checks.

Is there another line of code that I am missing?

Thanks

BC