Machine Activty Log Table Design Issues
Jun 26, 2007
I have a number of checklists for my machinery
i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format
i need to track which of these checks are being carried out each week..
I have created 3 tables so far, 1 called tLine and 1 called tMachine and 1 called tActivity
tLine
LineID (PK) - Autonumber
LineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tMachine
MachineID (PK) - Autonumber
MachineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tActivity
ActivityID - (PK) - Autonumber
Activity - Text
StdTime - Number
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
-----
I am having a few issues i could really do with some help with please
Line 1 has a Filler and Capper
Line 2 has a Filler
Line 3 Has a Filler and a Capper
if i focus on the filler:
I have 5 checks to do on this however the Stdtime on activity 5 is different on Line 1 and Line 3 but the activity is the same.
if i focus on the capper:
this has 2 differnet activities and 1 activity which has the same description as the filler activity.
Problem 1:
Table Setup - not sure i am using the PK correctly etc, have read a few reference guides etc, but am struggling with this..
Problem 2:
how do i link the activitys to the machines and the machines to the Lines
Problem3:
how do i account for the same activity but different std times.
Problem 4:
I need to track these checks but i will try to get the table structure right first
I really would appreciate your help here please
View Replies
ADVERTISEMENT
Jun 26, 2007
I have a number of checklists for my machinery
i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format
i need to track which of these checks are being carried out each week..
I have created 3 tables so far, 1 called tLine and 1 called tMachine and 1 called tActivity
tLine
LineID (PK) - Autonumber
LineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tMachine
MachineID (PK) - Autonumber
MachineDescription - Text
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
tActivity
ActivityID - (PK) - Autonumber
Activity - Text
StdTime - Number
Not sure if my use of PK is right, should it be the MachineDescription that i make the Key?
-----
I am having a few issues i could really do with some help with please
Line 1 has a Filler and Capper
Line 2 has a Filler
Line 3 Has a Filler and a Capper
if i focus on the filler:
I have 5 checks to do on this however the Stdtime on activity 5 is different on Line 1 and Line 3 but the activity is the same.
if i focus on the capper:
this has 2 differnet activities and 1 activity which has the same description as the filler activity.
Problem 1:
Table Setup - not sure i am using the PK correctly etc, have read a few reference guides etc, but am struggling with this..
Problem 2:
how do i link the activitys to the machines and the machines to the Lines
Problem3:
how do i account for the same activity but different std times.
Problem 4:
I need to track these checks but i will try to get the table structure right first
I really would appreciate your help here please
View 1 Replies
View Related
Aug 10, 2007
I have a text field in a table .. I would like the default value for that field to be the machine name. How do I do this? I know how to set a default value for a date or piece of text. I imagine it would be something like: machinename(), that's about as far as I get.
View 2 Replies
View Related
Feb 10, 2005
ok im making a database for a tumble prosses at work
first problem:
i have a yes/no field in a table "pull ontime"
witch i want to be controled by "pull actual" witch it a time filled in with the now() comand trigered by a button in a form i want to make the "pull ontime" field read no if the time is over 1hr over a value "pull" and read yes if under this 1hr
second problem:
there are machines that are loaded with parts i want to make it so when they enter the part # and the s/o # and stuff they will hit a loaded buton witch i want to make it put the Now() time in the "Loaded" them based on the operation witch has 2 cycles witch depending on the operation the first cycle could be 2 hrs and the 2nd could be 1.5 hrs i want it to based on the operation selected set the time that the oporator has to change the cycle "rinse" and "pull"
View 2 Replies
View Related
May 12, 2005
Hi, I would like to recreate a record locking problem (error # 3218) our users are experiencing on an application we have developed. I currently do not have access to a network, so I would like to run multiple instances of Access on one machine. How do I do that?
Thanks,
Bill
View 1 Replies
View Related
Jul 16, 2005
Hi,
I´ve installed office97 professional on a computer with office 2003 standard on it.
When I try to start access it tells me there is no license for it on the machine.
Has anyone else had this problem? Of course I have a license, and there has never been any problems with it in the past.
The 2003 version has not yet been registered, if that might have something to do with it.
Fuga.
View 1 Replies
View Related
Mar 13, 2012
I'm needing a pop up adding machine that will copy and paste a calculated value into a text box on a form when the calculator is exited....much like banking teller's have on their transaction pages.
View 1 Replies
View Related
Mar 23, 2006
Am fairly certain that I will be asked to design and implement a Machine Status Application.
Description below is very simplistic but believe you will get the idea
Basically simple stuff at Machine Operator. He clicks a command button on a display that signifies machine is okay or not. This updates machine status. Image it just toggles between Running and Stopped.
Each minute little process runs to at 1 to Run value or to Stop value. Okay so this will get a little more complex for sure.
Now I could end up collecting data on say 100 machines. Okay so I would not expect the status change to occur any more than once per hour on average so it would be a bit like having 100 very very slow users on the system.
Now the crunch. What effect (if any) would these 100 very very slow users have on performance and particularly the One much quicker user who is executing preset queries one after another for say 20 seconds every minute.
Thoughts and opinions welcome
Len
View 4 Replies
View Related
Oct 10, 2004
Hi,
I'm trying to establish the link from my local mdb to an mdb on a commercial server I'm using.
The problem is there's no way to locate the remote access database when using the Link Table wizard.
Anyone knows how to establish that connection??
Thanks in advance!
View 2 Replies
View Related
Feb 1, 2005
I recently bought a new computer and it was kinda cheap, so no office products were installed on the computer. A friend loaned me her copy of Office 2003 which didn't have Access on it. So, after installing Office 2003 I picked my old Office 97 CD and installed just Access 97. Then I go to open the database and get this annoying message.
Microsoft Access can't start because there is no license for it on this machine.
Can anyone help? Thanks for your time.
View 1 Replies
View Related
Mar 12, 2005
Hello, I'm a newbie at using access database on local machine.
I have worked with it before on a hosted site ,but need to know how to go about using it to host my database driven site on my local pc.I'm using maxwebportal ,which I have been using for a few years, After I install iis on my winXP Pro pc ,what do I have to do for my database to work,? is there something that I need to enable? thanks for any help Aussie )
View 2 Replies
View Related
Aug 11, 2015
I am facing a issue in accessing my db file in server. I just splitted my database into front end and back end , placed in a local folder which is shared in network . I opened the files in network from my colleague machine and everything was working fine yesterday .. but right now i am getting error like "the network path is not found " 0X80070035 which tells that check whether the source machines is able to accept file sharing ..I googled and tried 2 solutions Like turning off windows firewall and enabling NetBIOS Over TCP/IP..
View 10 Replies
View Related
Aug 25, 2015
I have a query which is currently using a prompt box to ask the user to input a machine number. This is run from a button on a form. Press the button and the prompt appears .I would like to now do one of two things either make a form with every machine number on it or use a combo box to select the machine number. My problem is that I don't know how to get the combo box or the control button to link to the individual machine number.
View 2 Replies
View Related
Feb 28, 2013
I have developed .net application ....at back end I am using ms access database. When I deploy my application at client end , I want only my ms access database should accessible to application only. Client should not be even to see which type of database i am using or its business logic .
View 7 Replies
View Related
Mar 27, 2013
I've been told numerous times that a shared database should have each user with their own FE. I've also seen in a number of places that the FE should be on the user's local machine. Is the FE on the local machine to limit network traffic only, or is there a greater reason for it?
I was under the assumption that the seperate FE's were to lower the probability of corruptions and sharing of local temp files... If this is the case, is it reasonable enough to have each user have their own FE in their own user folder on the network?
View 3 Replies
View Related
Mar 23, 2012
I am designing a database for my organisation. I have done most of it but am stuck on this. Ideally I would like to have a check box (in a table) that when checked a load of data is carried across from that record to a record in another table.
Given that I can't and don;t want to use VB is there anyway that this can be done easily?
View 8 Replies
View Related
May 17, 2005
Hi,
I have this project where I need to scan the MRP zone on the passport to my form. Let me first explain what is MRP zone. MRP is know as Machine Readable Passport Zone which you usally find on the first page of US Passport right under the Photographs and it looks like this
P<USAERIKSSON<<ANNA<MARIA<<<<<<<<<<<<<<<<<<<
0550667081USA6908061F9406236ZE184226B<<<<<14
1st Line
So P stands for Passport and Contry code is USA and then last name Eriksson and first name Anna and middle name Maria.
2nd line
Passport number and Date of birth and sex and so on.
Now I am in process of ordering a keybord that has a MRP reader on the top( http://www.accesskeyboards.co.uk/ATB420%20Reader.htm ) from this company in UK. You can find the specification on the keyboard from the above link.
So as soon as I scan/swipe it, it will give me information in the following format.
FIRST NAME, LAST NAME, DOB, SEX, PASSPORT NUMBER.
SO ONCE I HAVE THE INFORMATION IN COMMA FORMAT, HOW DO I GET THIS DATA INTO MY RESPECTIVE FIELDS INSTANTLY, AS SOON AS I SWIPE THE PASSPORT.
My field name in the table are
LastName
FirstName
BirthDate
PassportNo
MaleFemale
Thanks.
Rajput
View 7 Replies
View Related
Aug 13, 2015
I have developed a database in Microsoft Access 2013. I wish to install and run that database on another machine on which I have already installed the MS Access Runtime.
In order to allow the database to run correctly on the target machine, I need to add two Trusted Locations - one for the front-end database and another for the back-end database.
The folder paths on the runtime machine are different to those on the development machine, so how do I add Trusted Locations (on my development machine) which remain valid when the database is copied to the target machine?
Must I trick it by simply creating an identical, dummy folder structure on the development machine (would this even work?), or is there a more elegant way?
View 12 Replies
View Related
Nov 28, 2005
I am having problems coming up with a Table design and need help.
I am trying to design a table that will have 8 categories, 47 subcategories, and then choices within those categories.
Much like the following (this is only one category example, there will be many):
(Main category) Floors -> (Sub categories) Joist, Carpet, Vinyl Flooring, Wood Laminate -> (Choices for Joist Sub Category) Structure Wood 2X8 Joist, Plywood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist
This only shows the flow if the main category is "Floors", sub category "Joist", and then the choices under subcategory "Joist". There will be others for the other categories, subcategories, and choices.
Can someone help me or steer me in the right direction in setting up the database table/tables to accomplish this. Oh and BTW, there will be prices attached to each "Choice" under the subcategories.
I hope that this makes sense... any help would be much appreciated.
View 1 Replies
View Related
Aug 30, 2006
I have 5 tables with the same data (row and columns). How do I make it into a relational table?
View 3 Replies
View Related
Jan 29, 2008
if i had a table with products and i want to keep a record of what has been chaged or added to this product, whilst keeping the old records how could i set it up in a databse?
the excel spread sheet looks like this
product commments
1 chnged this and that 20/08
1 modifyed component 21/08
2 newest model 3/08
View 1 Replies
View Related
Oct 23, 2004
Hi all, i wonder if anyone can help?
It's a simple question really. I'm currently learning databases and am doing a project, just to show that i understand everthing i've learnt so far. I have to produce a small database.
There's nothing difficult about the project, and its a very basic database, but i was just hoping to ask a small question.
I'm producing a DVD database, to hold details on a collection. My main table holds the majority of the fields, as follows;
lngDVD_ID
strDVDTitle
strYearReleased
lngDiscAmount
dtmFeatureLength
lngCertificationID
ysnBoxset
ysnExtraFeatures
strDirector
lngMovieStudioID
lngCategoryID
curPurchasePrice
The problem came with boxsets. Originally i was just going to have boxsets as one entry, but some contain a few dvd's, each with different certification, etc, and i wouldn't be able to record running length, director, etc.
So i added a ysnBoxset field (just to record whether a dvd was part of a boxset or not) and then made a new table with
lngDVD_ID
strBoxsetName
So now i can record which are part of a boxset, and the name of the boxset they belong to. But.. then i got to the problem of Purchase Price. Obviously i cannot record an individual purchase price for those which belong to a boxset, and i want to be able to record the price of the boxset.
So my question is... is it acceptable to add a curBoxsetPrice field to tblBoxsets, which would allow me to store the price... and then just leave curPurchasePrice as £0.00 for those dvd's in a boxset??? Or is there a better way of doing it? (I know there is, but i'm a novice :( )
Thanks for any help you can give, sorry for the lengthy explanation! :rolleyes:
View 3 Replies
View Related
Mar 14, 2005
Within my db I have a table, tblProjects which currently has 36 fields. Each project will have a fixed set of 12 tasks, each having a begin and end date as well as a yes/no "completed" field. This would add another 36 fields to tblProjects.
Instead, I have created a new table tblTasks which has these 36 fields along with a PK(TaskID) and FK(ProjectID) and is related to tblProjects. I believe tblProjects is already normalized properly with relationships to tblCompanies and tblContacts as well.
I'm not sure if this was neccessary, or should I have just added the task fields to tblProjects. What, if anything, are the advantages of one way over the other? I'll be upsizing to SQL Server, does that make a difference?
I appreciate any advice,
Sup
View 7 Replies
View Related
Jun 2, 2005
Hi,
Bit of a long one but I require some advise if people can supply it.
I've started creating a DB that is now getting out of hand due to me being inexperienced. The things I want to do now are getting way to complicated. From reading various posts I know that this is all being caused by my database design and while the DB is still young I'm go back to square one. I want your advice on this if you can to ensure 3 weeks from know I'm again not chasing up weird bits of VB code to make it all work.
I basically have a lot of information to hold that interconnects with each other. I'm making up a role profile DB (so we can assign define access rights to a computer system) I have lots of info to collate but the basic stuff is.
Staff Records (Name, business area & ID)
Applications (What computer applications do staff require)
Shared Drives (What access to shared drives and folders do they need)
Shared Mailboxes (what access to shared mailboxes)
Roles (users will be assigned roles to suit their requirements)
Basically what I have at the moment is below.
Roles
Role ID
Role Name
and about 15 other fields that dont really matter for this
Applications
Application ID
Application
Shared Drives
Shared Drive ID
Shared Drive
Shared Mailbox
Mailbox ID
Mailbox
Each role will only have a select number of applications, mailboxes and drives from the overall list. so role 1 may give access to 2 of the 10 applications, 1 out of 5 shared drives and 3 out of 4 mailboxes. Role 2 on the other hand may need 9 out of the 10 applications, 1 out of the 5 shared drives and 1 out of 4 of the shared mailboxes.
I just don't understand how I can create a form from these tables that would display all the different roles with their respective apps, mailboxes and drives they would need.
any advice you can give to help whould be appreciated.
Again sorry for the long post.
View 1 Replies
View Related
Jun 5, 2005
I am designing a db for our Law office. I want to have tables for different types of Civil Cases-ie Divorces, Deeds, Contracts, Personal Injury, Auto Accident, Slip and Fall, Product Liability, etc. The divorce, Deeds, tables are easy but I am having difficulty deciding on the personal injury tables. Heres my dilemna. Can I get away with one or two Personal Injury tables even though there will be blank data fields. For example, I will need a field for the name of the product in a Producrs Liability field. This field will be blank in all other Personal Injury Cases. I know the rule is you don't do that but my alternative is 15-20 tables for every concievable Personal Injury Case- Auto Accidents, Slip and Falls, Fraud, Prouduct Liability, Accounting, Attorney, Dental and Medical Malpractice, etc. This is in addition to other civil case tables, criminal case tables and federal case tables. Anyone have a suggestion?
View 6 Replies
View Related
Aug 30, 2005
I am not sure if which I should be using as the main entity for my tables. I am creating a database for hourly information on individual employees. Each employee will have the same types of hours to keep track of (weekly, bi-weekly, monthly etc) I naturally thought to treat each employee as the databases own entity and created fields for each type of hours but hit some trouble when trying to pull queries to compare each employees hourly information against each other to see who is being efficient or not. Each employee has the same exact fields but with just different numbers. We track each type of hour by week (Field One: Week 36, Field Two: Aug 28-Sep 03)This is the first time I am creating a database from scratch. All advice greatly appreciated and TIA :confused:
View 10 Replies
View Related