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...
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.
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?