Who's Online
1 registered (bcooper), 1 Guest and 0 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
HRMS organization structures
by bcooper
0 seconds ago
E-Bus Configuration and Management
by natkins
Today at 02:04 PM
Pay_Action_Parameter
s

by John Akinyode
Yesterday at 11:05 AM
HR_PF.K RUP4
by delboy
03/03/10 04:51 PM
Error ORA-01002: fetch out of sequence
by delboy
03/03/10 04:46 PM
Multiple html sessions opening
by MarinaH
03/03/10 12:16 AM
Tories to revamp PAYE system
by Geoff_Dixon
26/02/10 01:48 PM
Employee to Contingent System Person Type
by CT
25/02/10 12:46 PM
Sending messages from Oracle Apps via SMS
by delboy
25/02/10 06:50 AM
Searchable Oracle Technical documentation site
by delboy
25/02/10 06:33 AM
Top Posters (30 Days)
CT 21
delboy 18
MarinaH 14
bcooper 13
natkins 13
SBi 9
gaztorres 8
Geoff_Dixon 5
Gus 4
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 5159
Review of my Release 12 laptop 3101
CREATE_GRADE api returns:PLS-00306: wrong number o 3066
Log-on problems for existing users 2996
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2318
October UK-OUG? 1954
Viewing Output of another user 1886
uploading bank branches to PAYROLL 1846
Still trying to locate... 1835
Family Pack K 1806
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
1119 Topics
5219 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
bcooper 885
CT 751
Geoff_Dixon 338
delboy 254
SBi 248
vkumar 223
kp_rapolu 200
cbrookes 197
Gavin Harris 101
jhatten 95