Who's Online
0 registered (), 3 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Recent Posts
French Localizations
by jmoyano
Today at 09:20 AM
How managers initiates SSHR request of employees
by Geoff Dixon
Today at 09:02 AM
FYI: P60s to be available in Self Service
by kp_rapolu
01/09/10 03:42 PM
SSHR Personalization requirement
by kp_rapolu
01/09/10 03:41 PM
Request for responsibility in ESS
by SBi
01/09/10 05:49 AM
Nominate for peers/subordinat for reward
by bcooper
31/08/10 07:46 PM
UK HCM Sig - 29th September
by andy.fisher
31/08/10 10:05 AM
Migration of terminated Employees
by SBi
31/08/10 10:02 AM
Worldwide Bank Details Validation
by SBi
27/08/10 02:33 PM
HTML pages popping up BEHIND Core Apps forms?
by Geoff Dixon
27/08/10 12:34 PM
Top Posters (30 Days)
SBi 28
bcooper 14
CT 12
PeterP 10
Geoff Dixon 8
Saqib Rahat 7
EBS_USER 6
kp_rapolu 5
delboy 5
MarinaH 3
(Views)Popular Topics
Family Pack K issues thread 8728
CREATE_GRADE api returns:PLS-00306: wrong number o 6046
Still trying to locate... 4588
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 4356
Review of my Release 12 laptop 4212
Log-on problems for existing users 3526
Viewing Output of another user 3213
Family Pack K 3087
October UK-OUG? 3064
uploading bank branches to PAYROLL 2880
Topic Options
Rate This Topic
#4862 - 09/10/09 01: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 10:05 PM Re: Web ADI not working for multiple records [Re: MAL]
CT Offline
veteran
***

Registered: 11/03/05
Posts: 816
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 
Oracle R12.1.1 on your existing computer
Get up and running with Oracle on your existing computer in 5 minutes

Get up and running with Oracle on your existing computer in 5 minutes!

Alard Consulting Ltd are pleased to offer Oracle R12.1.1 on your existing computer.

Connect to Oracle R12 from your computer to do client demonstrations, your own development work, or test functional setup on a Vision environment without having to install and maintain Oracle.

Backup your work before making changes in case things go wrong. Just copy the files to a new directory before making the changes. If it doesn't work, copy the files back again, all from Windows. No other skills needed.

As everything is contained on a single external hard drive, you can take it with you to use wherever you need it.

For each sale from HCMAces a portion of the price will go to the running costs of this forum.

For more information see www.alard.net/products.html.

Forum Stats
492 Members
48 Forums
1207 Topics
5710 Posts

Max Online: 51 @ 12/08/10 02:30 AM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
bcooper 944
CT 816
Geoff Dixon 354
delboy 291
SBi 288
vkumar 223
kp_rapolu 208
cbrookes 197
Gavin Harris 111
jmoyano 96
September
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