|
 |
access thread: Writing numeric data in the table instead
Message #1 by "Joseph Valdez" <e-valdez@a...> on Thu, 13 Mar 2003 15:31:54 -0800
|
|
In my class Form, I wrote the the value "P" or "L" in the text box but it
writes 1 or 0 in the database table.
Can somene explain why and how to correct this so that it will display P or
L instead ?
Is my data type wrong?
Message #2 by "Tech_Mark" <tek_mark@h...> on Thu, 13 Mar 2003 19:19:57 -0500
|
|
Joseph, what is the data type of the table field into which you are writing
this text?
Is it numeric?
If it's text, then are you copying the listbox data into a (numeric?)
variable and writing that variable into the table?
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Thursday, March 13, 2003 6:31 PM
Subject: [access] Writing numeric data in the table instead
> In my class Form, I wrote the the value "P" or "L" in the text box but it
> writes 1 or 0 in the database table.
>
> Can somene explain why and how to correct this so that it will display P
or
> L instead ?
>
> Is my data type wrong?
>
>
>
Message #3 by "Joseph Valdez" <e-valdez@a...> on Thu, 13 Mar 2003 21:55:28 -0800
|
|
It is a text field. I hae a dropdown in the form (datasheet) with a choice
of either "P" or "L".
When I choose "P" it writes to the table as 1 and "L" 0.
-----Original Message-----
From: Tech_Mark [mailto:tek_mark@h...]
Sent: Thursday, March 13, 2003 4:20 PM
To: Access
Subject: [access] Re: Writing numeric data in the table instead
Joseph, what is the data type of the table field into which you are writing
this text?
Is it numeric?
If it's text, then are you copying the listbox data into a (numeric?)
variable and writing that variable into the table?
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Thursday, March 13, 2003 6:31 PM
Subject: [access] Writing numeric data in the table instead
> In my class Form, I wrote the the value "P" or "L" in the text box but it
> writes 1 or 0 in the database table.
>
> Can somene explain why and how to correct this so that it will display P
or
> L instead ?
>
> Is my data type wrong?
>
>
>
Message #4 by "Joseph Valdez" <e-valdez@a...> on Thu, 13 Mar 2003 21:55:28 -0800
|
|
Row source type is value list.
-----Original Message-----
From: Tech_Mark [mailto:tek_mark@h...]
Sent: Thursday, March 13, 2003 4:20 PM
To: Access
Subject: [access] Re: Writing numeric data in the table instead
Joseph, what is the data type of the table field into which you are writing
this text?
Is it numeric?
If it's text, then are you copying the listbox data into a (numeric?)
variable and writing that variable into the table?
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Thursday, March 13, 2003 6:31 PM
Subject: [access] Writing numeric data in the table instead
> In my class Form, I wrote the the value "P" or "L" in the text box but it
> writes 1 or 0 in the database table.
>
> Can somene explain why and how to correct this so that it will display P
or
> L instead ?
>
> Is my data type wrong?
>
>
>
Message #5 by "Tech_Mark" <tek_mark@h...> on Thu, 13 Mar 2003 23:18:39 -0500
|
|
Joseph, you are probably writing the List Index, instead of the value
itself.
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Friday, March 14, 2003 12:55 AM
Subject: [access] Re: Writing numeric data in the table instead
> Row source type is value list.
>
> -----Original Message-----
> From: Tech_Mark [mailto:tek_mark@h...]
> Sent: Thursday, March 13, 2003 4:20 PM
> To: Access
> Subject: [access] Re: Writing numeric data in the table instead
Message #6 by "Joseph Valdez" <e-valdez@a...> on Fri, 14 Mar 2003 09:37:42 -0800
|
|
Is there a way to fix this for about 100 records displaying odd in the
table?
-----Original Message-----
From: Tech_Mark [mailto:tek_mark@h...]
Sent: Thursday, March 13, 2003 8:19 PM
To: Access
Subject: [access] Re: Writing numeric data in the table instead
Joseph, you are probably writing the List Index, instead of the value
itself.
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Friday, March 14, 2003 12:55 AM
Subject: [access] Re: Writing numeric data in the table instead
> Row source type is value list.
>
> -----Original Message-----
> From: Tech_Mark [mailto:tek_mark@h...]
> Sent: Thursday, March 13, 2003 4:20 PM
> To: Access
> Subject: [access] Re: Writing numeric data in the table instead
Message #7 by "Tech_Mark" <tek_mark@h...> on Sat, 15 Mar 2003 12:48:48 -0500
|
|
Joseph, are you trying to repair data that you've already written to the
table (and can't or don't want to go back to reenter it)?
Is so, then you can just create an Update query like
UPDATE CLIENTS SET CLIENTS.BadTextField= "L" WHERE
(CLIENTS.BadTextField)="1";
and
UPDATE CLIENTS SET CLIENTS.BadTextField= "P" WHERE
(CLIENTS.BadTextField)="0";
Does this answer your question?
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Friday, March 14, 2003 12:37 PM
Subject: [access] Re: Writing numeric data in the table instead
> Is there a way to fix this for about 100 records displaying odd in the
> table?
>
Message #8 by "Joseph Valdez" <e-valdez@a...> on Sat, 15 Mar 2003 14:40:43 -0800
|
|
I did exactly that and change it successfully. Now with new data entered in
the combobox would
that write numeric(1,0) instead of Text "P" or "L".
It is kind of weird that in the row source I had "P" and "L" and had value
list in the row type.
It seemed that formerly it was reading the the index of the combo box
options which are 0 and 1 for the table .
Can this be explained? I'm not sure why it did that.
-----Original Message-----
From: Tech_Mark [mailto:tek_mark@h...]
Sent: Saturday, March 15, 2003 9:49 AM
To: Access
Subject: [access] Re: Writing numeric data in the table instead
Joseph, are you trying to repair data that you've already written to the
table (and can't or don't want to go back to reenter it)?
Is so, then you can just create an Update query like
UPDATE CLIENTS SET CLIENTS.BadTextField= "L" WHERE
(CLIENTS.BadTextField)="1";
and
UPDATE CLIENTS SET CLIENTS.BadTextField= "P" WHERE
(CLIENTS.BadTextField)="0";
Does this answer your question?
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Friday, March 14, 2003 12:37 PM
Subject: [access] Re: Writing numeric data in the table instead
> Is there a way to fix this for about 100 records displaying odd in the
> table?
>
Message #9 by "Joseph Valdez" <e-valdez@a...> on Wed, 19 Mar 2003 10:11:59 -0600
|
|
How can you prevent that? and why that is happening?
Thanks-
-----Original Message-----
From: Tech_Mark [mailto:tek_mark@h...]
Sent: Thursday, March 13, 2003 10:19 PM
To: Access
Subject: [access] Re: Writing numeric data in the table instead
Joseph, you are probably writing the List Index, instead of the value
itself.
Mark
----- Original Message -----
From: "Joseph Valdez" <e-valdez@a...>
To: "Access" <access@p...>
Sent: Friday, March 14, 2003 12:55 AM
Subject: [access] Re: Writing numeric data in the table instead
> Row source type is value list.
>
> -----Original Message-----
> From: Tech_Mark [mailto:tek_mark@h...]
> Sent: Thursday, March 13, 2003 4:20 PM
> To: Access
> Subject: [access] Re: Writing numeric data in the table instead
|
|
|
View Cart
