Check if Query Result got error

P

Pau905

New Member
Joined
Nov 10, 2020
Messages
16
Office Version
  1. 365
Hello,

Are there away to check from excel vba if an query got Errors (see picture) ?

I notice when I copy (CopyFromRecordset RecordSet) the result, the data upto the errors are copied, not the data afterwards.

/P
 

Attachments

  • Error.jpg
    Error.jpg
    15.5 KB · Views: 10

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
Why do you have errors in your Access query?
What does the SQL code behind the query look like?
Are the errors in the underlying tables used in the query?
What do those tables look like?
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
ACCESS, VBA: Fetch data from sql server and paste it into local table.
Replies
3
Views
2K
Micron
M
C
  • Question
Linked Excel table in Access - field values change as I navigate?
Replies
5
Views
478
welshgasman
welshgasman
K
  • Question
Help repairing a Query Expression show records by a specified year
Replies
1
Views
459
Micron
M
E
  • Question
Run time error ‘94’ invalid use of null
2
Replies
12
Views
948
Joe4
Joe4
K
  • Question
Formatting a message for html email body
Replies
9
Views
599
Fluff
Fluff

Forum statistics

Threads
1,221,531
Messages
6,160,355
Members
451,640
Latest member
idavies1402

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top