473,399 Members | 2,774 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Desperate! Please Help!!

KT
I realized the creator of the database I am working on used a text
field to link the main table with another table. I am trying to clean
up this table and set up an autonumber field to use as a primary key.
Is it possible for Access to look at the text field and automatically
set a numeric primary key to the record? (I have already clean up all
alphanumeric data in the text field, now it contains only numeric
data)

Sound quite impossible to me....any suggestions will be appreciated.
I am just desperate..
Nov 13 '05 #1
1 1297
ka****@rocketmail.com (KT) wrote in message news:<fe************************@posting.google.co m>...
I realized the creator of the database I am working on used a text
field to link the main table with another table. I am trying to clean
up this table and set up an autonumber field to use as a primary key.
Is it possible for Access to look at the text field and automatically
set a numeric primary key to the record? (I have already clean up all
alphanumeric data in the text field, now it contains only numeric
data)

Sound quite impossible to me....any suggestions will be appreciated.
I am just desperate..


No. You can create a temporary table of the unique values and then
write the numeric PK to the table if you want. Then relink on that.
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: JatP | last post by:
hi Everyone I am trying to create a server and client to send files from one side to the other. I can send files from one side to the other using bufferedinput/output streams but when trying to...
1
by: JM | last post by:
Hi all, Further to my mail yesterday, haven't received much help and am getting slightly worried ! I am trying to add a block of cells but sadly can't get excel VBA to exactly read my...
1
by: Sajid | last post by:
Hello! Experts, I have the following piece of code in VB.NET that I want to use to update any records in the database. I would like to use a code as well as DataGrid to update the records....
7
by: Ladysniper | last post by:
DESPERATE doesn't begin to describe it. Can someone PLEASE tell me what is WRONG with this code? Now..a bit of background. It is a search results page for http://www.azsoma.info/directory.htm....
16
by: pamelafluente | last post by:
I am still working with no success on that client/server problem. I need your help. I will submit simplified versions of my problem so we can see clearly what is going on. My model: A client...
3
by: Dameon99 | last post by:
Hi.. Im experiencing a weird error I dont know how to fix. I have a scanner object and whenever I use nextInt, anything above 3 causes the program to crash saying and links me to this line of the...
2
by: bsdixon21222 | last post by:
Ok, so I have a project that I need to do with C++. I have finished all of it, but one part. One of the fuctions (filling the array) needs to open a file for reading ( (7,16,43,23,53) etc) and output...
0
by: yjh0914 | last post by:
hi guys! so im basically editting my post i made earlier as it wznt as specific.. i have to make a program that basically ranks students by their cumulative gpa. the student's info is on a csv file...
19
by: fx5900 | last post by:
Hi, i am trying to convert an .osm (openstreetmap) file into gml format and finally to shapefile given this wiki info http://wiki.openstreetmap.org/index.php/GML. I'm using windows and when i...
4
by: kingmathyou | last post by:
I have been trying to figure it out this program for the passed two hours with no luck. It is probably very easy, but I can't figure it out. Here is what I have to do: Write a program that asks...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.