asc function - code pages?

  • Thread starter Thread starter brucew
  • Start date Start date
B

brucew

Hello,
I am trying to convert an old date format that is encoded
as DOS ascii codes. I know how to convert the date, but
when I use the ASC function to get the ascii code, I get
the wrong code back. For example, if the old date is
+╝╜p, ASC("╝") returns 43 every time.

Also, I created a workaround that uses a table where I
keyed in the extended DOS ascii codes and then do an ADO
recordset lookup from a form. But the ADO rs thinks that
Ä=ä and returns 2 records. A Find Duplicates Query also
reports that these are duplicate records.

Is there a way to make Access/VB use the MS-DOS extended
code page?

Is there a way to change the way Access/VB compares values
like Ä=ä?

Thank you,
Bruce
 
Asc() returns the ASCII code for a specified character, which is the
opposite of what you want here - you want the character for a specified
ASCII code. The Chr() function does that. See 'Chr() function' in VBA help
for details.

--
Brendan Reynolds (MVP)
(e-mail address removed)

Hello,
I am trying to convert an old date format that is encoded
as DOS ascii codes. I know how to convert the date, but
when I use the ASC function to get the ascii code, I get
the wrong code back. For example, if the old date is
+╝╜p, ASC("╝") returns 43 every time.

Also, I created a workaround that uses a table where I
keyed in the extended DOS ascii codes and then do an ADO
recordset lookup from a form. But the ADO rs thinks that
Ä=ä and returns 2 records. A Find Duplicates Query also
reports that these are duplicate records.

Is there a way to make Access/VB use the MS-DOS extended
code page?

Is there a way to change the way Access/VB compares values
like Ä=ä?

Thank you,
Bruce
 
Back
Top