If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Removing Lookup Field from Table
Running Access XP
How does one remove a lookup field from a table. I have gone into the relationships area and there are no relationships visible. Go into table design and try to remove the lookup field and get message have to delete relationship before continuing. Tried clicking the Lookup Tab in Table Design and changing from combo box to Text then change field property to text but get same message as above. Thanks in advance. Grant |
#3
|
|||
|
|||
Removing Lookup Field from Table
Also, make sure to scroll up and down, and right and left in the Relationships window to make sure there isn't anything your not seeing. The window is particularly large and sometimes there is a relationship out of your view that you don't realize is there.
Corrina Burnley Burnley Data Solutions www.burnleydatasolutions.com |
#4
|
|||
|
|||
Removing Lookup Field from Table
Confirmed - nothing in relationship window
In the Relationship screen under File there is a Print Relationship option and there is nothing to print. Regards Grant "Eric Butts [MSFT]" wrote in message ... Hi Grant, Have you checked the tables relationship within the Relationship window (Tools Relationship). I would suspect that the field you are trying to change is used within the Relationship window. Thereby, delete whatever relationship this table has and then close and save your changes. Then try to make whatever change you need to make to the field. I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Eric Butts Microsoft Access Support "Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com/ to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026." This posting is provided "AS IS" with no warranties, and confers no rights -------------------- | From: "Grant" | Subject: Removing Lookup Field from Table | Date: Wed, 12 May 2004 04:56:20 +1000 | Lines: 14 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 | Message-ID: | Newsgroups: microsoft.public.access.tablesdbdesign | NNTP-Posting-Host: cpe-144-137-163-97.qld.bigpond.net.au 144.137.163.97 | Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP10 phx.gbl | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:79216 | X-Tomcat-NG: microsoft.public.access.tablesdbdesign | | Running Access XP | How does one remove a lookup field from a table. | I have gone into the relationships area and there are no relationships | visible. | Go into table design and try to remove the lookup field and get message have | to delete relationship before continuing. | Tried clicking the Lookup Tab in Table Design and changing from combo box to | Text then change field property to text but get same message as above. | | Thanks in advance. | | Grant | | | |
#5
|
|||
|
|||
Removing Lookup Field from Table
On Wed, 12 May 2004 04:56:20 +1000, "Grant"
wrote: Running Access XP How does one remove a lookup field from a table. I have gone into the relationships area and there are no relationships visible. The blankety-blank Lookup Wizard often conceals the relationships it creates. Two suggestions: - Open the relationships window, select the table, and choose View Direct. - Or, run this small tactical nuclear device, probably with additional code to limit its damage, and certainly on a COPY of your database; Sub KillAllRelations() Dim db As DAO.Database Dim rel As Relation Dim inti As Integer Set db = DBEngine(0)(0) For inti = db.Relations.Count - 1 To 0 Step -1 Set rel = db.Relations(inti) Debug.Print "Deleting relation "; rel.Name, rel.Table, rel.ForeignTable db.Relations.Delete rel.Name Next inti End Sub John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#6
|
|||
|
|||
Removing Lookup Field from Table
The blankety-blank Lookup Wizard often conceals the
relationships it creates. chuckle Humm...afraid of the FCC decency crackdown John? g -- Jeff Conrad Access Junkie Bend, Oregon 1 Day Left |
Thread Tools | |
Display Modes | |
|
|