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 Replies


ADVERTISEMENT

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

Copying And Pasting Data From One Table To Another - Version: 2000 (9.0)

Although I tried to make as similar as possible the field properties of the donor and recipient tables (e.g. 255 text, format short date, etc.) I get this msg when I try to copy and paste from one table to another. I normalized as much as possible.

Could I have missed something??

Error message:

"The value you entered isn't valid for this field.
For example, you may have entered text in a numeric field or a number that is larger than fieldsize permits."

Thanks, Ann

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

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

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

Data Entry Only Pages And AutoNumber - Version: 2003 (11.0)

I have a Data Entry Page set to Data Entry only and am using AutoNumbering in my table.

When I select the Data Entry "True" my page displays the AutoNumber as -65523
When I select the Data Entry "False" my page displays the AutoNumber correctly.

If I enter a record under the "true" setting, the table reflects the correct autonumber though.

Anyone know what I might be doing wrong to have AutoNumbering this messed up?

View Replies View Related

Import Data From Database But Keep The Autonumber - Version: 2000 (9.0)

Hi I need to import a few tables into a new database ( the layout of the tables are basically the same ) I realise you can't change a field to autonumber, but what i thought about doing was to add a new field setting this to autonumber then deleting the imported field ( if this makes sense?) but when i do this it doesn't start the autonumbers in the order i thought it would ie, number one is halfway down the table etc.... is there a way to sort the columns then start the autonumber from the top...?

Hope you can understand what I'm trying to do?

Thanks in advance

Mick.

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

SET A FIELDS DATA TYPE TO AUTONUMBER WITH A MACRO - Version: 2000 (9.0)

I am trying to add a field (CityID) to a table (Cities) and set the data type to AutoNumber. Here's the SQL I have in my macro but I get a syntax error.

ALTER TABLE Cities ADD COLUMN CityID AUTONUMBER(LONG INTEGER);

Any suggestions?

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

Copy Pasting A Table?

In VB code, how do you copy a table in your database and paste it in the same database under a new name? Any help is much appreciated.

Thanks,

-Brandon

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

Pasting In Tables - Version: 2002 (10.0) XP

Hi

I have written a fairly basic database to keep track of my companies stock. However now I am entering the data into the forms.

Many of my suppliers issue their price and stock lists in excel.

Is there any way I can copy the data in the spreadsheet and paste it into the table.

I know this sounds lazy, but it would be a lot easier.

Thanks

Chris

View Replies View Related

Pasting From Excel - Version: 2003 (11.0)

I want to know what the best bet for pasting into access is. Everywhere I read, it is recommended that you import to an existing table. However, here's my dilemma:

Our employees are emailed a list of contacts in Excel. I'm trying to create a centralized database to report on all this information. I don't want end users to have to import from excel to an access table as it requires too many steps to have the data formatted correctly.

The information in the excel chart does not contain all required information for the Contact table. For instance, one company has many contacts, and I want end users to open a form, select which company they want to add contacts to, and then paste the corresponding fields (really just a first, last, and dob). The Excel file does not have the correct company ID for each worker, so an import will not work.

I really just want them to be able to highlight the information they want to copy, switch over to the form in access and paste in (it's a subform).

Any ideas to steer me in the right direction?

View Replies View Related

Pasting In Tables - Version: 2002 (10.0) XP

Hi

I have written a fairly basic database to keep track of my companies stock. However now I am entering the data into the forms.

Many of my suppliers issue their price and stock lists in excel.

Is there any way I can copy the data in the spreadsheet and paste it into the table.

I know this sounds lazy, but it would be a lot easier.

Thanks

Chris

View Replies View Related

Pasting From Clipboard Question - Version: 2003 (11.0)

Hi, i have read serveral posts on pasting from the clipboard into a textbox control like this one:

Private Sub cmdPaste_Click()
Me!txtSample.SetFocus
DoCmd.RunCommand acCmdPaste
End Sub

it works great, but i have a form with many controls and i will be cuting and pasting most of this info from elsewhere, and i was wondering if anyone knows how i could reference a textbox control that is in focus to get the pasted text rather than hard code a single control?

Any help will greatly be appreciated.

Thankyou,
Corey

View Replies View Related

Pasting Records From One Table To Other - Version: 2000 (9.0)

Hello,

There are two tables. Table 1 and Table 2

I want to copy a field of records from Table 1 to table2

Table 1 has data like
Code:
1 somedata
4 somedata
.....
1400 somedata

The records in Table1 are not sequencial like 1, 2...Rather, they are like 1, 4, 5...

I want to copy the data of that records from Table1 to Table2 that has sequencial records (1, 2, 3). I know for this, I need to make a query but I don't know how. If I am going to copy the records manually, it will take much time since there are 5000 records.

Tanks for help in advance

View Replies View Related

Pasting Records (Excel To Access) - Version: 2003 (11.0)

Hi All,

Whenever I paste records from excel to the bottom of a ms access table my date field always gets screwy and changes from 2006-mm-dd to 1930's-mm-dd.

Why is this happening even though I format the dates in excel as custom yyyy-mm-dd.

Regards,
Aj

View Replies View Related

Problem With Copying And Pasting Table - Version: 2000 (9.0)

Hello
I have a Access database,with copies in different folders,but whenver there are some changes,if i try to copy the particular table and paste it to replace the existing one in my local drive, (by pasting the Structure and data or Appending data) i get a message called delete existing relationships.
Is there anyway to do it without deleting the relationships.
Suggest me as this would help me keep the database on my local folder updated and not disturbing the main database while we make changes to the table data or other forms or reports.
Thanks

View Replies View Related

Pasting Numbers From Access Into Excel - Version: 2002 (10.0) XP

I used to routinely copy Access (Access 97, 2000) data from tables and quries and paste it into Excel so other employees could use it for graphing or mathematical manipulation. Sometimes I would have to use Cdbl or Val functions to get formatted numbers to appear numeric in Excel.

However after my office upgraded to Office XP Professional I cannot paste numbers into Excel without them being formatted as text. The only work around I've found is to use the Value function in Excel which is really inconvenient. Am I going crazy or did something change in the 2002 versions of Excel and Access? Thanks much for any assistance.

View Replies View Related

Error Pasting From Excel To Access - Version: 2003 (11.0)

I have bumped into a big problem. I have a table in a db where most of the fields are textfields. Every day I get new information sent to me on different Excel Spreadsheet to bump into the db. All of the spreadsheets has the excact same colums as in spreadsheet view of the table. Normally the copy and paste from Excel to Access has worked wonderful, but recently after I have pasted some of the stuff it turns into squares and when I try to delete the records containing those squares it will not let me and closes Access down telling me that a sever error occured please send a report blablabla.....

Has anyone had this problem earlier?

View Replies View Related

Copying And Pasting One Record To A Group Of Other At Once - Version: 2003 (11.0)

You know in Excel how you can copy one cell and paste it to a group of other existing cells in one command. Can something as easy as that be done in Access and I don't mean the Paste Append command because the records already exist? Thanks!

RAZ

View Replies View Related

Cutting And Pasting From Word Into MS Access Form - Version: 2003 (11.0)

I have data from MS Word documents that needs to be entered onto an Access Form. When I do so, however, some of the characters change. For example, 0.250 becomes 0.250[with a thick black vertical line next to it]. It was suggested that I need to make the database ASCII compatible, but I have no idea how to do that.

Is there a relatively simple workaround, or will I simply be unable to cut and paste from Word?

Thanks in advance for any advice.

View Replies View Related







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