Do you save copies of specific queries? etc.

[jk42]

HI!

So when BD comes to me and asks me for specific information, and I run a query to create a report, do I save the query and report that I've created? It kind of drives me crazy to have them in the navigation pane, but I didn't know if it was typical to save them? Or do you export them and save them elsewhere? Fortunately for me, I have a few more months of attempting to tweak the database design before anyone other than me will attempt to use it, but I just didn't know what was typical. I work for a fairly small company and only maybe 5 or so people will use it (don't know if that matters). would love to hear opinions! I would also like to know if anyone has any tips for how to get better at this Access stuff. I feel like I'm posting my questions on here every five seconds, and I really appreciate all the help. I'm most learning by trial and error and some reading of books and stuff on the forum. I have taken one class, and that was my first ever experience with Access. But what I learned in that class didn't really seem to help me build the database for my company, it was more of "here is how you build a query." ANyway, I really value everyone's feed back.

Thanks!

 

[CJ_London]

You should not really give users access to the navigation window - better to have a form that lists the reports they can use and they select from there.

Giving your reports and queries a standard naming structure will help to keep the db ordered - e.g.

reports for users - UsrReportName
reports in development - DevReportName
one off reports - OneReportName
Archive reports - AcvReportName

Then to list your reports you can use something like the following for the rowsource of your list or combobox

SELECT [Name] FROM MsysObjects WHERE [Type]=-32764 and ]Name] Like "Usr*"

 

[Mihail]

Or, simple, right click the report in navigation pane and choose hide.