|
|
|
date: Tue, 25 Mar 2008 11:58:43 -0500,
group: microsoft.public.office.developer.automation
back
Re: List of all forms/reports in Access
Hi Dale,
I tried to open as a current project but doesn't let me (maybe because
access file is in accdb format?),
also when I try to query mSysObject it says that I don't have permission to
it. I am using Access 2007, and couldnât find where/how to change
permissions for systems tables. Any idea?
Thanks.
"Dale Fye" wrote in message
news:A8040EE0-23E1-4D37-8750-A2082F02D666@microsoft.com...
> Look at the currentproject.Allforms and AllReports collections.
>
> Or, you could query the system tables mSysObjects, I cannot remember the
> Type you want for forms and reports, but they should be easy to figure
> out.
>
> If the system tables are not visible in your database, go to Tools ->
> Options, and then click the View System Objects checkbox (I think it is on
> the General tab).
>
> HTH
> Dale
> --
> Don''t forget to rate the post if it was helpful!
>
> email address is invalid
> Please reply to newsgroup only.
>
>
>
> "Daniel Cigic" wrote:
>
>> Is it possible to list all forms/reports in the Access database?
>> I have seen Access.Application.DoCmd.OpenForm(string formName, ... ) and
>> Access.Application.DoCmd.OpenReprot(string reportName, ... )
>> but those method wants form/report names as one of arguments.
>>
date: Thu, 27 Mar 2008 08:49:21 -0500
author: Daniel Cigic
Re: List of all forms/reports in Access
No, don't have 2007 and don't know anything about the 2007 formats or access
to mSysObjects.
My recommendation would be to post to an Access specific forum,
microsoft.public.Access or Microsoft.Public.Formscoding would probably work.
"Daniel Cigic" wrote in message
news:68BC7832-6131-4218-BFA7-5638C4A2E065@microsoft.com...
> Hi Dale,
>
> I tried to open as a current project but doesn't let me (maybe because
> access file is in accdb format?),
> also when I try to query mSysObject it says that I don't have permission
> to it. I am using Access 2007, and couldn't find where/how to change
> permissions for systems tables. Any idea?
>
> Thanks.
>
>
>
> "Dale Fye" wrote in message
> news:A8040EE0-23E1-4D37-8750-A2082F02D666@microsoft.com...
>> Look at the currentproject.Allforms and AllReports collections.
>>
>> Or, you could query the system tables mSysObjects, I cannot remember the
>> Type you want for forms and reports, but they should be easy to figure
>> out.
>>
>> If the system tables are not visible in your database, go to Tools ->
>> Options, and then click the View System Objects checkbox (I think it is
>> on
>> the General tab).
>>
>> HTH
>> Dale
>> --
>> Don''t forget to rate the post if it was helpful!
>>
>> email address is invalid
>> Please reply to newsgroup only.
>>
>>
>>
>> "Daniel Cigic" wrote:
>>
>>> Is it possible to list all forms/reports in the Access database?
>>> I have seen Access.Application.DoCmd.OpenForm(string formName, ... ) and
>>> Access.Application.DoCmd.OpenReprot(string reportName, ... )
>>> but those method wants form/report names as one of arguments.
>>>
date: Wed, 2 Apr 2008 19:39:58 -0400
author: Dale Fye
|
|
