Search results

I have a form that has a combo box labeled 'line' and I have a combo box labeled 'MachineCenter'. I want to create a validation rule so that if a user picks 'Line 2' in the first combobox they can't enter 'backline' in the second combo box. I am not sure how to write it. Can anyone help with...

I need to seperate report pages when the line text box goes from 'line 1' to 'line 2' and it needs to have a total at the end of the page showing total amount of time that each line was down. Where would the page break go?

Does anyone have any idea what control break technique is?

I was wondering. I have created my switchboard and everything works great. All my forms show up like they are suppose to. Is there a certain process to loading the front end on the network and keeping the back end so that it can't be accessed?

My reports are only showing one record per page and that is not what I want. I want them to show on one page. What simple thing am I overlooking?

I have two text boxes that show a begin time and an end time. I want to take the different and put it in another text box that shows the results. EX: begin end total 05:12 am - 05:23 am = 11 Any suggestions?? I am looking to make it so whoever does data entry, it will be a...

Is there a way to produce one query that will produce several results that display in a report that is generated from a button? The only difference is the criteria. EX: SELECT tblDownTime.dtDate, tblLine.lineName, Sum(tblDownTime.dtDowntime) AS [Total Time Down] FROM tblMachCent INNER JOIN...

I created a switchboard that allows the user to pull up a data entry form, a form that produces reports, and a form that allows the user to open table update forms. I want to put a password on the table update button so not everyone can get in to change the items in the tables. I am assuming...

I created a form that has buttons on it to access forms that are used to update tables. How do I get rid of the bar at the bottom to scroll to other records? I am looking for a clean look on this form and since it won't scroll to any other records I want to clean up the bottom. Idea's??

I have a form that stores data in a table. When it stores data it is using the primary key as the source to save space. When I write a query for a report using this data I want it to show the value of the primary key and not the pk value. Does that make sense?? Any suggestions??

I am using a DoCmd.RunCommand acCmdRecordsGoToNew to open a form starting at the point where a user can enter new data, but when I put it on a switchboard it will only start on a new entry and won't let the user see any previous entries. How do I make it open for data entry but still be able...

I am back. Sorry, but I still can't get this code to work for a cascading combo box. The tables are: tblLine = lineID (pk), lineName tblLineMach = lineID, machID (composite PK) tblMachCent = machID (pk), machName tblMachCat = machID, catID (compostite PK) tblCategory = catID (pk), catName The...

Is there a way to write one query that will work for different criteria and is run by different buttons to produce bar graphs or a basic report depending on the button the user clicks??

I need to make sure that a user doesn't enter anything but a number in a text box. It is on frmDownTime and the name of the text box is dtDownTime. How would I go about entering this? Using the Properties, Validation??

I am using this code to force the population of a combo box on my form. Private Sub Line_AfterUpdate() Me.MachineCenter.Enabled = True Me.MachineCenter = Empty Me.MachineCenter.RowSource = " SELECT tblLine.lineName, tblLineMach.lineID, tblLineMach.machID, tblMachCent.machName" & _...

I have a form that has to have cascading combo boxes (3 boxes). When I created it before the code I used worked great but I had to redo the tables to include bridge tables with composite Primary Keys to get rid of redundant data. Can anyone help with this one? I have attached a copy of the DB.

I am creating a bridge table to get rid of redundant data. I am doing it by making a composite of the primary keys from the two tables I am bridging. The error message when I get to a certain point is "You cannot add or change a record because a related record is required in table tblMachCent."...

I have about the same problem as Naia. I need to create a form that will update three different table, but the user doesn't know what the number is pertaining to specific items. (the primary key) (These tables are being used to feed cascading combo boxes.) So he would like to be able to to...

I downloaded the active x control for the microsoft date and time picker. Where do I put the DL_MSSCOMCT2.cab file to get this control to work on my laptop?

I have two boxes on my form that use Microsoft Date/Time picker. A begin date and an end date. How do I make sure that those controls work no matter what computer the program is run from?