A
Amir
Hi,
my question is concerning a user level security wizard
and exporting data to word. I have a database that sends
data to word and then prints it out, here is a sample of
code:
Dim objWord As Word.Application
' Start Microsoft Word 97.
Set objWord = CreateObject("Word.Application")
With objWord
' Make the application visible.
.Visible = False
' Open the document.
.Documents.Open
("c:\AAOForms\ExParteOrderAdult.dot")
' Move to each bookmark and insert text from the form.
.ActiveDocument.Bookmarks("Division").Select
.Selection.Text = (CStr(Forms!frmExParteOrder!Division))
etc.....
This works great when executed. But the problem comes in
after I apply User Level Security Wizard. The progrram
will stop and highlight first line;
Dim objWord As Word.Application
Message says that " User-defined type not defined"
That happens only after I apply ULSWizard, before that it
works great. I have all the security needed since I
created database so that is not an issue.....
Thank you in advance
my question is concerning a user level security wizard
and exporting data to word. I have a database that sends
data to word and then prints it out, here is a sample of
code:
Dim objWord As Word.Application
' Start Microsoft Word 97.
Set objWord = CreateObject("Word.Application")
With objWord
' Make the application visible.
.Visible = False
' Open the document.
.Documents.Open
("c:\AAOForms\ExParteOrderAdult.dot")
' Move to each bookmark and insert text from the form.
.ActiveDocument.Bookmarks("Division").Select
.Selection.Text = (CStr(Forms!frmExParteOrder!Division))
etc.....
This works great when executed. But the problem comes in
after I apply User Level Security Wizard. The progrram
will stop and highlight first line;
Dim objWord As Word.Application
Message says that " User-defined type not defined"
That happens only after I apply ULSWizard, before that it
works great. I have all the security needed since I
created database so that is not an issue.....
Thank you in advance