Hello all,
Using Access 2003, I am creating a db that tracks computers along with what switch and port they are connected to.
I have 5 different networks along with 31 switches.
I have a cascading combobox, in my form, that gives me a list of what switches correspond with the network chosen.
What I would like it to do is give me a list of ports that are open/available based on the switch (available ports ranging from 24 to 48 based on the switch).
Creating 31 tables is a little excessive and I really don't want to have to do that.
Tables I have so far:
tblComputerMaster -
tblNetwork
tblSwitch
along with a few others that don't pertain to the question.
I can dummy down my db if someone needs an example. If anybody has any ideas on how this would be possible I would really appreciate it.
I have a simple, simple query based on a linked SQL table with a date/time field called "CHANGEDT." All I want to do - as I have done many times before - is to set criteria for that field of Date()-10 (records changed 10 days ago). Every time I get an empty data set, even though I know there are records in the table for the target date. There are no other criteria in this query, no linked tables or anything like that - just a siiiiiiiiimple query! Sheesh!
What would make a query NOT respond as expected when calculating a date 10 days in the past? I'm thinking that my frustration is causing me to overlook something obvious.
Ok... I have notice that every body and their dog has asked this question and reading all the other posts has helped me along. However i have hit another roadblock. I know that IT IS possible to have a combo box that, when an item is selected, selected fields are automatically filled. Is it possible though to have those auto filled fields retained when a new record is selected in the form.??
Eg. I have a table with model#s of a product aswell as unique properties of each model...I set up a form with a combo box to select the model# and auto fill the properties of that model into the fields below. when i change the record (record selectors <- ->) the combo box and related fields stay the same. can i make it so that each record is saved idividually and still use the autofill by combo box ....
man i dont even know if this is gonna make sence to anyone...but if it does any help would be extremly appreciated.
I've looked at so many options for writing this query that I can't see the forest for the trees and hoping you kind folks will point me in the right direction.
service_id is a unique ID for each service which relates to data I will need to pull from another table.
prop_id relates to a property ID in another table, not unique as multiple services against one property.
The problem that I have is that each prop_id can have more than one service_date for the same service_year. I need to be able to find the latest service_date on a prop_id and its associated service_year and service_id.
Any pointers would be greatly appreciated. BTW, using this in Access 2003 & 2007
I'm trying to copy the structure of a table to make a temp table. I'm using CopyObject (which also copies the data). So when I delete the data from the temp table, it also deletes data from the source table. Is the data linked? It should just be deleted from the temp table. Below is the beginning of the code. I've stepped through, and at the last step shown, the data in the source table deletes.
Code: Dim strFile As String Dim temp As String Dim tbl As String Dim db As DAO.Database
An engineer requests that “x” amount of computers are ordered for the company. The estimated costs of the system(s) are determined. The estimated cost of the systems is forwarded to a manager, and the request must be approved by a manager before the order is placed. Once the manager approves the request, the order is placed through the ordering company. After the ordering company approves the order, an order number is assigned and serial number(s) specific to each computer is associated with that order number. At this point it is possible to track the order status via existing programs using the assigned order number and serial numbers. After it is determined through the existing software that the order has been shipped, invoiced, and received by the Receiving department, I need to physically go pick up the systems and submit them into my Central Inventory. From the central inventory, systems will be checked out to employees as needed, checked back in when testing is finished, or transferred internally between employees......
Please, I really need some help with my normalised tables and relations:
1.AdmissionID AdminYr .......
2.StudID SName AdminID .........
3. ParentContactID Fname StudID
4. CycleNO cycname .....
5. DisciplineID Discname CycleNo StudID .......
6.SubjectID subName DiscID ....
7. ExamID examdate StudID
8. Results StudID ExamID mark ......
I have a feeling this relationship, is still a bit messy?
I also need to keep track of students daily class attendance, at the end of the tern, or year to find out how many students dropt out of a particular class etc. Is this a new table?
I have been reading up on normalizing table structures. I have this database that I am working on, to work as a hiring database. It should hold information about people applying to the law firm I work at.
I am looking for advice on if this table structure is normalized and sound. I am also looking for specific help on creating good forms.
Thanks for any help that can be given!
ps. I am attaching a zip that has a jpg view of the tables and their relationships, as well as the db with the table structure.
I would love any and all advice. I want a very clear concept for this db before I do anything!
I was having a discussion with a friend of mine about this... and I couldn't come up with the best explination. Hopefuly someone here can point me in the right direction.
I don't believe that this is the proper way to create a table. What happens if you happen to come across a Recipie that needs 6 items?? or more?? After researching it, I believe it violates 2NF. Is this correct?
one customer can have more than 1 apartments, and one apartment can be transfered to another customer (file# same but customerID changed) one customer is paying different types of payments against his apartment.
please help me to manage tables and relationships.
I need some help trying to setup tables on a new database. I want to setup a house analysis database where I can evaluate each room for it’s condition broken down by feature. I can’t seem to figure out a good way to tie all the rooms and evaluations back to that house’s address (primary key). I want the fields to work as shown below with the room evaluations tracked to each room and house address. If possible I would like to be able to enter the as many room names as needed for each address.
Company Company ID Program A Program B Program C Program D 2000 2001 2002 2003 2004 2005 The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to 2005, Program D participanted in Company Z from 2001 to 2002.
Should I have a table with the Companies and Program A and the years from 2000 to 2005 and a table for the Companies and Program B and the years, etc? I was going to add a yes/no field for each program, too. There must be a simplier way.
I want to be able to query participation of workers in any of the programs.
Hi, Thanks for taking time out reading my thread! I want to start entering data, but i'm not to sure weather my relationship structure is good enough to start inputing.
Heres a pic of my relationships http://img201.imageshack.us/my.php?image=almostdoneae0.jpg
i have been asked to design an access databse for a friend who is a bricklayer. He wants to use it to store all the work he does so he can produce his timesheet quicker.
He works on building sites and has to show a plot number next to all the work he does. He wants to be able to search for a plot number and see what jobs he has already booked in for a particular plot number.
For example, if he is working on a block of flats, each flat will have individual plot numbers. If he is working on the outer wall of the flat his timesheet has to show all plot numbers for that block so he will normally show this as plots 100-110. however, if he works on an internal wall in one of the flats he will have to show just one plot number on his time sheet, for instance plot 104.
my problem is that he wants to be able to search for plot 104 and have it list both jobs he has done even though one job is shown as plots 100-110. How can i structure the database tables to allow this to happen.
hi everyone,i'm new to access and despite reading quite abit im just not grasping how to set up tables and relationships for what im wanting to do.I need a customer contacts table/form to keep track of my customers info (name, address, etc) & who's placing orders, easy enough.Now with some of my customers its always the same person who places the order but with others it can be anyone of up to about 15 different people who place the order each one can have their own direct phone no.So what im wanting to do is create a customer contact table/form and then linked to that who in that company placed the order with their phone no. Ideally i'd like it so once I have entered the info I can just use drop down menu's to select the company name then it opens up a list of all the people who I deal with in that company so I can just select the person/phone no who is placing the order.Can anyone help & advise me through best way of doing thisthanks alot
Hello, I want to fix a database I built and I needed some help on the table structure since its saving the data and not the ID number. I have it done and it works but its not correct since I dont understand normalization very well I took the easy way out and now its killing me and I want to fix it. Please take a look and give me some advise or show me a structure on what I need to do to normalize the DB... This would be my first DB so bare with me....
The comments section of each category will have a list of positive phrases and negative phrase equal to the subject like Safety, Quality, Quanity ect. "I didnt pur the phrases in each table yet"
I'm creating a simple db to stor project details. Each project has a unique name, and is part of a programme. Each programme name (ie SIG023) can have multiple projects. these projects recieve numerous support plans, guides and tto plans. I also want to store comments on each project.
Does my relationships and table structures look ok? am i starting in the right lines?
Good morning,since this is my first post I hope I'm not making to many mistakes.I'm making a database for school in Access 2003. In this database I have 2 parts.. A part for Patch connections and a part for PC repairs. The PC repair part is doing okay. The patch part is where I'm having some trouble.I don't exactly know how to start with it, and I'm hoping someone here can help me out.The form, I want to make based on tables should look something like this:A ComboBox filled from a table with about 10 entries in it. (Patchkasten)A textfield in which I have to enter something like this: XX-00 (x stands for alphabetic - 0 stands for nummeric)(Patchnummer) This will have around ~3000 entries.Those 2 should somehow be connected in a table as 1 field. (if that is possible offcourse)If not, is there another way to do something like this, because the combination of (patchkasten)and(patchnummer) has to be unique.. And at last a combobox (ruimte) with around ~ 150-200 entries.Now my question is if someone could help me setting this up somehow. Help would be appriciated.Thanks,F3dde
i am currently working with a human resource outsourcing company. we deploy contractual employees to different companies. we usually use ms excel in keeping records of our employees, now my boss wants me to create a database using ms access. this is my first time in creating database using ms access.
here are the headers that we used with our excel database:
- ID number - Account number - First name - Last name - Middle initial - Start date with the agency - Start date with the company - Status (active, end contract, resigned, terminated) - Previous contract start - Previous contract end - Present contract start - Present contract end - Company - Outlet location - Position - Pay class (daily or monthly) - Basic Rate - Allowance - Total Pay - Home address - Home tel. no. - Mobile no. - Civil status - Date of birth - SSN
what i did was divide the headers into several tables for ms access as follows:
1st table (Personal Info)
- ID number - First name - Last name - Middle initial - Home address - Home tel. no. - Mobile no. - Civil status - Date of birth - SSN
2nd table (Company info)
- Company ID - Company Name - Company address - Contact number - Contact person
3rd table (Position info)
- Position ID - Start date with the agency - Start date with the company - Status (active, end contract, resigned, terminated) - Previous contract start - Previous contract end - Present contract start - Present contract end - Pay class (daily or monthly) - Basic Rate - Allowance - Total Pay
4th table (Outlet Info)
- Outlet ID
5th table (Status info)
- Status ID
6th table (Pay class info)
- Pay class ID
7th table (Pay class info)
- Civil status ID
are these correct? please feel free to comment or suggest. i do apologize for the inconvenience. i am just a newbie and i need to finish this project. i appreciate your response. thank you in advance.
Hello, I need to make a report of the structure of the tables. In Access only I can make report of the table information (contents) but I need a simple table in Word width de table structure (name of field, type, descriptión). Do you know a program o tecnique tu make this automated?
Hi, I have a contact list about 20 people strong. These contacts are related to a certain CostCenter. Each costcenter will have multiple contacts. I want a combo box on a form where I can select a contact from the combo box' list and send them an e-mail. I also want a list box on the form that shows each costcenter and the contacts related to it. I also need to be able to add or remove contacts and have the new info shown in both the list box and the combo box. I'm stuck with setting up my table structure. Anyone wanna give this a go? Thanks, Israel
I need help with table structure, They keep way too much info. Now that I have said that here is what I need help with. I have been asked to make a small "Ha ha" Database this is what small became. Most of the data for this is in a spreadsheet now I know I can import it where I want it. The main concerbn is that the main piece of information would be the Job Address. Because of all this other information I was not really sure how to setup the tables here is what I have started .
Buyers Information (tbl) Fname Lname Address City State Zip (with a look to qry)"cool zipcode code" Phones (3) Email Ect.
Buyers Realtor Info (tbl) Fname Lname Company Name Address City State Zip (with a look to qry)"cool zipcode code" Phones (3) Email Ect.
Sellers Information (tbl) Fname Lname Address City State Zip (with a look to qry)"cool zipcode code" Phones (3) Email Ect.
Buyers Realtor Info (tbl) Fname Lname Company Name Address City State Zip (with a look to qry)"cool zipcode code" Phones (3) Email Ect.
Job Information (tbl) Address City (Filled in by Zip) State (Filled in by Zip) County (Filled in by Zip) Zip (with a look to qry)"cool zipcode code" RoofType (With a lookup to A list tbl) RoofCondition (With a lookup to A list tbl) Job Notes (memo)
Appointment Information Time (now real sure how these time and date will work) Date ( " ) Appointment Type (With a lookup to A list tbl) Contact Name Salesman (With a lookup to Salesmen Table) Appointment Results (memo) Referral
As I mentioned this data is in a spreadsheet and most every row has all of the above information ("ha ha, small") but I wanted to get some other Ideas and see if anybody had a better one before I tryed to make it all work.
I really suck at table design and coding, and access. I'm a techie that usually stays away from all this development stuff; it makes my head hurt. I'm a lot happier knee deep in an Exchange migration than developing even the most basic of databases as I suck at it (think I mentioned that already) However, i've been roped into doing a tiny little project for a friend. Below is the process I went through for the data / table design. When I started to create the relationships it got messy with the many to many relationships. Am I over complicating it or am I on the wrong track? Any assistance from you super-clever developer dudes would be greatly appreciated and would affirm your superiority over us humble techies yet again. :)
A Supplier can have many Items, SupplierItemCodes and Costs An Item can have many Suppliers An Item can have many Units (e.g. Sharp Concreting Sand comes in many different weights (Units)) A Unit can have many Items (e.g. the unit of 25Kg can have several different types of sand or other items associated with it)
So what I did was to create four tables (* - primary key, ( ) foreign keys):
I created the ID fields in each table even though Supplier, Item, Unit and SupplierItemCode are all unique values that could be used as primary keys (or would that be bad practice; I told you I sucked at this?).
