General :: Naming Of Tables / Queries / Forms And Reports For Identification
Sep 22, 2013Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?
View RepliesIs there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?
View RepliesIm putting up my Access table/query names for critique, because at some point Ill have to hand over this database to someone else and I want to see how they might react. So if you opened a query list and saw the list below, would you be able to find your way around, or are there too many similar looking queries?
Some of the queries are made up of 6 or 7 of the other queries. I find its easier to see what going on if they are separated out into individual queries, rather than throwing them all into a single select statement, and it means I can re-use things that I know work.
I get stuck on using plurals vs singular (e.g. StoresDeductions or StoreDeductions); how much detail to put in (e.g. BrokersChainsStoresCasesByMonth); how to indicate totals or being grouped by e.g. month; how to indicate date parameters, i.e. whenever a query says MonthRange it asks for this range, and any queries built on top of this one also have MonthRange in their name.
Code:
AccountsTotalNumStores
BrokersChainDeductionsMonthRange
BrokersChainDeductionsMonthRange_Crosstab
BrokersChainNumStores
BrokersChainsTotalsByMonthRange_Crosstab2
BrokersChainTotalsByMonth
BrokersChainTotalsByMonthRange
BrokersChainTotalsByMonthRange_Crosstab
BrokersChainTotalsMonthRange
[code]....
I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.
View 2 Replies View RelatedGood morning All.
I have a database which updates via a Function in a module every morning (i.e imports and exports data).
Yesterday the DB crashed and incurred a problem. The DB was closed down and re-opened.
When it was re-opened all the Tables, Queries, Forms, Reports and Modules were no longer showing in the DB window.
When I selected the Tables tab the following message appeared:
Operation Invalid Without Current Index
this was then followed by another message:
"Isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names
This also appears if I try selecting the other tabs i.e. Queries, Modules etc.
The strange thing is the DB still updates at its stipulated time, and still imports and exports data. I am running Access 97.
Does anybody have any idea of how I can sort this out?
Regards
Chathag :confused:
I'm trying to secure my database so users can't edit tables, forms, reports, queries, etc.I'm splitting the database, making an ACCDE for users:
1. I inserted code to disable the bypass key.
2. I inserted code to hide the Quick Access Toolbar (QAT) in the On_Load sub of the form that opens with the DB.
3. Deselect Navigation Pane, Allow Full Menus and Allow Default Shortcut Menus are deselected
4. Then, I use the immediate window to show the QAT, I then create an ACCDE.
How do I link this ACCDE with the original ACCDB? Am I supposed to delete tables from the front end and link the forms/reports to the back end DB?
I'm not talking about naming conventions as in tblThis or qryThat, but I have 100+ queries, many of which do similar things from slightly different angles - e.g. a query that gives the total sales per store per month; the same query but per store per product per month; the same query but per sales manager per store per month etc. And these are then used in queries further up the tree that also have similar but slightly different results.
So is there an example database anywhere that I can download that has a decent amount of queries, and a sensible naming convention? I think I'm tying myself in knots because I have only a few tables but lots of queries (for data analysis), whereas most databases I see have lots of tables and a handful of queries.
I have taken over exisiting databases and the names for the tables,forms,queries,reports are not technically named correctly.. What would be the easiest way to rename everything accordingly:
tbl for table
qry for query
rpt for report
mcr for macro
bas for module
frm for form.
Of Course they have names but it is hard to tell when viewing a query for instance if you are looking at a table or a query.... in the SQL View.
I am exporting a single record to a spreadsheet. The code I have works fine. The problem is I want to have the spreadsheet contain the information that is in one of the forms textboxes, in this case a dogs name.
I have created a query to get the dogs name which works but I dont know how to get that query to run and then be put in the file name.
The code that I have is below
Code:
Private Sub btn_ExportDog_Click()
Dim strday As String 'The date
Dim sDest As String 'Where the file will be copied to
Dim sSource As String 'The name of the file to be copied
Dim strDogName As String 'The name of the dog that is geting exported
Dim strBackUp As String
strBackUp = "c:GPandDetectionDogTrainingLogBackUp"
[Code]...
Is it poor practice to name form controls with the same name as the field names?
View 5 Replies View RelatedIn my Frontend, i use parameters like:
1) computer name
2) a certain file's existance
So i'm sure that the front end is being run on an autherized computer.
i have hardcoded these values in the vb code and password protected the project so that no one knows about it.
what other parameters can i use to stop the front end being run from any other computer else than thoses allowed.
I have a DB with 3 tables;
1) Customer details (address, phone etc)
2) Equipment they have
3) Service History
So that I can print a report showing all of the above on a A4 form I have a simple query which filters using a tick box (on Customer Details).
This works well unless I tick 2 box's. I then customer details, equipment & Service History get jumbled up and isn't record specific.
Access 2010 doesn't seem to like the last line. It gives me an error saying the form name doesn't following access object naming rules.
Sub update_subform()
Dim dbsCurrent As Database
Dim qryD As QueryDef
Dim strSQL1 As String, strSQL2 As String, strSQL3 As String
Dim mytmp As String
Dim proc As String, myot As String
[Code] .....
I am attempting to right program for work and here is my problem. Every Unit in the Army has a Unit Identification Code and my boss wants two records of each UIC stored. But when you add a new record for that UIC he wants the oldest one purged, so he only wants 2 records on file in order to maintain some sort of volume problems. Any ideas would be greatly appreciated
SPC Joshua Ramsay
HHC 2/104th AVN FTIG
I currently have 3 spreadsheets with simliar information. How can I take a database and export only select fields to make either a report or table? Here is the example with types of info i will be using:
100 communities and all their roads. Each of these communities are in a borough, which is then in a region.
Then we have a mileage for each road. Where I have difficulty is that we have another set of data that would be fine if we could just include into this which is all of those roads but additionally they have:
Classification
Surface type/condition
Traffic count
Some roads have two classifications.. each of those having a mileage. I would really like to see all of this data in a database that spits out the needed tables and totals.
Is there possibility to do unambiguous identification of file in vba ? I mean this :
- at the beginning you have file on hard drive, ex. : aaaa.doc
- some time later you will do some change, for ex: change of its name to bbbb.doc or you add some text in word document ...
I need to do some code for finding files although their names or content was changed.
I was recently doing a little Spring Cleaning in my database and deleting old tables and queries that were no longer used or had been for experimental purposes. Unfortunately, I unknowingly deleted a query that was being used by a report I still needed and it took me several hours to find and correct the problem.
Not wanting to repeat this mistake, I began searching for a way to display my reports, queries, and tables and all the objects each is linked to. I thought it would be nice, for instance, to have a hard copy list of all my queries that showed where they are derived from and what other objects reference them. Is there a way to do this?
I've tried using the "Relationships" button and working with the Documenter, but I haven't found what I'm looking for. I have also tried a Google search, but, admittedly, I may not be using the proper terminology to get good results.
Thanks for your time.
Hi all,
I'm trying to create a database to track all the students details, I've created the data base with all the tables, relationship etc. i tested it with dummy data too and it worked fine.
I then imported the proper data from a .csv file, using the "File-Get External Data-Import" method rather than a macro, it imports the data with a couple of errors but the data still got through, i had previously created queries and reports and they worked fine with the dummy data but will not show any of the new imported data, its like it hasn't got a link or something but if i create a linked form, it will pick up the data, meaning the relationships are working. hence my problem
Thanks
Dellero
Whenever I create a new query or report, it automatically becomes Hidden, and the only way that I can see it (still as hidden) is to close out of Access and then go back in.
View 2 Replies View RelatedI need to know if possible to create multiple queries or reports at the same time. We have large table that is updated monthly this report gets broken down manually by Manager (30 managers in total) hen email to each manager.
Report or query specs will never change only the data I could do this manually create and save query/report for each manager once but I was wondering if there was code that will create all the queries and reports at the same time.
I have an A2007 database used for time and billing. As time goes on I've had to add more forms and especially more reports. I feel the because of all these "additions" the FE is getting a bit bloated, something like 2.2MB right now.What I want to inquire about is the possibility of moving at least some (if not all) of the forms and reports to another FE and can this be done without having to move tables and/or queries?
The navigation pane is "hidden" from the users so they don't see all the tables, queries, forms and reports but some are smart enough to figure out to "unhide" the navigation pane.Concerning the forms; there are certainly some forms that I do not want other users to open out of curiosity, or for whatever other reasons they might have, so these I would want to move. The same basic reasoning would apply to the reports.
My thinking would be this; move a particular form/report to a separate FE that merely acts as a "bucket" to store the form/report. Clicking on the control in the main FE would open the form/report stored in the other FE using the tables and queries in the main FE.can it be done without having to re-write a bunch of code? I know I can add code so certain controls aren't visible to certain users but I've not found a way to permanently lock and hide the navigation pane.
I have a small database I am building to log and record Calibration Details Of thermometers etc. I have several table that are related, no probs so far.
However I am struggling with forms and reports that use data from the asset table more than once. IE. I have a calibration unit (this is an asset as this also needs calibrated ) that I use to test the thermometers (These Are Assets) but this is also in the same asset table as the thermometers. I need to reference the Calibration unit and the thermometer or whatever item I am testing on the same form or report. I seem to have got round the form problem but i am stuck on the report as access keeps linking to only one item, how do I make it link to 2 items on the same table on the one report.
I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic.
However, management would like to have one record per lesson, which means that up to eight students would need to be accounted for.
Adding additional Student_IDs to the lesson record table and the associated links to the student table was simple. Inputting lesson information was pretty straightforward.
The problem arises with output. There is one report to review an individual student's past lessons. Also, there is a form in which to export the lesson's public comment.
Both use different queries, but with the same name as the form and report.
Both the report and exported Excel file are blank, no data.
I'm building this in A2010, but saved as A2003 (working environment).
Is there a way to securely block the access of user to tables/queries, else in Microsoft Access?
View 6 Replies View RelatedI understand the principle of renaming the above of using the navigation pane and selecting the object but what is happening in my case is that when I select the specific table/query I wish to rename, the text is highlighted as per normal but the instant I move the cursor onto that cell that whole panel highlights in red and then reverts back to the original state of just the text in that panel (now highlighted).
I do not know if this is related to the problem but I have a text box with the "code" =Count([tblEntries].[CageNo]).
This was working perfectly okay but both this and the renaming appeared to happen about the same time. I have opened other Access files and the same re the renaming occurs. I have secure security running and do not think this could be the problem but anything is possible.
I have created a small database, and created a Main Menu (form), the main menu starts as soon as someone start my database, i have linked up all my forms & reports into this main menu. now i want to hide left panel bar that shows all the table, quires, forms & reports files (so nobody can access tables, quires, etc from that panel).
View 1 Replies View RelatedI KNOW I'm making this harder than it needs to be.... I have a union query that pulls from two sales tables. I'm setting up a report where a person can select a manager name, start date, and end date for those union'd sales. I can do all this no problem in the query, but I want to be able to have this information selected on a form, instead of through popups, to bring up the report. How do I link the form information to the query? I can't get the report to show information it "read" from the form. Does that make sense?
Please help!