Assigning A Combo Box To Select Machine Number
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 Replies
ADVERTISEMENT
Mar 19, 2013
I have a table called StockTable with the following fields Location, Status, Serial, Make, Model, LastDate, DotNumber
I also have a table called FCDateRange with three fields
DateStart DateEnd and DotNumber
For example
3/7/13 - 3/13/13 - 1
3/14/13 - 3/20/13 - 2
Im trying to figure how to write a query that if the lastdate from the StockTable falls during the DateStart and DateEnd fields it will assign it the number in the DotNumber field
View 2 Replies
View Related
May 6, 2014
I have a subform containing a list of Funds and attributes such as Asset Type, Fund Manager, etc.
Currently, I have a textbox, where the the control source is set so that it will be updated with the Asset Type from the subform.
I also have an unbound combo box that contains a list of Asset Types queried from a table via row source, where user can select the Asset Type.
What I would like is when a record is selected from the subform, the Asset Type is selected on the combo box as a default value. User can select another Asset Type if required. How can I do this?
View 1 Replies
View Related
Nov 5, 2013
i have a table with three column Named
1-State
2-City
3-Customer
on a form i m placing 3 combo box for each column how can i filter combo 2 from table after select value from combo 1
View 1 Replies
View Related
Dec 2, 2005
Hi!
Can anyone help me how to create query selecting only the records starting with the numbers?
Thanks a lot in Advance
View 1 Replies
View Related
May 19, 2007
This database is for a livestock show that I have been working on for quite some time now. This specific 'section' is for the Supreme Competitor award, in which points are given for the showman's placing in showmanship, ONE highest placing animal in market classes, ONE highest placing animal in breeding classes, and the showman's score on a quiz. I'm having a problem assigning 'points' for a single highest placing animal in market and breeding classes.
I would like to create a query/s that selects all animals shown by an exhibitor in a market class, then take the highest placing animal that the exhibitor had and award (update the livestock table-points field) points for a single animal. This is fine until one exhibitor has MORE than one animal that received 1st place. How do I go about telling the query to just pick one, lol... it doesn't matter which 1st place animal it selects to award the points... just as long as only ONE animal is updated and not all of the exhibitor's animals that received 1st... Then do this again to select one highest placing animal from the breeding classes.
Here's a little outline just for visual sake:
Market Classes
Name Tag No Class Placing <points field update>
Sally Johnson 100 1 1st 10
Sally Johnson 101 2 1st
Sally Johnson 102 3 1st
Kim Smith 200 1 2nd 5
Kim Smith 201 4 2nd
Kim Smith 202 5 3rd
See where Sally received 3 1st places, but only one of them is selected to be updated, and Kim received 2 2nd places (her highest placing) and only one is updated.
Thanks SO much in advance... this has really got me stumped.
View 1 Replies
View Related
Apr 1, 2014
I have been tasked to determine the actual cost to build a product by summing the cost of the most recent required components to come off of our assembly line. For example, say I'm trying to determine the cost of a car with multiple sub-components (1 engine block, 4 doors, 4 wheels, 2 headlights, etc.). We make parts for all kinds of products (cars, boats, televisions, etc.). All of the data for ALL of these parts are contained in a table called PART_DATA (i.e. part ID, date started, date finished, hours spent, etc.).
Then I have a list of parts required to build a certain model car in a table called CAR_PARTS_LIST. This table contains data like (part ID, quantity needed, etc.).
If I want to know how much it would cost to build a car using the most recent car-part data, I need to pull data for the most recent required car parts to come off the assembly line that are required for a single car. That is, my car needs 4 wheels, so I need data for the most recent 4 wheels to come off the line.
How can I write a query for the "4 most recent wheel records" given that "4" is specified in the CAR_PARTS_LIST?
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
Sep 3, 2015
I have a KidShop table that shows the Diagnosis for the person,there are 5 diagnosis fields because one person could have up to 5 Diagnosis and each field is a lookup from the diagnosis table.in the report they show up as the ID number not and not the text.
I inserted Diagnosis from the Diagnosis Table and a window popped up asking what Diagnosis from the Diagnosis table matched in the KidShop Table and gave the selection of Diagnosis 1 or 3 or 3 or 4 or 5. I could only select one and I selected Diagnosis1 in the KidShop table and that showed Diagnosis as text for the Diagnosis1 field but the other 4 diagnosis fields still show a number. I understand what that did but it does not give me the option to match Diagnosis 2,3,4,5 to diagnosis Table. If I changed the Data source for the other 4 to Diagnosis then only Diagnosis1 shows up it the other 4 fields which makes since.
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
Jun 27, 2012
I'm currently working on fixing an older 97 database that I've updated to 2010. I have just populated the Drop down box with about three fields. Ideally what I want to do is after having selected the item number from the drop down box I then hit the button that creates a report with the information about that item number.
At the moment...If the box is blank it reports all the item numbers, however if i fill the box(select an item) it returns nothing i.e the report is blank.
I've looked at the query that builds the report, there are only three fields that populate the. location, part number and description. from a tbl called MainDetails
the only other thing:
If([Forms]![frmReports]![FLoc] Is Null,[FUNCTIONAL LOCATION] Is Not Null,[FUNCTIONAL LOCATION] Like [Forms]![frmReports]![FLoc])
it has a criteria of <>False
*FLoc is the drop down box *functional location is the location field.
I believe all the above does is populate the report if Floc is empty.
What can I put to make the report generate what ever I pick in the drop down box 'FLoc' source the three fields from the 'MainDetails table'.
View 7 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
Feb 13, 2006
Hi all, i have a 2 fields in a subform named "HRS_ABSENT" & "ABSENCE_REASON" i'm trying to create some code that will display a message if the user inputs any number into the "HRS_ABSENT" field & leaves the "ABSENCE_REASON" field empty. I want to force the user to select a ABSENCE RESON (these are 3 letter codes) from the drop down list, if they enter a number in the HRS ABSENT field. Ive tried the below code but it doesnt do anything :-(
Anybody please help me out?
-------------------------------------------------------------------------
Private Sub Form_BeforeUpdate(Cancel As Integer)
If HRS_ABSENT = >0 & ABSENCE_REASON = FALSE Then
MsgBox "Please select an Absence reason"
Cancel = True
End If
View 2 Replies
View Related
May 2, 2006
I have a form that uses a drop down to populate another drop down (field#2). The information in field(#2) is pulled from a table where the condition in the first drop down is matched. In effect the form drills down and offers specific choices based on the original condition.
The form works correctly when first opened. If the selection in the first drop down changes the associated information in the other field does not update to reflect the new value to match. The form has to be closed and re-opened before it works properly.
Any ideas?
View 4 Replies
View Related
Sep 5, 2006
I have some combo boxes on a form with values that I have typed in directly.
I would like the user to click on these and the option selected will dynamically change a resultset.
Unfortunately, when I click on the combobox, the optionsare displayed, but clicking on each of the options doesn't do anything... i.e. the option does not become selected.
Am I missing a setting somewhere ?
View 12 Replies
View Related
Dec 11, 2006
I am probably doing this all wrong!
I have 2 forms (linked). One is plan, the other is plan contacts.
The plan contacts form is a continuous form and will hold a record of all the contacts for that particular plan. To select the contact (from that contacts table) i want to show, company, department, name.
As there will be hundreds of contacts i need to narrow this down for the user. My idea was to do this by using combo boxes. The first one will show a list of all companys, once chosen the second one will show all that companys departments and then finally all that deapartments contacts.
Any ideas? I am assuming this can be done through an SQL query?
Thanks
Kev
View 4 Replies
View Related
Oct 14, 2004
I'm using a select query which gets its value from a combo box.The combo box has three choices: Male,Female,Both.
Filtering male and female is no problem. Is there a way to select all in the query?
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
