Reuben Cummings
reuben at gfconsultants.com
Wed Jun 15 09:57:04 CDT 2005
I think you are saying that you have a field in one table with datatype text. It is being filled by a combo box using a table with datatype number. Is that correct? I'm sure it can be done (I've been doing a lot of this stuff lately due to some new contracts we have). Send me the tables (including any relationships) offline and I'll check it out. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Rodgers Sent: Wednesday, June 15, 2005 3:32 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Updating from Text to Number data type Hi Reuben You are right, but in this case the field is linked to a lookup table. To make it 'easy', I have a field with the information I want to appear in the new lookup field. The lookup field's data type is Number. The information's data type is text, because it is text. It seems the only way is to update it all by hand because I can't change the data types ... Many thanks paul -----Original Message----- From: Reuben Cummings [mailto:reuben at gfconsultants.com] Sent: 14 June 2005 15:27 To: Access Developers discussion and problem solving Subject: RE: [AccessD] Updating from Text to Number data type I've always been able to append or update records with text and change to a number at the same time. In fact, I did a bunch last week. Are you sure all the ID's will actually convert to numbers? Or the number type is correct for the incoming data. What is A2K telling you? Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Rodgers Sent: Tuesday, June 14, 2005 8:57 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Updating from Text to Number data type I'm changing a one-table db over to a relational db. I have retained old fields with data so I can update the new look-up fields quickly. For example, Hostel records into UnitID via an update query to save doing hundreds by hand. Only ... UnitID becomes a Number data type, and Access2K won't let the data be moved across. Be most grateful for a nod in the right direction. All the best paul -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.1 - Release Date: 13/06/2005 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.1 - Release Date: 13/06/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.3/15 - Release Date: 14/06/2005 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com