By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,290 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,290 IT Pros & Developers. It's quick & easy.

Migrating Access Program to ASP have problems with Yes/No Field

P: n/a
A P
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and
web browser for encoding to the database.

Hope you could help me.

Me
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <ap@textguru.ph> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and web browser for encoding to the database.

Hope you could help me.

Me

Jul 19 '05 #2

P: n/a
A P
I tried to access certain field with Yes/No data type from MS Access but IE
gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...
The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <ap@textguru.ph> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation

and
web browser for encoding to the database.

Hope you could help me.

Me


Jul 19 '05 #3

P: n/a
It's hard to say without seeing what your query is, i.e.

Response.write sqlString
response.end

Try using:

where fieldname=true

instead of
where fieldname='true'
if that's what you were using.

Ray at home

"A P" <ap@textguru.ph> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...
I tried to access certain field with Yes/No data type from MS Access but IE
gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...
The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <ap@textguru.ph> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
> I am planning to migrate my exisiting MS Access program that uses
> yes/no
> fields (checkbox). Can ASP identifies checkbox field of ms access? I am
> planning to use the same database and use msacess for report generation

and
> web browser for encoding to the database.
>
> Hope you could help me.
>
> Me
>
>



Jul 19 '05 #4

P: n/a
A P
The error was gone but I think the query cannot find what I'm looking for.

SELECT * FROM tblform WHERE Served = True

Note that Served field is a Yes/No MS Access Data Type.

Me
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:u9*************@TK2MSFTNGP12.phx.gbl...
It's hard to say without seeing what your query is, i.e.

Response.write sqlString
response.end

Try using:

where fieldname=true

instead of
where fieldname='true'
if that's what you were using.

Ray at home

"A P" <ap@textguru.ph> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...
I tried to access certain field with Yes/No data type from MS Access but IE gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...
The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <ap@textguru.ph> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
> I am planning to migrate my exisiting MS Access program that uses
> yes/no
> fields (checkbox). Can ASP identifies checkbox field of ms access? I am > planning to use the same database and use msacess for report generation and
> web browser for encoding to the database.
>
> Hope you could help me.
>
> Me
>
>



Jul 19 '05 #5

P: n/a
You need to use the numeric representations of true/false:
SELECT * FROM tblform WHERE Served = -1

Bob Barrows

A P wrote:
The error was gone but I think the query cannot find what I'm looking
for.

SELECT * FROM tblform WHERE Served = True

Note that Served field is a Yes/No MS Access Data Type.

Me
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote
in message news:u9*************@TK2MSFTNGP12.phx.gbl...
It's hard to say without seeing what your query is, i.e.

Response.write sqlString
response.end

Try using:

where fieldname=true

instead of
where fieldname='true'
if that's what you were using.

Ray at home

"A P" <ap@textguru.ph> wrote in message
news:eK**************@TK2MSFTNGP12.phx.gbl...
I tried to access certain field with Yes/No data type from MS
Access but IE gave me an error message:

Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.

What do I need to do?

"David Morgan" <da***@davidmorgan.me.uk> wrote in message
news:e4**************@TK2MSFTNGP09.phx.gbl...
The answer is yes.

When testing for 'yes' you would say

WHERE Field = 1

Or

WHERE Field = 'True'
"A P" <ap@textguru.ph> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
> I am planning to migrate my exisiting MS Access program that uses
> yes/no
> fields (checkbox). Can ASP identifies checkbox field of ms
> access? I am planning to use the same database and use msacess
> for report generation and web browser for encoding to the
> database.
>
> Hope you could help me.
>
> Me


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.