PC Review


Reply
Thread Tools Rate Thread

Changing Object Dependency

 
 
=?Utf-8?B?QU1lc3N5R3V5?=
Guest
Posts: n/a
 
      28th Mar 2007
Is it possible to change an object dependency? I can view them but I cannot
find a way to change them.

I have two reports: one for males and one for females. Each is based on a
"male" and "female" query. I needed to add a number of items to the reports.
I did this for the female report but I'd really like to avoid the tedious
task of doing it by hand for the male report. I want to copy the working
female report and just change its object dependency to the male query. Can
this dependency be changed or am I stuck just making the needed changes by
hand?

Thanks for any help you can offer.


--
Sometimes I wonder if men and women really suit each other. Perhaps they
should live next door and just visit now and then.
 
Reply With Quote
 
 
 
 
'69 Camaro
Guest
Posts: n/a
 
      29th Mar 2007
Hi.

> I want to copy the working
> female report and just change its object dependency to the male query.


Open the copy in Report Design View and open the Properties dialog window.
Select the "Data" tab and change the query name to the male query. Save it
and open it in Print Preview mode.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"AMessyGuy" <(E-Mail Removed)> wrote in message
news:FA1CF7E6-FAE0-4936-9F9C-(E-Mail Removed)...
> Is it possible to change an object dependency? I can view them but I
> cannot
> find a way to change them.
>
> I have two reports: one for males and one for females. Each is based on
> a
> "male" and "female" query. I needed to add a number of items to the
> reports.
> I did this for the female report but I'd really like to avoid the tedious
> task of doing it by hand for the male report. I want to copy the working
> female report and just change its object dependency to the male query.
> Can
> this dependency be changed or am I stuck just making the needed changes by
> hand?
>
> Thanks for any help you can offer.
>
>
> --
> Sometimes I wonder if men and women really suit each other. Perhaps they
> should live next door and just visit now and then.



 
Reply With Quote
 
=?Utf-8?B?QU1lc3N5R3V5?=
Guest
Posts: n/a
 
      29th Mar 2007
Thanks!!! I didn't see that as the solution because when I clicked on the
Data tab for the Male report it never displayed anything (not just blank
entries, no entries at all, just a gray nothing). So, I copied the Female
report and tried your suggestion--and it worked!

Thanks again.

--
Sometimes I wonder if men and women really suit each other. Perhaps they
should live next door and just visit now and then.


"'69 Camaro" wrote:

> Hi.
>
> > I want to copy the working
> > female report and just change its object dependency to the male query.

>
> Open the copy in Report Design View and open the Properties dialog window.
> Select the "Data" tab and change the query name to the male query. Save it
> and open it in Print Preview mode.
>
> HTH.
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
> info.
>
>
> "AMessyGuy" <(E-Mail Removed)> wrote in message
> news:FA1CF7E6-FAE0-4936-9F9C-(E-Mail Removed)...
> > Is it possible to change an object dependency? I can view them but I
> > cannot
> > find a way to change them.
> >
> > I have two reports: one for males and one for females. Each is based on
> > a
> > "male" and "female" query. I needed to add a number of items to the
> > reports.
> > I did this for the female report but I'd really like to avoid the tedious
> > task of doing it by hand for the male report. I want to copy the working
> > female report and just change its object dependency to the male query.
> > Can
> > this dependency be changed or am I stuck just making the needed changes by
> > hand?
> >
> > Thanks for any help you can offer.
> >
> >
> > --
> > Sometimes I wonder if men and women really suit each other. Perhaps they
> > should live next door and just visit now and then.

>
>
>

 
Reply With Quote
 
'69 Camaro
Guest
Posts: n/a
 
      30th Mar 2007
You're welcome! Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"AMessyGuy" <(E-Mail Removed)> wrote in message
news:6F5A6BC1-7DF4-4E43-B957-(E-Mail Removed)...
> Thanks!!! I didn't see that as the solution because when I clicked on the
> Data tab for the Male report it never displayed anything (not just blank
> entries, no entries at all, just a gray nothing). So, I copied the Female
> report and tried your suggestion--and it worked!
>
> Thanks again.
>
> --
> Sometimes I wonder if men and women really suit each other. Perhaps they
> should live next door and just visit now and then.
>
>
> "'69 Camaro" wrote:
>
>> Hi.
>>
>> > I want to copy the working
>> > female report and just change its object dependency to the male query.

>>
>> Open the copy in Report Design View and open the Properties dialog
>> window.
>> Select the "Data" tab and change the query name to the male query. Save
>> it
>> and open it in Print Preview mode.
>>
>> HTH.
>> Gunny
>>
>> See http://www.QBuilt.com for all your database needs.
>> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
>> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
>> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
>> info.
>>
>>
>> "AMessyGuy" <(E-Mail Removed)> wrote in message
>> news:FA1CF7E6-FAE0-4936-9F9C-(E-Mail Removed)...
>> > Is it possible to change an object dependency? I can view them but I
>> > cannot
>> > find a way to change them.
>> >
>> > I have two reports: one for males and one for females. Each is based
>> > on
>> > a
>> > "male" and "female" query. I needed to add a number of items to the
>> > reports.
>> > I did this for the female report but I'd really like to avoid the
>> > tedious
>> > task of doing it by hand for the male report. I want to copy the
>> > working
>> > female report and just change its object dependency to the male query.
>> > Can
>> > this dependency be changed or am I stuck just making the needed changes
>> > by
>> > hand?
>> >
>> > Thanks for any help you can offer.
>> >
>> >
>> > --
>> > Sometimes I wonder if men and women really suit each other. Perhaps
>> > they
>> > should live next door and just visit now and then.

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Object Dependency Tracking stefan Microsoft Access 0 11th Mar 2011 02:44 PM
Implementing Sql Object Dependency? deostroll Microsoft Dot NET 5 30th Dec 2008 04:58 PM
Object Dependency RobertG Microsoft Access Form Coding 1 7th Dec 2007 02:25 AM
Object dependency =?Utf-8?B?RG96aWVyIEAgQ29iYg==?= Microsoft Access Reports 1 29th Sep 2005 02:41 PM
Dependency Error: The dependency <dll> in project <project> cannot be coppied to the run directory becuase it would conflict with dependency <dll> Jay A. Moritz Microsoft VB .NET 2 14th Apr 2005 07:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:02 AM.