Stop Copying And Pasting Operation

Apr 4, 2006

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


ADVERTISEMENT

Modules & VBA :: Pasting CSV Data Into Text Box And Copying It To A Series Of Text Boxes

May 13, 2014

I have a form on which there is a series of text box controls relating to different frequencies. At the moment I enter a value in to each of these manually.

However, I would like to have an unbound text box where I can paste in all the values (6 or 8 of them) from excel and then press a button and they would be copied in to the individual boxes.

So far I have my design:

I'm not sure where to start with regard to the code as I don't know how to handle delimited text - is it column delimited in excel?

I imagine some sort of loop, such as a do until will be required but again not sure.

View 2 Replies View Related

Pasting To Access

Feb 20, 2005

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 1 Replies View Related

Pasting To Multiple Cells - Help Please

Dec 16, 2007

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 1 Replies View Related

Pasting Multiple Items.

Mar 6, 2008

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 2 Replies View Related

Pasting To Table From Excel

Feb 14, 2006

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 1 Replies View Related

Pasting Data With Autonumber

Feb 13, 2007

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 2 Replies View Related

Pasting Records From Excel

Feb 14, 2006

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 1 Replies View Related

Pasting To Excel For VLOOKUP

Mar 27, 2014

I am copying and pasting the results of an Access query to Excel for the purposes of using that data as the source for a VLOOKUP. However, it seems that no matter what I do the cells that were pasted from Access do not correspond to the same values that are in the lookup table in Excel. For example, I want to find the value ABC from column A of the pasted Access data to find the corresponding ABC in the Excel array. It doesn't consider it a match even though both cells are formatted the same way. I've even gone so far to test it by putting a logical comparison of the specific cells in another cell and it claims they are not the same even though the values are exactly the same. The only thing that seems to work is if I manually type over the value pasted from Access with the same value that is already in the cell. Then the VLOOKUP works. However, I am not about to go typing all these values manually. That's why I used an Access query. How do I get Excel to recognize that these values indeed match?

View 2 Replies View Related

Pasting Data From A Spreadsheet To Database

May 23, 2006

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 3 Replies View Related

Very Basic Question About Pasting Data

Jul 23, 2007

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 10 Replies View Related

Pasting Data From Excel To Access

Mar 15, 2005

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 1 Replies View Related

Problem Pasting Hyperlinks In Access

Dec 21, 2004

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 4 Replies View Related

Pasting A Formula Into Properties Window

Apr 21, 2015

I am now trying to put in control source formulas. Like the one shown below on the far right.

I used to copy and paste them into the properties window - control source. That is not working - frequently only part of the formula gets in. The form does not work or gives bad information.

However, is that the only way that I know to cut and paste a formula into properties window?

I know that on the far right on the properties windows control source is an ellipsis (...) which opens up a window I think where could can paste the formula in.

The tutorial is here: [URL]....

Text Box
txtCustomerName
=IIf(IsNull([AccountNumber]),"",DLookUp("LastName","Customers","AccountNumber
= '" & [AccountNumber] & "'")+','+DLookUp("FirstName","Customers","AccountNumber
= '" & [AccountNumber] & "'"))

View 8 Replies View Related

Copy And Pasting Values From One Form To The Next

May 28, 2013

I currently have two forms both usedfor adding new records into two different tables. The problem I am having was first that I could not simply bring the value in the ID field over from one form to the next. Now all I would like to be able to do is copy the value in the first ID and Paste in the second ID field on the second form.

I am currently getting an error possibly because the ID field on the first form in the Primary key for the table that form is linked to, on the second form however ID field is not the Primary key, I also can't make it the primary key because their are duplicate records that I cannot delete.

So... is it possible to get around this somehow to be able to copy and paste from one form to another?

View 2 Replies View Related

Forms :: Order Form Pasting Data Into Table

Aug 20, 2013

Okay I have an Orders Form, which generates a SubTotal Price (ex VAT), VAT, Shipping & Freight Charge based on an IIF statment of being under a 50.00 order apply 20.00 charge. And finally a Order Total with it all added together. This works fine, however I cannot seem to find a way to post these prices in my Orders Table. When I click on Datasheet View for the form, all the details appear as they should.

View 3 Replies View Related

Queries :: Pasting A Query In Outlook Mail Body

Jun 3, 2014

Is there a way to paste a access query result in the outlook message body?. I do not want to attach the query result in the email.

View 8 Replies View Related

Tables :: Copy And Pasting Carry Forward Value In Same Table

Aug 24, 2013

I have a table in MS Access naming "Salutation" and in the table I have 6 columns and each column named as Week No., Carry Forward records, new records, total records, processed records and pending records. Like below

Week No. Carry Forward records new records total processed pending
1 0 10 10 5 5
2 5 10 15 7 8
3 8 20 28 9 19

So now the requirement is every day pending records should get updated in the next row with in the same table under carry forward records of its next immediate day. For e.g. pending records of week number 1 which is 5 should get updated under carry forward records for week number 2 and so on.

View 5 Replies View Related

Error When Pasting Excel File In MS Access 2010?

Sep 1, 2015

When I am working in the tutorial which is shown in the below link:

[URL]

when I copy from Clarksville.xlsx the employees names and try to paste into a new Access database*. It says:

Text is Too Long to be Edited

I am unsure what to do next to deal with this error. The internet says to increase the size of the cell where the text is being pasted. I am not sure how to do that.

View 3 Replies View Related

Forms :: Select Multiple Items By Pasting Comma Separated List

Apr 30, 2015

I have a list with 50 items in it, I would like to select some of these items by pasting in a coma separated list, is this possible?

View 12 Replies View Related

Invalid Operation

Apr 21, 2006

I am running a report from a form that is to produce an excel output:

Private Sub cmdTransferToExcel_Click()

On Error GoTo Err_CmdTransferToExcel_Click

Refresh

DoCmd.Hourglass True

DoCmd.OutputTo acOutputQuery, "Temps_Margin_Output", acFormatXLS, [Forms]![Revenue_Output]![output], False


Exit_CmdTransferToExcel_Click:
DoCmd.Hourglass False
MsgBox "File Created", vbOKOnly
Exit Sub

Err_CmdTransferToExcel_Click:
MsgBox Err.Description
Resume Exit_CmdTransferToExcel_Click

End Sub

but receive an error "Invalid Operation"

Can anyone suggest anything?

Thanks

View 1 Replies View Related

Table Operation!!

Mar 12, 2007

hello,

I have a table with "fieldA", "filedB", and "filedC". I want "fieldC" to be the result of multiplying "fieldA" and "filedB". How can I do this?? I don't want to have to type in the result in "fieldC", I want this to be done automatically when I fill up "fieldA" and "filedB."

thank you very much

View 5 Replies View Related

Parameter Operation

Oct 12, 2007

I have a calculated query field that says this:

1 wk Wins: IIf(([1 week price]-[PRICE])/[PRICE]*100>=[s],1,0)

It prompt me for the variable [s] when I run it, as it should.

However, the results for whatever I type for [s] are not the same as the results if I just put the number in the query instead, ie:

1 wk Wins: IIf(([1 week price]-[PRICE])/[PRICE]*100>=5,1,0)

The above should return the same results as if I input 5 for the parameter prompt for [s], but they do not, and I cannot for the life of tell what Access is actually doing with the number I input for [s]. I cannot see a trend in its results from record to record, it just seems random.

Any thoughts on this appreciated.

thanks,
andrew

View 3 Replies View Related

Simulating Telesales Operation

Aug 13, 2006

I have developed a MS-Access application for a small call-center (20 users).with approx 1500 customer-records to call everyday.
What I have done:
There are 20 front-ends residing at the Telecallers desktop and 1 database@server. Presently I am allocating 1500 records (clients send 1500 data everyday) everyday to 20 telecallers so that they get their respective calling details (75 records/telecaller). The no of cases that they need to call is predetermined.
They see cust-details and call up the customer manually.
What I intend to do:
I don’t want to allocate records to telecallers. Instead, when they open the FE-screen they will get the record that is available. (Of course keeping in mind that no particular record is opened by more than 1 telecaller).
Any help in this regard is highly appreciated. Any idea will encourage me to make the application more pro.

View 3 Replies View Related

Help With Structure And Order Of Operation.

Dec 21, 2006

Say I have a table full of tasks. Some tasks are performed each day (Mon-Fri, Friday only, Saturday only, etc). Each day someone has to mark which tasks were not completed, and move those to another table (?). Each task may have small changes to it (length of time, who performs the task, etc.).

There is one person tracking these 350 tasks per day, which they run a report generated from another server that tells them what wasn't completed.

I would like form to be able to show what was completed for the day (by basically subtracting what wasn't completed), as well as for a range of days.

Most of this I can do, but the basic problem is how to generate a "daily" schedule, or a list that he can select what wasn't done? I thought about make a table of days from now until about 2010, and make a query with no relationship so that it assigns a date to each entry (which creates several hundred thousand lines), but that wouldn't do because there can be change that occur for that task for one day or several months.

How does one handle reoccurring events like this? I've gotten fairly good with Access over the past several months, and 90% of what I want to do is no problem, but this one problem, with scheduling, is something I've never been able to figure out. I really need this for 3 separate projects!

The closest I've come is using an append query that pulls a date from a control on a form with a button press, and adds to a list of tasks, but I feel there should be a more elegant (and foolproof) option.

View 2 Replies View Related

Operation Must Use An Updateable Query?

Mar 7, 2006

Hello,

I was hoping someone on this forum might be able to help me.

I am trying to update a table with info in another table, using a nested query.

strSQL = "UPDATE tblTemp SET AdminNum = '" & cboAdmin.Text & "', " & _
"Size = (SELECT Size FROM tblEquipList WHERE AdminNum = '" & cboAdmin.Text & "')"

DoCmd.RunSQL strSQL

cboAdmin is a combo box on my form that is populated by tblEquipList.AdminNum.

When run this gives me:
Runtime Error '3073':
Operation must use an updateable query.

The SELECT statement works by itself, and the first part of the UPDATE (without the nested select) works by itself, but not when I combine them. I also need to update other things in the same manner in which Size is being updated, but when I can get this to work it shouldn't be a problem just added the updates for the other fields in there.

Thanks in advance,
Jeremiah


Edit:
Also, I figured I should add that when I remove the SELECT statment and put in a number (IE: Size = '400'), the query runs just fine. So I know the problem lies in the nesting, but am unsure how.

View 7 Replies View Related







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