Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Importing Reports through Access

Discussion in 'Information Technology' started by ryansarmy, Jul 28, 2006.

  1. ryansarmy

    ryansarmy
    Expand Collapse
    Guest

    Hello, a few months ago I started creating reports for an .MDB that
    resides on another developer's computer. Everytime we wanted to merge
    data he would import forms/reports/queries from my computer, it seems
    my reports would lose certain items. Such as the "order by" in a report
    or a query relationship. After the merge I would copy another .MDB and
    start making changes again. My question is has anyone ever had this
    problem, and I understand that Visual Source Safe is the best way to
    go. I am just trying to prove my case so we can move to that.


    Thanks,

    Ryan Sarmast
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    ryansarmy wrote:
    > Hello, a few months ago I started creating reports for an .MDB that
    > resides on another developer's computer. Everytime we wanted to merge
    > data he would import forms/reports/queries from my computer, it seems
    > my reports would lose certain items. Such as the "order by" in a
    > report or a query relationship. After the merge I would copy another
    > .MDB and start making changes again. My question is has anyone ever
    > had this problem, and I understand that Visual Source Safe is the
    > best way to go. I am just trying to prove my case so we can move to
    > that.


    Reports (for the most part) ignore the sorting of the underlying query. You
    need to set the sort order you want using the Sorting/Groupng dialog that is
    available in the design view of the report. That should definitely stay
    with the report as it is imported/exported.



    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. ryansarmy

    ryansarmy
    Expand Collapse
    Guest

    Thanks Rick, that did work through importing. I guess now I have a
    follow up question. What is the best way for two Access developers to
    work on the same MDB at the same time? We both edit tables/forms and
    reports so I guess I don't see how spliting the MDB could work. Also, I
    am new to Visual Source Safe and I have googled what I can about it,
    half of what I have read leads me to believe that two people can not
    have the same MDB checked out at the same time. Importing is not
    working for us because of the amount of changes being made to various
    objects.

    I am hoping it is a simple answer that I just don't know. Thanks
    for any help

    Ryan Sarmast
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page