How To Remove The Primary Key?

Sep 1, 2005

Hi All,

I have one serious emergency.

I have 2 options (2 qeustions) in front of me.

[1] How can I remove primary key and not the column
[2] How can I rename the column which is primary key.

Please help me.

Thanks in advance

Jigs

View Replies


ADVERTISEMENT

Cannot Remove Duplicates Using Primary Key

Mar 27, 2006

Hi all, total newb here with a question i can't find answered anywhere. (you are my only hope) This database contains over 70k records and is a collection of user registrations over the years. Heres the issue.

After running the find duplicates query and get my list (over 8000 dupes) i get a sample like below. I cannot now run the append query as every other site or article says to. I can't set the primary key to surname because there are so many records that have the same last name but diff. first name. I need it to remove the dupes based on the EditDate, keeping the newest record.

List before dedupe:eek:
IDTag..................Surname......First......... ......EditDate
37659362.............Adams.........Mary........... ...2005.10.21
57506..................Adams.........Mary......... .....2005.04.25
37661858.............Adams.........Nichole........ ...2005.06.23
37661857.............Adams.........Nichole........ ...2005.06.23
37661795.............Adams.........Nichole........ ...2005.06.17
51176..................Adams.........Nichole...... .....2005.03.16
37657399.............Adams.........Rudo........... ...2006.02.15
54640..................Adams.........Rudo......... .....2005.02.08

List after dedupe:D
IDTag..................Surname......First......... ......EditDate
37659362.............Adams.........Mary........... ...2005.10.21
37661858.............Adams.........Nichole........ ...2005.06.23
37657399.............Adams.........Rudo........... ...2006.02.15

Any suggestions?

Newb

View 4 Replies View Related

Primary Key No Longer Primary Key!

Sep 15, 2006

I have created a very simple Access database with a CompaniesTbl, ContactsTbl and CallsTbl. The database is used to record telesales contact with customers. The tables are set up like this:

The CompaniesTbl has an AutoNumber Primary Key field called CompanyID.

The ContactsTbl has an AutoNumber Primary Key field called ContactID and a foreign key called CompanyID.

The CallsTbl has an AutoNumber Primary Key field called CallID and foreign key called ContactID.

The relationships are set up in the relationships window and referential integrity imposed.

Twice now, while editing a contact record, an error has occured. Task Manager has had to be used to get out of it. The error is either a 'run-time error with a message that does not mean anything' or it says 'unrecognized database format' (!?).

If you open the database again the ContactID field in the Contacts Table is no longer a Primary Key field. If you look in the relationships window - the relationship between the Companies and Contacts tables no longer exists.

Any ideas much appreciated.

View 5 Replies View Related

Sum Of Remove

Dec 7, 2006

Hi i have created a plotchart and at the bottom of the chart it is displayed as SUM of SUM of apr 05 etc for all the months is there anyway i can remove the sum of before each month??

thanks :)

View 1 Replies View Related

Can't Remove Security

Jul 24, 2005

Hi,

I just went through the User-level Security Wizard and added security. I now can't log on using a username I created.

How can I get my database back? I have the back up file but how can I get all the stuff back without this security on the database?

PLEASE HELP!!

Cheers

Bizzy

View 1 Replies View Related

Remove Software

Oct 17, 2005

Hi

Need a little help with the following, running windows ME on a Compaq Presario Desktop, connected to Blueyonder Broadband, Blueyonder have provided a new anti virus and firewall package free of charge to broadband users, you need to remove your existing Virus and firewall package(McAfee) to load the new, which I have done, it appears that I still have remnants of a previous Norton Firewall, the only reference to it is when you access through the control panel and the add/remove programme, I have tried many times to remove it but the text is still there.

I have searched for it but nothing comes up as found.

Many thanks

Derek

View 1 Replies View Related

Remove Space

May 20, 2006

I have an enormous Post Code Table 1.7 million records, which I must update every month into usable sectors for our carrier cross refs, the UK postcode is in the format CB6 3HQ, CB6 3HR, CB6 3HS, CB6 3HT, CB6 3HW etc I need to be able to remove the space then only use the first 4 chrs ie CB63, in the above examples I know I could do a search and replace " " with "" but I need this to be run automaticly where would be the best place to do this and if coded how?

Any help or alternative suggetions appriciated

View 6 Replies View Related

Remove 1 Set Of Dup Records

Jul 22, 2005

:confused: I am importing a file from excel into access. The table has about 6300 records. Some records are duplicates or even triplicates. How do I write a querie to leave only 1 of of these records and rmove the duplicates.

Second, I will be importing new files weekly that after I do the above I will need to append to the first table and then remove duplicates. How dod I do this.


thanks

View 5 Replies View Related

Query To Remove - And /

Oct 1, 2005

I have an access database and table name called student. The table includes field name such as identification_id and registration_no. The value in identification_id is 3434-34-213 and registration_no are 234/45. Can i query the field name so i can get both value without the sign - and / so the output will be 343434213 for identification_id and 23445 for registration_no?

View 5 Replies View Related

Remove Spaces

Nov 4, 2005

Hi,

i want to replace spaces in my query, but there are a few hard parts in it.
I dont always know how many spaces. en second, the spaces that need to be replaced are after the first character. The rest needs to be removed.

i have:
----1----1----2

the "-" are spaces!!
and i want it to show
1.1.2

this is what i tried replace([MinutesID];" ";".") & " - " & [minutesTitle]

can someone assist...
thanks

View 2 Replies View Related

Need To Remove A Character

Jan 11, 2006

Hello, Tried a search but could'nt come up with an answer.

I have a number field with an amount.
The format will always change as far as the LEN is concerned.
I need to remove the decimal.
There will always be 2 numbers to the right of the decimal but the left will always change.

Example:

21543.11 Need 2154311
11.20 Need 1120


Thanks in advance! :)

View 3 Replies View Related

Remove . And BE In A Number

Mar 30, 2007

I have a big table with belgian tax numbers all in this format:

BE 401.031.867

I would like to remove the "BE" and the "." which are in this field so i have only the numbers.

Cant figure it out myself, any help would be greatly apprieciated

View 2 Replies View Related

What Is The Best Way To Remove Duplicates

Apr 12, 2007

I have a query linked to a main frame database. One of the fields is [significance] and gets a number 1-20. Usually when this data is entered, it gets multiple significance numbers. This causes my query to return separate records for each significance number. For example if case number 123 is given significance codes 1, 5 and 12, then my query returns 3 records.

I need a query that will show all records one time that have a significance code other than 12. This would be easy if there were not duplicate entries for the same case number because I could simply say "Not 12". So in the example above, my query returns 2 records showing significance codes 1 and 5. But I don't want to see the record for case number 123 because it also has a 12 significance code.

So what is the best way to handle this?

I appreciate the help.

Jim

View 1 Replies View Related

Remove Duplicates

Jun 14, 2007

If have a table with billing occurances and one of the fields is "business name" how would I need to setup a make table query which lists unique occurances within that data?

Essentially, I want to remove duplicates. If ABC Pet Store has 5 billing occurances and XYZ Pet Store has 1... I want both to only be listed once.

I hope that makes sense. Thanks for any help as to how to set this up!

View 1 Replies View Related

Remove Spaces In Between

Feb 22, 2008

Hi,

Is there a way that i can remove the space in between the cahracters of the string.

like: 78- ASDGFKGJ OR 78-SJDHF AJSDFH TO RESULT IN 78-ASDGFKGJ / 78-SJDHFAJSDFH

THANKS SO MUCH

View 10 Replies View Related

Remove Filter

Mar 15, 2005

Is it possible to remove a filter using VBA.

I need to remove a filter on a form when a user clicks on a drop down box.

View 1 Replies View Related

Cannot Remove Filter

Dec 13, 2005

Hi

When I filter on a form on our database, I cannot then remove this filter. In order to continue working i have to exit the database completely!

Please help!

View 1 Replies View Related

How To Remove DUPLICATES

Sep 3, 2004

I would like to remove duplicates from the following query. I would like it to display only one record depending on the InvoiceID. So only show one unique record based on Invoices.InvoiceID. Thanks!

SELECT DISTINCT Invoices.InvoiceID, Invoices.CustomerID, InvoiceDetails.InvoiceDetailID, Invoices.InvoiceDate
FROM InvoiceDetails INNER JOIN Invoices ON InvoiceDetails.InvoiceID = Invoices.InvoiceID
WHERE (((Invoices.InvoiceDate) Between #8/1/2004# And #8/31/2004#) AND ((InvoiceDetails.DeliverBy)=0))
ORDER BY Invoices.InvoiceID;

View 1 Replies View Related

Remove Unwanted Row

Aug 18, 2004

Hi,
I need to remove the automatic (empty) new row that access produces under the last record in the table, because i
would like to remove it when i view a query.
Could any of you kind people suggest a way that i could do this??
thanks for you help.

View 2 Replies View Related

Remove The Design Window ?

Aug 30, 2006

Is there a way to remove the design window from your project ?

I have made a program but, the problem I am having is that when
I run it and say the query results show up I close that window and
then the design window shows up. I need the close button on the
other windows but I need to block out the design window when I
use the program.
I also know about the start box where you can uncheck items and
they are removed. Am I missing something ?

thx

View 3 Replies View Related

How To Remove Access To Elements

Nov 21, 2006

I was hoping someone could let me know how I can convert my MS ACCESS database file (.mdb) so that when user(s) run/open the database, they cannot see, nor have access to the tables (which are linked from a separate DB with just the tables), forms, queries, etc... (the elements). Right now, you can open the file, the switchboard runs, but you can still see and navigate to the tables/forms/queries seen in the background.

Is there a quick and simple way to turn this into an executable-type file where you cannot see the elements in the background?

View 3 Replies View Related

How To Remove Little Replication Icons

Apr 10, 2007

Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.

View 2 Replies View Related

Remove Zero Before The Decimal Point

Mar 9, 2008

Hello,

I have a lot of values that look like this: 0.524, 0.673, and 0.398. I hate to look at these numbers with the zero before the decimal point and would like to find out how to remove them. I know that it's possible in Excel, but I'm not sure of how to do it in Access.

Is this possible?

Thanks

View 1 Replies View Related

Remove Help Combo Box From Menu Bar

Mar 25, 2008

I am using Access 2003 - by default there is a 'Type a question for help' drop down box on the menu bar - this is a tad annoying and looks similar to the 'New Mail' icon that displays from my mail client in approximately the same part of the screen....

Any ideas on how to remove the 'Type a question for help' drop down from the Access Tool/Menu bar?

Thank you.

View 2 Replies View Related

Remove Part Of A String

Feb 7, 2005

Hi folks,
I have a table with the words "Church of (whatever)" in one of the records. I am attempting to do an update query to remove the "Church of" part but leave the remaining part of the string. I am using a combination of Format and left but am not having any look. Any suggestion are much appreciated.
Thanks
Colin.

View 2 Replies View Related

Remove Ticks From A Table

Feb 8, 2006

i have a table that contains a column of Check boxes. in one of the forms i've made i need to create a button that removes the ticks from all the boxes in that column. does any one know a method that will do this.

______________________

if it isn't broken don't fix it

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved