Form Suggestions
Mar 2, 2005
Can anyone suggest a good form layout for my database below?
I have also included the database in access 2002 version!
tblEvent
EventID (int autonumber not null primary key)
RaceID (int foreign key to tblRace.RaceID)
EventName
EventTrack
EventDate
tblCar
CarID (int autonumber not null primary key)
CarName
tblCarSetup
CarSetupID (int autonumber not null primary key)
CarID (int foreign key to tblCars.CarID)
TyreType
TyreSize
GearBox
DiffRatio
tblDriver
DriverID (int autonumber not null primary key)
FirstName
LastName
tblEngine
EngineID (int autonumber not null primary key)
EngineMake
EngineModel
tblEngineSetup
EngineSetupID (int autonumber not null primary key)
EngineID (int foreign key to tblEngine.EngineID)
EngineCompression
Carburetor
FrontJets
RearJets
FuelPressure
BaseTiming
TotalAdvance
tblRaceVariables
RaceMasterID (int foreign key to tblRaceMaster.RaceMasterID)
RaceTime
TrackTemperature
RelativeAltitude
Milibars
Humidity
AirTemperature
TyrePressureHot
TyrePressureCold
StageRPM
ShiftRPM
Reaction
60ftTime
330ftTime
660ftTime
660ftMPH
1000ftTime
ElapsedTime
ElapsedMPH
Coments
tblRaceMaster
RaceMasterID (int autonumber not null primary key)
EventID (int foreign key to tblEvent.EventID)
CarID (int foreign key to tblCar.CarID)
EngineID (int foreign key to tblEngine.EngineID)
DriverID (int foreign key to tblDriver.DriverID)
All relationships will be RI Link with delete cascade.
Thanks,
Dean
View Replies
ADVERTISEMENT
May 20, 2005
I wonder if someone can give a suggestion on how to start this database. I am doing a material list database, but i've come across a situation where certain materials require a lot of text entry as opposed to some of the others where you simple enter data such as " density, grade, strength, etc" values. Because the layout/fields would be so different for the different materials (eg. plastics, metals, elastomer, etc.) it possibly might be a good idea to just separate them into different table groupings altogether? what do you think? Originally they were entered in Word and i was thinking of putting in access to standardize it. But what I'm trying to get at is the format in word was much like a one page report with headings and short paragraphs for this section of materials. Is it worth it and how should I go about having large text and heading entry, form use, report layout?
Thanks!
View 3 Replies
View Related
Jun 2, 2006
I am starting a new database today at work. I need some suggestions.
First of all, we will be having people enter data into many sections of the database at the same time...should I create seperate databases for these sections and link them together somehow so that it doesnt freak out with multiple users or being saved while open in different computer on the server?
Will it freak out anyways? What happens exactly if you open same database on two different computers.
Next, I would like to know if anyone has any further ideas about creating this database the right way in a server setting with multiple users!
Thanks.
View 5 Replies
View Related
Nov 8, 2004
Ok a bit of back ground. I'm building a access front end to a sql database. The end user will access the information in the database via asp pages on the Internet. They will only be viewing and not changing this information.
Now from the asp will be links to other pages within the same site. So they only have to be relative links eg .../folder/page.htm. But I want the person who inputs the information in the access front end to be able to test that the link works before saving the record.
I would prefer them to be able to press a button, then have access grab the link from the text box, add the relevant other bits eg http:// and load the page.
Any suggestions how I should go about it?
View 1 Replies
View Related
Jun 21, 2006
Hey all, I am currently looking to make a great database system for use within my community. What I currently have is a mdb with just 3 tbls but will be building from there. I have the normalization down thus far, but wanted to put things out there for any suggestions or ideas to make this a useful system. This is not a profit situation, and will generally be used only by myself or possibly one or two others.
What I have is a database that tracks the homeowners within our community (subdivision) and their properties. So far I have 3 tbls
tblOwners
- OPkey (autonumber)
- OFname
- OLName
- OStAddress
- OCity
- OState
- OZip
tblUnits
- UnitPKey
- StNum
- Street
- PIN
- Check2005
tblJct
- UnitPKey
- OPKey
Structurally this works great so far. I can easily relate properties to their owners and link multiple properties to those who own more than 1 (landlords). I structured it this way since the two tbls had many to many relationships, so the junction tbl made the most sense.
Now I am looking to add information from a tract search (mortgage holder information) which technically relates to both of these tbls (Unit & Owner) as well. I already know that most of the owners with multiple properties will most likely have the same mortgage holder, but that is not definitive. Since the same mortgage holder could easily be associated to multiple properties within the community, I know I have to have an independent tbl for that information as well.
What I would like to head for is something that will allow me to send notifications, letters, flyers and the likes to either the owners, residents, mortgage holders, or any combination of the three. I have attempted to create a few thus far but have issues with getting all of the required data output to Word, so I am thinking I may need to design these items in a Form instead.
Any thoughts or comments would be appreciated. I know I am heading in the right direction, but just putting it out here for the Access community to put in their 2 cents.
View 3 Replies
View Related
Jan 4, 2007
Hi, I'm afraid I am unable to be overly technical with my question as i've only really had a 2 day access course, sorry in advance!!!
Problem
I am trying to create a skills Matrix, it will need to include approximately 400 different skills which a staff member my or may not be trained on. I started by trying to do the lot on one table and an one input form but hit the 255 field limit. So now i'm messing around splitting it down into approx 7 sections. So, now i have 7 tables of skills and 7 input forms for the user to fill the table with, each table with a duplicated list of ID numbers for the staff. This seems really inefficient to me and i'm basically wondering if someone might give me a couple of tips structure wise. Also, could i just have one table for the staff ID's seperately? I tried to do this but cannot find a way of relating the skills input on the form to the specific ID if they are not on the same table. I know this is all probably really basic (and probably poorly explained and confusing too) but i've scoured the net as per usual and came up with nothing (i got some lovely code online which disabled the scroll button from moving records yey! :p ), so ive taken the brave step of joining a forum.
Thankyou for your time everyone.
View 9 Replies
View Related
Mar 10, 2008
I have a databse that i want to perform some analysis on to identify some trends. The database consists of album sales of a year. I have availble all details of orders, customers and albums. All tbales are joined with one to many relationships. Can anyone suggest some queries that i could do to perform some meaniful analysis to identify some trends in the data. :confused:
View 10 Replies
View Related
Mar 12, 2008
I am developing an app for a small medical office that requires a way of tracking periodic health testing for their patients. They are ultimately requesting a report that informs them of upcoming required tests for their patients.
Most periodic tests for a given patient will be manually assigned by the user in the frmPatient form via a combo box that lists available tests (for example, Mr. Smith is assigned a prostate exam with a frequency of every X months). However some tests need to be automatically assigned depending on the age of the patient (for example, when a male patient turns 50 years of age he needs to have a prostate exam every 12 months).
My Question:
What is the best approach to the automatic requirement of adding/flagging/indicating in a report that there are tests that are needed for patients that is determined solely by their age, eventhough this test has not been previously assigned manually?
View 3 Replies
View Related
Sep 8, 2005
I needs some advice on how to proceed.
Our company is devolving some operations to a sub office for 3 out of 11 business units. we have a central DB that we use to record monthly events the problem is that the parent group has to be able to update records for all units but the sub office is only allowed to see and edit their records
At the moment the data is all stored in one table and we use a Front end back end with local front ends for access I have a table to say if a unit is part of the sub office or not and in the sub office front end i have a Query which links the 2 tables together and filters the records to show only sub office
SELECT tbldatatable.*, tblShipName.Manager
FROM tblShipName RIGHT JOIN tbldatatable ON tblShipName.ShipName = tbldatatable.Ship
WHERE (((tblShipName.Manager)="nv"));
the remainder of the forms and querys all run from this query rather than the tables
the problem is the join makes it a non updatable record set
what is the advice on how to achieve what i need as i cant see a simple way to proceed
thanks
ND
View 9 Replies
View Related
Jul 24, 2006
Hi everyone,
I'm creating databases that houses information of the different software versions my company offers. This way they can easily keep track of updates, obsolete info, etc.. I'm trying to decide what way would be most benifcial. I've been leaning more towards creating multiple databases and having a dropdown box in the beginning to open what database(version) you would like to view. Is this the only way, or does anyone have any suggestions on how to make my idea better?? Just trying to Brainstorm, also, I'm only an intern so my experience is limited.:D
Thanks in advance!!
View 1 Replies
View Related
Nov 20, 2007
Hi,
I'm doing a database for a CD, DVD, Game website could you take a second to review it and give me suggestions to improve things.
I've included my old and revised database to see what if done
View 8 Replies
View Related
Feb 9, 2005
I am creating a database where the user can import data from a number of spreadsheets (one spreadsheet for each company). Currently I have one table for each company with the year being the primary key. Each year when a rolled over spreadsheet needs to be generated for a certain company I have Access import the data to a blank template in excel which will display the prior 4 years of data (for informational purposes) and leave a column blank for the end user to fill in the current year data. When returned the current year data is imported into the database.
My problem is that I cannot see a way to do this without having a seperate table for each company. If I have one table with all company data I cannot use the year as the primary key. Any suggestions on how I can reduce the amount of tables I need. Setting up the rest of the tables wont be a problem, but future users of the database will have to go through the process of creating tables for new companies and creating all the queries and macros associated with that table.
View 2 Replies
View Related
Dec 31, 2005
I am converting a log book over to MS Access. The log book contains information on inspection results for a metallurgical lab. I have one problem w/ my “inspection table” which I will explain later in the post.
This is the plan I am using to figure out my entities and attributes for the database. I wrote a short description about the hand written log book we use at work.
A log book is an array individual fields.
Each field is made up of 11 columns
(date, initial, log #, sent to customer, customer, dept, part #, load #,
results, acc/rej, and defect code).
The date pertains to the time a particular part was inspected.
Initial indicates who checked the part.
Log # starts at “1” Jan 1st and increments for each check throughout the
year
Sent to cust asks if “inspected” samples are sent back with finished product.
Customer displays owner of finished product.
Dept indicates the processing area of plant.
Part # distinguishes the part type.
Load # may display what furnace and run count for the year to date.
Or, tub number in an array of tubs processed through a continuous furnace.
Results give a list of values on test results.
Acc/rej is a simple “yes/no” question asking if finished product is
acceptable to ship to customer.
Defect Code represents a particular defect found during inspection
Tables
Log -- *LOGNum, LOGDate, &LOG_TECId, &LOG_CUSTId, &LOG_FURId &LOG_PARTId, &LOG_INSPId, LOGaccept, &LOG_DEFCode
Customer -- *CUSTId, CUSTName,
Part number -- *PARTNum, &PART_CUSTId,
Technician -- *TECHId, TECHName
Defects -- *DEFCode, DEFType
Furnace -- *FURId, FURType
Inspection type -- *INSPid, :confused:
* Primary key
& Foreign key
One problem with the Inspection table; we have different inspections for each part number. Some require 10 RC punches others only require 5 RC punches. Some Require a Total Case inspection. Others Require an Effective Case inspection or both TC & EFF Case.
Some part #s require all tests (i.e. Crush, Total Case, Effective Case, RC, & R15N)
Once I figure out the basic table setup I can use a query to build the final log. And develop a forum for the data entry. I’ll worry about the CPK reports later :)
Here is a sample database Let me know what you think. I still need help on the INSP table :)
Your Download-Link: http://rapidshare.de/files/10087240/SampleTable.zip.html
View 14 Replies
View Related
Sep 6, 2006
Hello,
I have almost ultimate my database which works with forms that export their data to word documents.
The code behind the forms indicates that path to which it will find the word documents.
As I will be sharing my program with several offices, I will need that each Office will have to change the path based on their server name.
Examples of path: \ABC123shared emplatesmydoc.dot
Is there a way each office or better on person which will be the database administrator can change the ABC123 in all forms without having to open each one in design view and manually make the change?
I was thinking of some kind of text box where to write the path and a cmd that will do it for us.
Appreciate any help. Thanks.
View 8 Replies
View Related
Jan 4, 2008
I have a products file in csv format including their category, subcat, and brand name.
Now I want to take that file and split it up into 2 tables in Access. One table will contain the product data only: name, description, price, etc, etc - with a primary key (of course) and a category number. The 2nd table will be the categories for each.
The formatting of the categories table needs to be:
Code:Cat ID | Category Name | Parent ID 1 Tools 0 2 Hammer 1 3 Pliers 1 4 Hardware 0 5 Nails 4
Does that make sense?
My real problem with this is finding a suitable number format for the categories. I imported the file as a table, then I run a query on it to get the ID's for each of the category, subcat, and brand, but of course in the above table format I'll end up with duplicates.
Also, how would I then assign the final number to the product itself?
View 2 Replies
View Related
Jan 15, 2008
anyone have any suggestions for getting around the error on the attached picture?
thanks
sportsguy
View 1 Replies
View Related
Dec 28, 2007
All -
I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.
I have several questions that I may need some help on.
How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?
How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?
Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?
Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.
Thanks!
View 7 Replies
View Related
Mar 26, 2013
Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
View 5 Replies
View Related
Apr 14, 2015
I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.
The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.
The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.
View 9 Replies
View Related
Aug 27, 2014
On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.
On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.
So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.
(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)
View 5 Replies
View Related
Aug 10, 2013
I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.
View 4 Replies
View Related
May 7, 2005
I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??
View 9 Replies
View Related
Jul 24, 2013
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
View 4 Replies
View Related
Aug 19, 2014
I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?
View 1 Replies
View Related
Jun 6, 2013
I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,
Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website
Table:StaffContact
Staff Role
Name
speciality
email
phone
I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.
Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).
Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)
My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has
So i ran a Macro, with open form with Where condition
Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]
But, it does not work .
View 2 Replies
View Related
Mar 20, 2014
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
View 1 Replies
View Related
