Database For A Machine Shop
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 Replies
ADVERTISEMENT
Nov 24, 2005
hi ,
does anybody have coffee shop or resturant sample database ?!
for example something that gives menu's and then u select people orders and then calculate the prices and print a bill
thanks
View 1 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
Aug 15, 2007
Hi,
I want to build an access application for a bicycle shop, I have a little access knowledge and would like to get more information on doing this.
Is there a place to look for on the web on how to build an application like this ?
thanks.
View 2 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
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
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
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
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 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
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
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
Mar 10, 2005
Trying to use Access97 on Windows XP and I get an error message.
"Microsoft Access can't start because there is no license for it on this machine"
I've tried everything and it still doesn't want to work.
I've uninstalled and reinstalled
I've tried to find the font, hatten, and it's not there
I've downloaded MDAC 2.8
I've check the permissions in HKEY CLASSES ROOT
I've tried c:setup/y
I've downloaded AcLicn97.exe and it tells me that it can't find Access
If anyone can help, please let me know
View 3 Replies
View Related
Sep 7, 2011
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
View 3 Replies
View Related
Oct 7, 2005
Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
Thanks in advance..!!
View 4 Replies
View Related
Aug 22, 2014
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies
View Related
Sep 12, 2012
Database: Access 2007
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
What is the best way to do this?
View 1 Replies
View Related
Jun 24, 2015
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
View 14 Replies
View Related
Jul 7, 2005
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
Thanks!
View 3 Replies
View Related
