 | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | Open Report Design View As Hidden Got anything to share on This Topic? Why not share your immediate thoughts/reaction with us! Login Now! or Sign Up Today! to share your views... Gurfateh! | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | RE: Open Report Design View As Hidden Try this code
DoCmd.OpenReport "ReportName", acViewDesign
Application.Reports("ReportName").Visible = True
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
Good luck
"James" wrote:
> Is their a way to open a report in design view as hidden? | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | Re: Open Report Design View As Hidden Are you sure about this option? Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
I didnt get any acHidden option on the OpenReport command line.
On the form Yes, but not in the report
"Dirk Goldgar" wrote:
> "James" wrote in message
> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
> > Is their a way to open a report in design view as hidden? Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
>
> Sure:
>
> DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
>
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
> | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | Re: Open Report Design View As Hidden the acHidden is not available for the OpenReport, only the OpenForm
"Dirk Goldgar" wrote:
> "James" wrote in message
> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> > Is their a way to open a report in design view as hidden? Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
>
> Sure:
>
> DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
>
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
> | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | Re: Open Report Design View As Hidden Did you have any problem using my suggestion?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
Good luck
"James" wrote:
> the acHidden is not available for the OpenReport, only the OpenForm
>
> "Dirk Goldgar" wrote:
>
> > "James" wrote in message
> > news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> > > Is their a way to open a report in design view as hidden?
> >
> > Sure:
> >
> > DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
> >
> >
> > --
> > Dirk Goldgar, MS Access MVP
> > www.datagnostics.com
> >
> > (please reply to the newsgroup)
> >
> >
> > | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | Re: Open Report Design View As Hidden It works for me, in Access 2003. Perhaps it did not in earlier versions - I
don't have an earlier version installed on this PC, so can't test that right
now.
If it isn't supported in your version of Access, try Ofer's suggestion of
setting the Visible property - it should work too. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
--
Brendan Reynolds
"James" wrote in message
news:E7D0A2CE-9F12-43BC-AF48-D4D25E21BF30@microsoft.com... Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> the acHidden is not available for the OpenReport, only the OpenForm
>
> "Dirk Goldgar" wrote:
>
>> "James" wrote in message
>> news:1DD72ED2-718E-4FBF-9E3E-C99966F3D59D@microsoft.com
>> > Is their a way to open a report in design view as hidden?
>>
>> Sure:
>>
>> DoCmd.OpenReport "Report1", acViewDesign, , , acHidden
>>
>>
>> --
>> Dirk Goldgar, MS Access MVP
>> www.datagnostics.com
>>
>> (please reply to the newsgroup)
>>
>>
>> | 
02-Nov-2005, 11:47 AM
|  | Guest | | | | | | | | | | Re: Open Report Design View As Hidden "Ofer" wrote in message
news:B7919A35-FFE3-4A52-A6D0-8E0732EB5311@microsoft.com
> Are you sure about this option?
> I didnt get any acHidden option on the OpenReport command line. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6386
> On the form Yes, but not in the report
It's most definitely there in Access 2002, as I tested it before
posting.
--
Dirk Goldgar, MS Access MVP www.datagnostics.com
(please reply to the newsgroup) | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! | (View-All)
Members who have read this thread : 0
| | There are no names to display. | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes | Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is On | | | | » Active Discussions | | | | | | | | | | | Kirtan Yesterday 21:24 PM 0 Replies, 28 Views | Panjabi Yesterday 21:22 PM 15 Replies, 299 Views | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |