473,809 Members | 2,891 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PasteAppend - Clipboard not responding

I have created an Access Front End Database that many people in one of the
departments use. Each user has their own copy of the Front End on their
Computer. The Back End is on a SQL Server.

On one of the forms I created a Duplicate Record Button using the Wizard in
Access. I have ONE user who has trouble using this button.

She uses it to copy records over and over and over. Then she changes just a
few pieces of data as needed.

She often gets one of two error messages:
The Clipboard isn't responding, so Commercial Workflow(name of DB) can't
paste the Clipboard's contents.

or

The command or action 'PasteAppend' isn't available now.

I have tried to recreate these errors on my computer with my front end. My
Front End is the master they copy from. But I can not recreate the error.

I did check a few things on her front-end and my front end and found 1
setting different
On the Clipboard there is an options button and the first setting “Show
Office Clipboard Automatically" on my front end is not checked and hers was
checked. I changed that and the next day she was still having problems.

I have done a lot of searching on this and I just keep coming up at a dead
end. Can anyone out there help me?

--
bwesenberg
MOS Master Instructor XP, 2003

Oct 11 '07 #1
2 4872
If you are using ODBC to connect to the sql server then that is probably
the source of the problem. The solution is to use ADO with sql server.
With ADO you can retrieve a record from the sql server DB and write that
record to a temp table within the Access mdb and do as you wish with it.
The clipboard should not be an issue.

If you are not an ADO user you can google ADO and get a ton of examples
on connection strings and usage.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 11 '07 #2
Rich,
Thanks for the post. I am using ODBC to connect to the SQL server.
If that is the case then why is it that 40 other people who connect the same
way do not have this issue?
Rich P wrote:
>If you are using ODBC to connect to the sql server then that is probably
the source of the problem. The solution is to use ADO with sql server.
With ADO you can retrieve a record from the sql server DB and write that
record to a temp table within the Access mdb and do as you wish with it.
The clipboard should not be an issue.

If you are not an ADO user you can google ADO and get a ton of examples
on connection strings and usage.

Rich
--
bwesenberg
MOS Master Instructor XP, 2003

Oct 11 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
11480
by: LG | last post by:
Just have a question with regards to the clipboard, and how to read what other applications (Adobe InDesignCS) place in the clipboard. I am currently in the process of creating a booklet from a database, and I need the data to be laid out in a tabular format, and set out in a specific way. At the current point in time, I am copy/pasting the raw text from the database into a table layout in InDesign. What I was thinking is that if I could...
5
4348
by: tabonni | last post by:
Hello All I am creating an ASP page. There are a list of filename and checkbox next to it. When user checked all the documents they want and click ADD TO CLIPBOARD button. All filepaths will be copied into clipboard and then they can right-click -> paste into MS Outlook as attachments. How can I use clipboardData.setData function to do that? I saw a lot of examples they are just copy and paste text.
7
11647
by: lgbjr | last post by:
Hello All, I¡¯m using a context menu associated with some pictureboxes to provide copy/paste functionality. Copying the image to the clipboard was easy. But pasting an image from the clipboard is proving to be more difficult. These pictureboxes are bound to an AccessDB. If the user wants to add an image, they select an image using an OpenFileDialog: Dim result As DialogResult = Pic_Sel.ShowDialog() If (result = DialogResult.OK) Then
7
20129
by: Dave Booker | last post by:
My Clipboard is getting into some very confused state where I can't even clear it. No applications can access the clipboard in this state, and if I run Clipboard.Clear() I get: System.Runtime.InteropServices.ExternalException: Requested Clipboard operation did not succeed. at System.Windows.Forms.Clipboard.ThorwIfFailed(Int32 hr) at System.Windows.Forms.Clipbard.SetDataObject(Object data, Boolean copy, Int 32 retryTimes, Int32...
7
3856
by: Newbie | last post by:
How do I clear the clipboard in VB.NET 2003? TIA Newbie
0
1078
by: Tom | last post by:
What is the best way to cut/copy an internal object to the clipboard and then paste it back in? For instance, I have an internal DataTable that I want to put on the clipboard, and then later on retrieve that data. I know to use ClipBoard.SetDataObject, but when I tried this and then tried to retrieve the object, I either got some error message about it (clipboard) not responding, or I would get the object back but I could never convert it...
5
3450
by: nagar | last post by:
I have a .NET 2.0 application that needs to backup and restore the contents of the clipboard. When I back it up, I use this code: DataObject oldClipboard = Clipboard.GetDataObject(); IDataObject prevClipboard = new DataObject(); string formats; formats = oldClipboard.GetFormats(); //gets all the possible formats
2
3935
by: =?Utf-8?B?SkRSYXZlbg==?= | last post by:
I have searched all over and can not seem to find an effective way to simply copy the contents of a ASP:gridview column to the clipboard based on a button or similar HTML or ASP.NET control. ASP 2.0 web application with VB.NET code developing in Visual Studio 2005 Pro. Gridview has several columns, and users need the ability to copy one of the columns to the clipboard for pasting into a separate app (that already has the ability to...
6
2431
bwesenberg
by: bwesenberg | last post by:
I have created an Access Front End Database that many people in one of the departments use. Each user has their own copy of the Front End on their Computer. The Back End is on a SQL Server. On one of the forms I created a Duplicate Record Button using the Wizard in Access. I have ONE user who has trouble using this button. She uses it to copy records over and over and over. Then she changes just a few pieces of data as needed. ...
20
7020
by: Joe Duchtel | last post by:
Hello - I have the following code to get a bitmap from the clipboard and to save it to a *.png file ... Dim lData As IDataObject = Clipboard.GetDataObject() If lData.GetDataPresent(DataFormats.Bitmap) Then Dim lPictureBox As New PictureBox
0
9600
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10114
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7651
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6880
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5548
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5686
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4331
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3860
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.