Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    18

    Unanswered: Create External database/report in Access?

    A little background info so you know my situation. Skip ahead if you don't want to read this part. I have this Access (2003 I think, have to check into it) database that we use at work. I am pretty good with Access and visual basic, and would like to create a report just for my department that would pull some info from the database. Currently we use an Excel document and input the info manually about 3-4 times a week. I would like to automate this so that I could just open the report and print it out, because the info we need comes from multiple forms and another report. The first problem is that the database was originally created by an outside company that is no longer in business, so I can't just call up someone in the tech department and ask them about this. The second is that this is something to make my and my co-workers job easier, and if I did call someone they would most likely just say its not a necessity or a priority so forget about it. This is something I am willing to do in my spare time at home, and it's only a simple report if I could just figure out how to do it. Now for the question...

    My question:
    First off, is it possible to create an external report to get info from an existing database? How would I go about that? Second, there is no menu on this database, so is there a way using a key combination possibly, to get into the edit portion of the database? I do not want to edit anything here, but I would need the names of the tables and the fields that I need to pull the values from.
    If this is possible, I assume I just create a query linked to the database tables, throw the fields into a report I create, and then bring it to work and open it and it should work? I assume I also need the filepath of the original database in order for my database to find it, correct? Anything else I am missing here?

    I am not trying to gain information that I am unauthorized to have or anything, like I said, I just think that instead of spending 30 mins a day manually going through multiple reports and forms, it would be much easier and quicker to open an external report and click print. Any help is greatly appreciated.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, you can create queries and then create reports from them.

    Depending on how this company did things, you may or may not be able to get to the design screens.

    What you should be able to do is create a new database and link the tables of your existing database into it. Then you should be able to create any reports and queries you like.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2009
    Posts
    18
    Any hints on how I can get to the design mode, or open the database window? There are no menus, when the database is started it goes straight to a login screen, then from there it opens the main form which contains subforms. I'll give F2 and F5 a shot tomorrow at work and see what happens. If that doesn't work, is there anything else I can try? Also, on my computer here at home I have Access 2007, but the database at work uses 2003. I don't think I should have any issues for what I need to do. I might see if I can find a small program to convert 07 to 03 if need be. Anything else I should know about before jumping into this project?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    1. You might be able to get access to the design screens. As I said, it depends on how it was set up.

    2. No conversion tools will help if the db was securely designed.

    3. Make sure you are well versed in Access before committing to a development project.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •