Copy From Table & Paste Problem

Mar 26, 2006

OK, here is a weird one, at least it seems weird to me.

I have a field on a table, or query result, doesn't matter which, and it looks like this:
"55264
"25468
"4562
"123
etc, etc.

Now I need to copy that and paste it into the notepad in Windows. When I do that the pasted data looks like this:
"""55264"
"""25468"
"""4562"
"""123"

I have looked at it on the clipboard and it also looks like the above. I really need this data to paste to the notepad just like it is stored on the table (with one double quote only). It's one of those strange sounding things, please do not ask me to explain why...I just need it like that.

Why the heck does the extra quote get added to the front and one get placed on the end?

Test it yourself and see.

Thanks

View Replies


ADVERTISEMENT

General :: Copy A Table And Paste With Another Name

Nov 20, 2012

I am trying to copy a table and paste as another name. I do this all the time with this table as it is a process I have to do. It is giving me a -1524 error. I also tried to export it to another database and it won't allow that either. I get the same error.

I have tried this with other tables and it does fine.

View 2 Replies View Related

Linked Table, Cannot Copy/paste New Records

Feb 16, 2006

I have an Access database with linked tables from Sybase SQL Anywhere, via an ODBC data source. I have just linked the tables recently, all the data used to be in native Access tables. It is fairly common for members of our team to open these tables in datasheet view, and copy/paste several records to create new records, then edit a few fields on the new records. This used to work fine with native Access tables, but when we try it with the linked tables we either get an ODBC error - "primary key value already exists" or the new records show up with #Deleted.

The root of the problem is this: In the old Access tables, the primary key was an autonumber field, and Access was smart enough to assign new ID's when you copy/pasted records. In the linked table, the primary key is type "Number" in Access, and Access is not smart enough to let Sybase assign new ID's when you copy/paste records in datasheet view. Access is trying to force the existing ID's into the primary key field, and Sybase says "too bad so sad".

Of course, I could just write some quick append queries to copy/paste the data. And in the short term, that's exactly what I will have to do. But is there any way, long term, to allow members of my team to do it the "quick & dirty" way by copy/pasting in datasheet view? I have tried to change the primary key to an autonumber field in design view, but Access doesn't allow that. Is there a way to do it in code, or a way to force Access to allow Sybase to always handle the primary key field?

View 1 Replies View Related

Copy / Paste Multiple Rows In A Table

Sep 12, 2011

I am trying to copy multiple rows (150+) and then paste them into the same table below the original 150 rows.I can only seem to get 1 row at a time.

View 9 Replies View Related

Cannot Export, Import, Copy/paste, Rename Table With Data!

Feb 22, 2006

Hello everyone.

I've been in a new position for a new company for less than three weeks, and I need some help.

The Access database that we use has been in operation since 2002, and it has never been Compacted/Repaired (I asked my coworkers and supposed IT people, and they said "what's that?").

After adding *one* new field, I've reached the horrific "error 3190" (max 255 fields).

I've tried all of the following, allowing at least 12 hours for them to run, but I cannot:
export the data to Excel
import the data into a new database
copy/paste the records (because there are 12100+ and the max is 9500, I think; and because of the way the dd/mm/yy converted itself to dd/mm/yyyy)
or rename the table with the data.

Please, someone help me.

View 1 Replies View Related

Copy & Paste From Access Table To Excel Without Header Info

Dec 11, 2004

Hi,

Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted.

Thanks for the help in advance.

BJS

View 1 Replies View Related

Tables :: Date Input Mask - Copy And Paste Into Preformatted Table

Aug 25, 2014

I have an excel spreadsheet i want to copy and paste into a pre-formatted table, and the excel date format is integer YYYYMMDD or today is 20140825

I can't get the input mask in MS Access 2007 to create that !

View 2 Replies View Related

Tables :: How To Remove HTML Tags Displayed In Table When Copy / Paste Data

Jan 19, 2015

When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables.

The memo field in the table is set to Rich Text and so is the text control on the form.

Below is an example of the data I'm copying from Outlook email:

Fire Alarm Activation

Actual/Smoke Present
False
Planned Drill/Testing
Evacuation

2. Utilities/Power/Communication Failure

Now, below is what it looks like in my table or output in a report:

<ol>
<ol>
<li><strong>Fire Alarm Activation </strong></li>
</ol>
</ol>
<ul>

[Code] ....

How can I copy and paste and remove the html tags?

View 1 Replies View Related

General :: Copy Single Record In A Table And Paste It Predefined Number Of Times

Sep 25, 2012

I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will vastly reduce the amount of work and time spent entering records individually.

The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cells back from Excel and then paste this range back into the Access table.

This works but is long winded; what I would like to know is is there a simply way of achieving this.

View 3 Replies View Related

Copy And Paste

Apr 5, 2006

Hi all,
I get information sent to me on email. This information then needs to be transfered onto a database. the information is always the same.
name *****
Date of birth **/*****
consultant ******
ward BLA ******

Is it possible to copy and paste all the information in one go from the email and paste everything into its correct places on a form with one action? This would save alot of time & effort on the users part.

Many Thanks

Samzie

View 14 Replies View Related

Copy And Paste?

Aug 4, 2005

To speed up my input I copy a record and paste it.

Only trouble is that I have one field in the table that is dependant on the parent table. [The customers email address which I populate with a query/combo box. There could be many, depending who the order was for.]

Q: What function could I use after the paste funtion to ammend that field automatially setting it to 'null'

Q: I looked into WM_PASTE but I'm really struggling!

Many thanks
Jon

View 1 Replies View Related

HOW DO I?: How Can I Disable The Cut/copy/paste?

Dec 8, 2005

I want to disable the user from cutting/copying/pasting the value of a text box. What is the keyAscii of SHIFT as well as CTRL so on the keypress event for that textbox I can simply set it to a null.

Or is there an easier way to do this?

View 1 Replies View Related

Copy And Paste Control At Runtime

Feb 24, 2008

Hi Guys,

I'm trying to make a report where i will have a variable number of charts. My approach is to have one "template" chart, and copy and paste it at runtime, and then alter each new chart's properties (data source, etc) to suit

My question, and i'm sorry if it's basic, is how do i copy and paste my first chart (called "Chart1") as another control named "Chart2"?

thx for the advice
Rich

View 1 Replies View Related

Copy/Paste Command On A Form

Jul 25, 2006

Copy/Paste

I have a textbox on a form that automatically shows the current date. Below that, I have 3 other textboxes for dates (each representing a step in a process). Often, the same date is imputed into each of these boxes. I would like to have an “Autofill” command button that would take the date in the first box and place it in the other three. This is so basic it’s hard. My usual searches turn up nothing. Any suggestions welcome.

View 5 Replies View Related

Disabling Copy And Paste Function

Sep 22, 2006

Hi there,

I am a database designer for a UK Insurance company and have recently needed to rebuild our complaints database. One of the problems with the previous database was that staff were copying text from an application designed by Pacific Solutions (PACSOL). When the data was pasted into our Complaints database, it was causing some serious issues that made the database crash. This had started to affect people's confidence in our ability through no fault of our own. We then found out that this was due to the character set of PACSOL not being supported by access.
What we would like to do in the new database is prevent users from copying and pasting text into the system. Perhaps by displaying an error message when they press CTRL+V or do edit - paste.

Does anyone know how this can be done?

Thanks

Gareth

View 11 Replies View Related

Running Copy Paste Outside Of Access

Mar 30, 2005

CAn i change the name of a field in a a folder from access. or better yet can i automate a file being copyed from one folder to another.

For example, lets say i have a folder named photo. i want access to find all the items that finish with a "f" and copy them into a new folder named "f_Photos"

Any Help

View 4 Replies View Related

Forms :: Copy And Paste To Form

Jul 26, 2013

I can not seem to paste text into a text box on an access 2010 form. I am however able to paste the text in a word document.

View 1 Replies View Related

Copy / Paste From CSV To Access 2010?

Dec 16, 2011

I have a handheld that downloads a CSV file which I copy and paste into an Access database. I was using XP and moved to 2010, with xp this worked great. In 2010 some fields that text and/or numbers will only copy the numbers and the field that have text will just have a blank in access. Is there a fix for this?

View 1 Replies View Related

Copy Paste Option For Attachment

Aug 9, 2011

i have a field called Attachment in a form.how can i copy and paste file into attachment without using 'Add'..Is there any query?

View 1 Replies View Related

Need Copy And Paste Adding Machine

Mar 13, 2012

I'm needing a pop up adding machine that will copy and paste a calculated value into a text box on a form when the calculator is exited....much like banking teller's have on their transaction pages.

View 1 Replies View Related

Copy And Paste In Right Click Menu

Dec 27, 2013

I am making a custom right click menu for our company database using this tutorial:

[URL] ....

The thing I can't find when making this macro is copy or paste. I want to add these to it but I can't find it using run command or anything. How to get these 2 in the menu?

View 1 Replies View Related

Access 2003 Copy Paste Problem

Mar 27, 2007

I have several Access 2003 databases that the Copy Paste functions become disabled (grayed out) on a random basis. If I reboot, copy paste are active until they are used once or twice and then they become disabled. This happened on a client´s windows xp system and my windows 2000 system. Not sure, but it may be related to the amount of data in the copy buffer.
Has there been a recent access update that causes it to not clear the copy buffer? If so, how can I clear it without having to reboot?

Help ...

View 3 Replies View Related

Copy And Paste Security Permissions From Copies Of A Db

Jul 11, 2007

I have to make a new copy of a db starting with a blank db and importing all the objects into the blank. (Corruptions issues).

When a blank db is made, and the objects imported into it, the security permissions do not copy over. The only way I know how to get the security permissions back is to redo them in the new copy. It's a big db. Lots of time. Ugh.

Is there any way to copy and paste the security permissions from one db to another?

Thanks

View 1 Replies View Related

Forms :: How To Copy And Paste From Header Into Body

Dec 30, 2013

I placed all of the fields in the Form Header. I found this when I tried to view the form in Form View I could not scroll down because of the scroll bars were missing even though the properties indicated they were both enabled.

My question is how do I move everything from the Form Header into the body? When I right click on the form and try to deselect Form Header I get a warning message saying everything will be deleted. how to copy and paste?!

View 3 Replies View Related

Copy / Paste / Rename A Field In Same Form?

Apr 25, 2014

In the Contacts database, in the Report Center form are 5 links on the right pointing to some default reports.I have created several more reports, and want to just copy-n-paste those links and then change the 'Tag' so it will point to my new report.Can you not just copy-n-paste a field within the same form?

View 5 Replies View Related

Modules & VBA :: Copy And Paste Current Record Only To Excel

Jul 13, 2014

Its been a few years since I used Access, and despite searches I cant find what I'm looking for. I have a VERY simple form, with only one record on it - "address". I have some print buttons which will print that address to different size labels, and some navigation items, but only one actual record - which is "address" (in the table, this address is a MEMO)

I would like to have a command button that when clicked copies the current record, and opens an existing Excel Spreadsheet and pastes that address into (for example) cell C8

Can it be done easily? Is there a DoCmd.TransferSpreadsheet kind of secnario that works with current record only?

View 8 Replies View Related







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