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 Replies


ADVERTISEMENT

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 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"123etc, 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 3 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

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

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

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

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

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

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

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

General :: Copy And Paste Records With Current Date

Sep 24, 2013

I have a database that is tracking donations for my organization. I have some members who donate the same amount every month. Is there away to copy the records and paste them with the current date in the "Date Paid" field, and do this "Update" once a month? As opposed to typing in 200 records each month? I would assume that I would have to run an update query which filters to just the members that pay each month, but the big question is how to copy and paste these records. I am using Access 2010, I have some VB ability, but not an expert by any stretch. My SQL is not strong at all either.

View 3 Replies View Related

Modules & VBA :: Copy Paste Excel File From Access

Mar 31, 2015

All I need to do is copy an excel file from a location (while coping the file, the location of the source file remains same all the time)and paste that excel file where ever I want (Browser Option) from an Access VBA.

View 4 Replies View Related

General :: Copy And Paste With VBA / Error 424 Object Required

Oct 10, 2012

I want to be able to click a field and it copies the field value. Just as if I were using Ctrl+C. THen I can go to excel or internet an paste it. i have the code:

Code:
ClipBoard.SetData = Me.GBL & vbCrLf
Me.GBL.SetFocus
Me.GBL.SelStart = 0
Me.GBL.SelLength = Len(Me.GBL)

I keep getting an error 424 Object required. How do I fix this or is this even on the right path?

View 2 Replies View Related

Modules & VBA :: Copy / Paste Field From Previous Record

Jun 22, 2013

It is a continuous subform (Names: Form = ClientUpdate / Subform = ClientUpdateSub.

All of the data implicated here is direct and in the subform's query table including the button we want to program.

(This is my example but it wont stay in columns in this "post box" )

IDNo App _ID App_Freq App_Date GetDates Action_Date
22 18 56 21-Jun-13 BUTTON 14-Jun-13
21 19 56 16-Aug-13 BUTTON 9-Aug-13

*

The GetDates Command BUTTON should generate the red data above, like:

Private Sub GetDates_Click()

Go to a new record
Go to the field App_Freq and fill it with:
Copy/paste the data from the field of the same name in the previous record
Go to the field App_Date and fill it with:
data based on this calculation using the PREVIOUS record fields: App_Date + App_Freq (which are days)
Go to the field Action_Date and fill it with:
data based on this calculation: App_Date (of current record now filled out - step above), minus 7 (days).
End Sub

That's it!

All the dates format is set to medium date. An error message should come up in case App_Freq is empty, for example

Also note that the data can be manually changed at any time and should not revert to its last calculation. The button only generate data into a new record.

View 14 Replies View Related

How To Copy / Paste Access Headers From Datasheet View

Jul 6, 2015

I have a question regarding copy-pasting the access headers. I want to copy paste Access headers from a design view from one acess file to another file in the same format. Currently I can only copy-paste them one by one. How to copy paste it column by column?

View 9 Replies View Related







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