[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Why do two PC's have differences when importing the same data from the clipboard

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-08-13
I have written a routine that imports data from the clipboard into a database. I have run the exact same source data on two machines, both running Access 2007 and the data comes in differently. The difference appears to be that one is copying data from data viewed Internet Explorer and the other is using Mozilla Firefox. The difference is the way they handle a few characters. For example in one place i.e. brings in
chr(13) chr(10) chr(13) chr(10)
a pair whereas Firefox only reads
a single set.

In other places i.e. imports chr(32) whereas Firefox imports it as chr(9)

In another place Internet Explorer imports chr(32) chr(13) chr(10)
whereas firefox imports
chr(13) chr(10)

These differences make it difficult to consistently import data. Can anyone suggest how I can get around these problems given I need to substring the data meaningfully to populate fields and tables
Question by:Rob4077
  • 3
  • 2
LVL 30

Expert Comment

by:Randy Downs
ID: 35746494
make your default browser teh same on both PCs

Author Comment

ID: 35746536
That would fix it but I was hoping to be able to handle both.
LVL 30

Accepted Solution

Randy Downs earned 2000 total points
ID: 35746561
If you want to cover all bases you will need to determine the default browser and import accordingly. Basically have one import for Firefox and another for IE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 35747157
Thanks. That's basically what I had to do. I was hoping there might be a setting somewhere that made it easy.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35747226
<I have written a routine>
... Ok, so can you post the code for this "Routine" for us to evaluate?

<...that imports data from the clipboard into a database.>
What "Specifically" are you importing...?
(Give a specific example)

Using the clipboard is sometimes an unreliable way to transfer data...

Like Number-1 suggests, if the only thing stopping this from functioning consistently is users using the same browser, ...then tell them to use the same browser...
(at least when doing this specific transfer).
Just tell users:
"In order to do the ____ Transfer, you must be in FireFox"

Chr(32) is a Space character, so I am not quite sure why one browser would see it and another would not...

Anything can be done, but without seeing your current code we can't suggest anything specific.
In an overall sense, you would probably need some If-Then logic:

If Firefox then
ElseIf IE then
End if


Author Comment

ID: 35750982
Hi Jeff,
Thanks for your clarification. I have now written some code that simply replaces a few character strings to make them consistent across both platforms and then continues processing so its done.

I am surprised that the same data coming from a server to a client is actually changed (although it appears visibly identical). I would have thought that what the server sends the client displays unchanged. For that reason I asked the question hoping there would be some setting that would fix the problem. At any rate it's all fixed and working on both platforms for now.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question