Using Access forms to open other documents

Thanks strive,

I think i got it working now Great help from you and Alvin!

Herman

you're welcome, Herman happy to help

btw, its ARvin...

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

wrote:
Thanks strive,

I think i got it working now Great help from you and Alvin!

Herman

Oops! My mistake Arvin :P I didn't mean to mispell your name.

I do have a followup question to add now...

Is there a way to use that api
(http://www.mvps.org/access/api/api0018.htm) and when I open the
document from within Access, have it force the file to be read-only? As
my database is to control the latest revisions of documents, I would
not want someone to open a doc and inadvertently save it after his/her
own changes. I realize that one can just set the read-only property
when u right-click on the file itself, but i was curious if there was a
way to do that in Access?

Furthermore, would it be possible to grab the file properties of any
windows registered file (i.e. .xls, .doc, etc) and update that in my
table? For example, is there a way to grab the "last modified"
information from an excel file's properties and read that into a table
in Access? Right now I am just manually typing in that info, so there
won't be any automation when the actual file is modified. That would be
a great bonus feature!

Thanks,
Herman

Hi Herman

before you shell out, make file read-only:
SetAttr "c:\path\Filename.ext", vbReadOnly

you can use GetAttr to get attributes


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

wrote:
Oops! My mistake Arvin :P I didn't mean to mispell your name.

I do have a followup question to add now...

Is there a way to use that api
(http://www.mvps.org/access/api/api0018.htm) and when I open the
document from within Access, have it force the file to be read-only? As
my database is to control the latest revisions of documents, I would
not want someone to open a doc and inadvertently save it after his/her
own changes. I realize that one can just set the read-only property
when u right-click on the file itself, but i was curious if there was a
way to do that in Access?

Furthermore, would it be possible to grab the file properties of any
windows registered file (i.e. .xls, .doc, etc) and update that in my
table? For example, is there a way to grab the "last modified"
information from an excel file's properties and read that into a table
in Access? Right now I am just manually typing in that info, so there
won't be any automation when the actual file is modified. That would be
a great bonus feature!

Thanks,
Herman

No harm.

If you want to change the file attributes, Crystal's code is the trick. If
you want to protect the document itself from within an automation instance
(in this case using an Early bound reference) try something like this code
stub:

Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application")

WordTemplate = Application.CurrentProject.Path & "\Letter.dot"

With objWord
.Visible = True
.Documents.Add (WordTemplate)

' If document is protected, Unprotect it.
If .ActiveDocument.ProtectionType wdNoProtection Then
.ActiveDocument.Unprotect Password:=""
End If

' Do something here, then

' ReProtect the document.
If .ActiveDocument.ProtectionType = wdNoProtection Then
.ActiveDocument.Protect Type:=wdAllowOnlyFormFields,
NoReset:=True
End If
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

wrote in message
oups.com...
Oops! My mistake Arvin :P I didn't mean to mispell your name.

I do have a followup question to add now...

Is there a way to use that api
(http://www.mvps.org/access/api/api0018.htm) and when I open the
document from within Access, have it force the file to be read-only? As
my database is to control the latest revisions of documents, I would
not want someone to open a doc and inadvertently save it after his/her
own changes. I realize that one can just set the read-only property
when u right-click on the file itself, but i was curious if there was a
way to do that in Access?

Furthermore, would it be possible to grab the file properties of any
windows registered file (i.e. .xls, .doc, etc) and update that in my
table? For example, is there a way to grab the "last modified"
information from an excel file's properties and read that into a table
in Access? Right now I am just manually typing in that info, so there
won't be any automation when the actual file is modified. That would be
a great bonus feature!

Thanks,
Herman

Hi Herman,

to get the modification date of a file, here is some code
you can adapt:

'~~~~~~~~~~~~~~
'NEEDS REFERENCE to Microsoft Scripting Runtime
'Tools, References from a VBA module

Dim mfile As Scripting.File

Dim fso As Scripting.FileSystemObject
Set fso = CreateObject("Scripting.FileSystemObject")

For Each mfile In fso.GetFolder("c:\path").Files

msgbox "Modified: " & mfile.DateLastModified _
, , mfile.Name

Next mfile
'~~~~~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

wrote:
Oops! My mistake Arvin :P I didn't mean to mispell your name.

I do have a followup question to add now...

Is there a way to use that api
(http://www.mvps.org/access/api/api0018.htm) and when I open the
document from within Access, have it force the file to be read-only? As
my database is to control the latest revisions of documents, I would
not want someone to open a doc and inadvertently save it after his/her
own changes. I realize that one can just set the read-only property
when u right-click on the file itself, but i was curious if there was a
way to do that in Access?

Furthermore, would it be possible to grab the file properties of any
windows registered file (i.e. .xls, .doc, etc) and update that in my
table? For example, is there a way to grab the "last modified"
information from an excel file's properties and read that into a table
in Access? Right now I am just manually typing in that info, so there
won't be any automation when the actual file is modified. That would be
a great bonus feature!

Thanks,
Herman