I have been asked to create an RDB for my homeowners association that has 420 lots. That number, and the addresses, will never change. The purpose of the DB is to contain contact data between the homeowners to the association. I thought I would use 3 tables to do this:
tLots (lotID, name, address,etc.) PK=lotID
Relationship: 1 lotID to many caseIDs
tCase (caseID, lotID, type, date, status, detailID) PK=caseID
Relationship: 1 caseID to many detailIDs
I would also create pass-thru queries for these 3 tables on which to base my input form and my reports.
I have done a 2-level input form (i.e. the top half shows data from tLot and the bottom half shows a table with data from tCase, but I draw a blank how to show data from tDetails in the form. Can somebody point me in the right direction? Like maybe there is a sample of this already built somewhere that I could modify? I'm using Access 2000.
I'm still very new to Access....and learning it's strengths and weaknesses. A thought occurred to me today. Currently you have to build tables and set up relationships between them in order for 'searching' or 'querying' to work effectively.
Surely...it would make sense to develop a 3D database application..ie x,y,z axis in a table. That could eliminate the need for relationships between tables, as all of your data could potentially sit in one table (or at least reduce the number of tables required in a large database).
Does anyone know if this has been considered (I'm sure I'm not the first) or if there have been serious attempts at developing the concept into an application?
I have 3 comboboxes and one button in a form. When I click on the button, it generates a querry based on the criterias selected in all the 3 comboboxes.
the generated querry gives an output something like this..
Indicateur | value1 | value2 | value3 |........... | value n
Now I want to display this selected criteria in a tabular format !!! I can use a subform, which I have used in many other forms as well, but my problem is that the querry generates different number of records everytime (as I have shown above, 'n' can have any value.) So I have to create textboxes dynamically in the form and do all sort of complex coading. I want to escape that and do something not too complex.
So I want Ideas on how do I do that? Maybe use pivot table? but I don't know how to use it and link to a table in my database??
I am designing part of my database to simply the production of predictable quotations. (and have been for the last 6 months). My quotations tend to be for one product whose price varies based on the number of software licences. In each quote there will be the price for the software and the price for installation.
I will have a TblItems. In that table will be all of the items available for quotations and may include, for example, the following
Group (5 User system) Item, Description, Price, cost
In this group there will be two matching items
On my quote form i want to have a drop down field which will allow mw to simply select the number of users and then i want Access to take any item which belongs to the 'number of users selected' to another table and i will then include a quoteID etc etc.
Can anyone advise me on, the main thing, the kind of database concept on how to achieve this please? :confused:
i need a db to monitor attendance (I know there are examples that do this but I need to satisfy my own curiosity and haven't seen one exactly like i need). My plan is to set-up the tables as below. I now have one-to-many relationships. There are many students. each student will study many courses.
I would like a form that shows the student info and a subform that shows all the courses they are on and weeks 1 -10. i could then use the yes/no attribute to record an abscence. later i would then need a query to see which students had missed two weeks in a row or more than 3 in total.
I think i need a form bound to tblStudents with a subform control that is displaying a form that is bound to tblStudentCourse. i am then a bit stuck as i need another form that will display the course records for each student. am i off track??? any ideas would be great. thanks.
Is there a way mimic the vlookup function of Excel in Access using SQL? What I am trying to do is create a table with planning values and based on the field title to grab a particular value in the two-column table.
Hi. I am trying to complete my access database by creating some security for it. I want to know how to setup the database file so when I execute, let say in my document folder so that when it opens it only shows my switchboard and not the editable(table,queries...) panel on the left hand side. I know i can hide it via the startup option but I want to completly blocking it so it doesn't allow any user to edit the design of the database. If anyone can help I realy appreciate it...thank you
how to make low security level, when i'm installing database only with access runtime? i my computer i have low level, but when I installing DB on other computer i need access to set level of database from medium to low.
hi im doing a booking database for my a level coursework, i have got everything working in the tables and queries, just need to know how i can search a query in a form using a subform, and enter a new appointment into the query and have it update the current table? ive done the subform bit before but have forgotten how lol.. help would be appreciated thanks:)
I've created some subforms and wanted to create a subform of one of the subforms. When I try that Access creates just another subform of the original parent form.
Is there a way of doing that please? It doesn't seem to be covered in the Help section.
I was wondering if somebody new how to make a query that started off asking (as parameter) for a number (this number represents the low number of performance) and the query would only show the performance below this amount. Thanks
Hi - I am an Access newbie. I would like to use Access to develop a checklist that uses a two dimensional parent table (with row and column titles) that, when a check box is selected in a given row/column location, a specific sub-table is displayed. Likewise, when certain conditions are satisfied on a given sub-table by clicking on a check box(es), I would like to indicate the status with color and/or text in the associated row/column location on the parent table. Any ideas on how to accomplish this would be greatly appreciated.
I have offered to help a local school ICT Dept with their A level projects. the first database they send me and I can't get further than the sub menus. I would appreciate any assistance as I don't know wether it is something I am doing wrong or something within the structure. I've opened it using the Shift key to look at the code and can't see anything wrong. Any help will be very much appreciated. Regards. Bernard
Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.
How can i make the following access level in a MS ACCESS 2003 database? level1----------->[Table A : Data Entry],[Table B : Only view] level2----------->[Table B : Data Entry],[Table A : Only view]
In the Components table I have the following fields: ModelType Component
In the Lot Codes table I have the following fields: Serial Number Model Component LotCode Number
I want to restrict the data in the Lot Code Table so that when a model number is entered the only possible values for the Component field is one where ModelType and Component match in the Component Table.
This sounds confusing. . .basically selecting one item drills down the options for the next.
is there a way at table level.. to set jobtotalfare as jobprice + jobcarpark because at the moment i am simply ensuring that in all the forms.. if the price or carpark is updated.. so is the total fare..
it would be much easier to do this at table level..
I was creating a human resource database for a large firm. The number of records ranges from 5000 to 6000. Initially everything went well. My designs and development were highly appreciated. But now because of just security my DB is being rejected. The problem aroused because of the security issues. I tried using the Logging On database as presented here in the Code section of this Site. But it was completely rejected by the authorities. They wanted something like following
1.The administrator has the power to give the user special privileges like mentioned in the User level security i.e making users like read-only, backup, data entry etc 2.The administrator has the power to block any user from opening any form whenever he likes.
When I presented them with the user level security as in Ms Access they were completely lost and they find it really difficult to use. Further more the names of the forms as I have used are starting with “frm” where as they want only the simple names of each form. If I start changing my form names I would complete mess up my DB
Please advice what should I do to make the user level security easy for them to use. Or how can I develop my own security system in which user can use my above mentioned points.
I have implemented user level security on a database and it seems to work fine. The issue is that every other database on that computer seems to have inherited the permissions. I only want these permissions to refer to that one database.
In my MS-Access have many Tables,Reports,Forms.Want give read,write permitions to admins’ and ‘users’ have only read permitions for reports ,Pls help me how to create permitions for admins’ and ‘users’ by login.