Who's Online
0 registered (), 1 Guest and 1 Spider online.
Key: Admin, Global Mod, Mod
Recent Posts
OLM - Custom Role based on the 'Data Security'
by Geoff_Dixon
Yesterday at 03:28 PM
Defaulting PO Information on assignment screen
by Geoff_Dixon
Yesterday at 03:26 PM
Irecruitment
by kp_rapolu
Yesterday at 01:18 PM
Heres a simple question on Workflow then ..
by natkins
14/03/10 04:21 PM
E-Bus Configuration and Management
by PeterP
11/03/10 01:28 PM
UMX : Oracle User Management Application
by natkins
11/03/10 12:58 PM
HRMS organization structures
by Geoff_Dixon
11/03/10 11:53 AM
HR_PF.K RUP4
by bcooper
10/03/10 06:50 PM
Pay_Action_Parameter
s

by John Akinyode
09/03/10 11:05 AM
Error ORA-01002: fetch out of sequence
by delboy
03/03/10 04:46 PM
Top Posters (30 Days)
CT 20
delboy 19
natkins 16
bcooper 16
MarinaH 14
Geoff_Dixon 10
SBi 10
gaztorres 8
kp_rapolu 4
Gus 4
(Views)Popular Topics
Family Pack K issues thread 5187
Review of my Release 12 laptop 3125
CREATE_GRADE api returns:PLS-00306: wrong number o 3106
Log-on problems for existing users 3007
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2368
October UK-OUG? 1977
Viewing Output of another user 1914
uploading bank branches to PAYROLL 1868
Still trying to locate... 1845
Family Pack K 1830
Topic Options
Rate This Topic
#4862 - 09/10/09 12:15 PM Web ADI not working for multiple records
MAL Offline
regular

Registered: 02/11/07
Posts: 23
Loc: Manchester
Hi,

We currently have an issue with Web ADI. The Web ADI we have produces an MS Word letter based on a custom view.

On the person form, when I query for an employee and the resultset is 1 our web ADI is working fine.

When the query returns more than one employee, the Web ADI errors. It does not download any records into the excel file and then when it tries to open the word document it asks for Header Record Delimiters?

In the excel document I get a Run-Time error '5922' Method 'Run' of object '_Application' failed.

Can anyone help with this issue?

Many thanks

Martin

Top
#4863 - 11/10/09 09:05 PM Re: Web ADI not working for multiple records [Re: MAL]
CT Offline
veteran
*****

Registered: 11/03/05
Posts: 751
Loc: Back at Fort Apache, Gosport!
Hello Martin

I looked in Metalink but couldn't see anything specific to that error number. However, as a bit of a long Shot, have you checked the security settings within Excel:

Go to Tools -> Macros -> Security

In the 'Security Level' bit, you are at least at 'Medium'

In the 'Trusted Publishers' bit, you have 'Trust Access to Visual Basic Project' enabled.

I'm not 100% confident of this as it does work for single rows, but even so, perhaps worth checking?

Good luck anyway, and if you do find the answer please share it with us!
_________________________
L&K
CT

Top


Moderator:  bcooper, CT 
March
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
Forum Stats
421 Members
48 Forums
1126 Topics
5239 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Developer - Permanent - based in Bracknell
by Geoff_Dixon
11/03/10 11:59 AM
Perm Positions 1 x HR and 1 x Payroll
by bfrost
10/03/10 05:35 PM
Top Posters
bcooper 888
CT 751
Geoff_Dixon 343
delboy 255
SBi 249
vkumar 223
kp_rapolu 203
cbrookes 197
Gavin Harris 101
jhatten 95