Search results

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??

Yes it does thank you!!

I went to the tblDownTime and made sure that it was set to Number and the area where you enter the general info I have Long Integer, General Number, and 0 decimal places. What else would you suggest I check?

It is bound to a field in the tblDownTime and I have it set to a number, yet it will still let me enter text. Do you think the if statement in the After_Update would force it to use only number entries?

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??

This is the new code and it is pulling values now but only the numbers not names and it is not differentiating between the choices to force the cascading effect of making a particular choice. Any suggestions?? Private Sub Line_AfterUpdate() Me.MachineCenter.Enabled = True Me.MachineCenter =...

Can anyone help I am still stuck and I looked at the regular cascading combo boxes that go from one box to another but so for none are trying to cross a bridge table and I am at a complete standstill?????????????????????????:confused:

" SELECT tblLine.lineID, tblLineMach.lineID, tblLineMach.machID, tblMachCent.machID" & _ " FROM tblLine, tblLineMach, tblMachCent" & _ " INNER JOIN tblLine = tblLineMach = tblMachCent ON tblLine.lineID = tblLineMach.lineID AND tblLineMach.machID = tblMachCent.machID" & _ "...

When I created it in design view I went to the SQL and that is how I came up with this particular code for the query. I know the origional code worked along these same lines and I got the help for it on this forum, so I am not sure what you are meaning about placing the where clause in this...

Actually that is what I did. I used the query in design view to see the results I was looking for and this is what I got from it. So I putit in the code and I get a syntax error in the from statement. Help?!?

If anyone has any suggestions please I really need help. Is there any other way to force cascading combo boxes other than this or should I keep plugging away at the code I am currently working with?:confused:

I add all the tables to the from clause but I still get a syntex error in the from clause. Any suggestions of how to state it correctly?

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.

Got if figured out.

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."...

The user wants a form to update the tables I have created as new things come up. The first two tables follow the convention of using autonumber for the primary key which becomes the foreign key in the next table. The tables are the line, machine center, and category. He doesn't want just...

Would it work if I made the cascading combo boxes to give the user the information he needs and then created a text box for each individual field that the user wants to update with a button to update the record for each table?:confused:

How would you bind them depending on which one of the tables you want to update? I do have the text box but the only thing that changes is the catName field in the first row of the second table instead of the of the last row that allows the auto number to work.

How would you bind them depending on which one of the tables you want to update?