Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Pasting Data With Autonumber


Hi, I have a table holding data with each record allocated an Autonumber data type. I accidentally deleted some of these records, although they are still present in another table. How do i paste them from this other table into my current table, allowing them to keep their original autonumbers instead of just adding them to the end?

(eg - I have records with Autonumbers 1,2,3,4,5 and after deleting 3 and 4 i have 1,2,5.
I need to paste records 3 and 4 (from other table) so as they again become 3 and 4 and not 6 and 7)

Thanks.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Pasting Data From A Spreadsheet To Database
Hi there,

I have a spreadsheet which has a large amount of data. It is organnised by database structure. I'm aware of primary keys etc but what I want to avoid is creating each field as new.

For example I would like to copy the feilds from excel and paste them to create feilds in access. I'm aware that I would have to manually input any special parameters. This would save me a couple of hours.

Any help would be appreciated.

Thanks

View Replies !   View Related
Pasting Data From A Spreadsheet To Database
Hi there,

I have a spreadsheet which has a large amount of data. It is organised by database structure. I'm aware of primary keys etc but what I want to avoid is creating each field as new.

For example I would like to copy the fields from excel and paste them to create feilds in access. I'm aware that I would have to manually input any special parameters. This would save me a couple of hours.

Any help would be appreciated.

Thanks

View Replies !   View Related
Very Basic Question About Pasting Data
Hi there, and sorry for such a stupid question..

I'm just making the change from excel to access for my business.

Most things seem straightforward but I can't seem to paste a single value into multiple records.

For instance, I have a couple of hundred records. I add a new field. The first 70 records all have the same value (5) for this field. In excel I would put 5 in the top cell, copy it, select all the other cells and hit paste. Doesn't seem to work in access, just paste a single one at a time.

Best I can come up with is to copy and paste 1. Then copy and paste those 2, then those 4 and so on. This does the job for 200 records but I' wouldn't facy it for 20,000....

Is there a simple answer or is it a VBA job?

Cheers,
Dave

View Replies !   View Related
Pasting Data From Excel To Access
Hello,

I'd like an easy way for my users to be able to transfer data from Excel to Access. Basically, I'd like them to manually create a new parent record, and paste into an empty text box new child records. Then, when they clicked finish, I'd grab the info in the text box and put it in the appropriate tables. The trouble is - I have no clue how to do this. If someone could tell me how to get data pasted into a textbox into a table, I could figure the rest out. Any advice?

Thanks,
Eric

View Replies !   View Related
Autonumber PK Vs. Data PK
An easy question:

When I create dbs, I usually have to create single field tables that contain data that will never be duplicated, such as race, gender, etc. In the past I have just made the single "gender" or "race" field the primary key rather than assigned autonumber PKs to all the data. Is this the most efficient manner to do this? Are there any specific reasons I should be assigning autonumber PKs to this data?

View Replies !   View Related
New Autonumber Primary With Existing Data
Ok, here goes... I'm working on a database with 15 tables. most of the main tables have composite keys. This is probably because when it was designed there was alot of present data.

I'll call the composite keys "PrefixCode" which makes up a country & "Code" which makes up a project within that country. together they both make up a unique key, however I'd prefer to create an autonumber field (ProjectID) and have just one field key.

Here's my problem. If I make up an autofield in 'TableA' how does Access know that autoNo.1 "IND / 01" is "IND / 01" in 'TableB'?

example:
TableA and TableB both have "IND / 01" within. Because I've used the "IND" and "01" as a key Access knows that these are related records purly becuase the information was already typed in to each table. what if I have a field in TableA that has "1" (instead of "IND / 01") as the Primary key, how will TableB know that "1" is for IND / 01? is there some sort of Table/Query that can be created to make Access Identify "1" in a new field withinTableB as "IND /01"?

There are 1000's of records and it would take me too long to type in the new No. within a field in TableB by comparing what AutoNo is related to the Project codes in TableA


Hope someone can help:confused:

View Replies !   View Related
Autonumber Data/Type Mismatch
I have two tables, one has the autonumber column, sysid, and then in the process of updating the database via forms the sysid from one table is placed in another (text format). I thought I could use that to link the tables for queries, but I am running into a data/type mismatch error.

Any ideas to get around this?

Thanks!

View Replies !   View Related
Pasting To Access
hello all,
Is there any provision to copy and overwrite a particular portion of data from excel worksheets into Access table based on the primary key match.

I am using MS office 97.

View Replies !   View Related
Stupid Question: Autonumber, Legacy Data
version: access 2000.

OK, i have what may be a fantastically stupid question. i did a search (http://www.access-programmers.co.uk/forums/search.php?searchid=1806902&pp=25&page=2) on this and didn't find anything that seemd to address it.

my issue: autonumber field, sole primary key. i am adapting a legacy (non-access) db into access. it was originally an autonumber field but during import, the data type was set to number and of course, i cannot convert it back now into autonumber.

i already duped the PK field as an autonumber and tried an update query to "correct" the autonumbering PK field as i believe is suggested here (http://www.access-programmers.co.uk/forums/showthread.php?t=138484) but it won't permit me to do this.

b/c it's legacy data, i want to preserve the original values in the autonumber, but am unclear on what next steps might be available to me.

thoughts, anyone?

ed

View Replies !   View Related
Pasting To Multiple Cells - Help Please
How do I paste to multiple cells in access 2007? Basically I want to copy one
cell in the dataview and then highlight maybe 10 cells and copy the info from the one cell into the highlighted 10 cells at one time. I had no problem doing this with 2003 but in 2007 this seems to be an issue. Any help is appreciated!

View Replies !   View Related
Pasting Multiple Items.
I am trying to learn to use MS access 2007 and have a query about copying and pasting.

Is it possible to paste the same line of text into multiple lines or do I have to arrow down and paste into each individual box?? I can highlight any number of boxes in the same column but when I click paste it only pastes into the first highlighted box.

Any help would be really appreciated.

Thanks

View Replies !   View Related
Pasting To Table From Excel
Hello All,

I'm having trouble pasting a series of records of text from an excel sheet to a table in access.

The field (Instructions) in the main table gets its values from another table (Instructions) with Inst_ID(autonumber) + Text.

The (Instructions) table was constructed based on the unique values found in the pool of all records (611) in the excel sheet - 102 unique records.

The problem occurs when i paste the bulk of records (611) to the field in the main table - stating that #The text is too long to be edited"

- My Field Size for the respective field in the main table is set to "LongInteger"
- In the Instructions Table the text records are set as "Memo"

What happens is that only 529 of the 611 records are allowed to be pasted the remainder end up in the "Paste Errors" table, which i then confirm exist in the Instructions Table.

This also happens for other fields where i attempt the same approach (unique values from excel to table, then pasting of 611 records to respective field in the main table) but here i'm able to paste a mere 30, 52, ... records of the total of 611.

Reading through the forum for this subject i found that what could be done (Long Integer + Memo), I believe, has already been done.

So i was hoping someone could provide some help for this issue, or to figure out if what i'm trying to do is not possible.

It must be said that some of the Instruction's text really have a large character count but certainly less than 65,xxx (memo)


Thanks for any help provided. :)
Kind regards,
Ode.

View Replies !   View Related
Pasting Records From Excel
Hello All,

I'm having trouble pasting a series of records of text from an excel sheet to a table in access.

The field (Instructions) in the main table gets its values from another table (Instructions) with Inst_ID(autonumber) + Text.

The (Instructions) table was constructed based on the unique values found in the pool of all records (611) in the excel sheet - 102 unique records.

The problem occurs when i paste the bulk of records (611) to the field in the main table - stating that #The text is too long to be edited"

- My Field Size for the respective field in the main table is set to "LongInteger"
- In the Instructions Table the text records are set as "Memo"

What happens is that only 529 of the 611 records are allowed to be pasted the remainder end up in the "Paste Errors" table, which i then confirm exist in the Instructions Table.

This also happens for other fields where i attempt the same approach (unique values from excel to table, then pasting of 611 records to respective field in the main table) but here i'm able to paste a mere 30, 52, ... records of the total of 611.

Reading through the forum for this subject i found that what could be done (Long Integer + Memo), I believe, has already been done.

So i was hoping someone could provide some help for this issue, or to figure out if what i'm trying to do is not possible.

It must be said that some of the Instruction's text really have a large character count but certainly less than 65,xxx (memo)


Thanks for any help provided.
Kind regards,
Ode.

View Replies !   View Related
Entering Data In A Form - Update Autonumber On Two Tables?
Hello,

My first post is on something that is troubling me. I have a Form acting as the display and entry point for data for a contact list, which is composed of two Tables as follows:

Contact - (text fields including: first name, last name, phone number home, phone number work, etc)

Industry Role - (yes/no tick boxes including: film, photographer, audio engineer, producer, reporter, etc)

The two Tables have a one to one relationship based on the URN field which is an autonumber. My problem is that when someone enters say a name, and then ticks a box, the autonumber will add two entries because it seems to see the first table then the second tables as sequential, and not the same thing. How do i go about making a form that can enter new records the same autonumber for two connected Tables?

View Replies !   View Related
Stop Copying And Pasting Operation
Hi,
Am not sure if its possible with access but have a hunch that it might not be something very difficult.

I have developed an access FE/BE application (in the network). The front-end users run query and view the results fine.

They copy (ctrl-C) the data from the query datasheet and paste (ctrl-V) it to Ms-Excel which I want to stop. Is there any way that I can stop/restrict them from copying the data and pasting it somewhere else. I want to stop this operation.

Thanks in advance.

View Replies !   View Related
Problem Pasting Hyperlinks In Access
Trying to paste hyperlinks in main table - Access allowed me to paste one - using the edit-paste hyperlink function- however now and forevermore that function is "grayed out" and I can no longer paste hyperlinks - I need to past approximately 1400 hyperlinks into a table so that the user can access secure intranet sites by clicking on the appropriate field in the form view -

If I can't get this to work...is it possible to run a macro from a command button on the form to open Internet explorer, paste stated text into the address bar (example www.) and then paste data from a field in the form into the string in the address bar, and then finally, follow up with stated text.

Example would be: Field=1234567

Macro opens explorer and pastes "www.testwebpage1234567toprovepoint.com into the address bar.


thanks...

View Replies !   View Related
AutoNumber
Hello,

I have a question. I would like to be able to have an autonumber in the main form be applied to text boxes on the subform. So If I enter a name in the main form, an autonumber is generated, then that number is automatically entered into the boxes in my subform. My subform is a datasheet view with many records. I want all the records to have the autonumber generated in the main form. Is there a way to do this. Currently I have the boxes in the subform retrieve the autonumber by setting it equal to the autonumber text box on the main form. I would think that there would be an easier way to accomplish this seemingly simple task.

Thanks,

Adam

View Replies !   View Related
Autonumber
hello,
I am using SQL INSERT INTO where I insert values from my form Me!value1 etc
I have an autonumber in the table where I am using INSERT INTO, and when I exclude the autonumber it says that the number of columns does not match. I tried assigning a number manually in SQL and it works fine, but I can't use autonumber anymore. Is there a way to use autonumber and still do INSERT INTO or is there a way I can find the highest number and put the next highest in there through VBA?

Thanks in advance

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved