Recent content by Char409

Yeah that will work. Thank you

Does this help?

so i select a machine from combobox machine and its row source is: SELECT DISTINCT tblTask.[Maint Point], tblTask.Machine FROM tblTask WHERE (((tblTask.Machine)=Forms![frmPMfill]!Machine)); then the next combo box I have my row source of my combo box set to: SELECT DISTINCT tblTask.[Maint...

Well the form's control source is "tblPMentered" so my maintenance tech can fill out what they did and it fills out that table. All the information is stored in a table called "tblTask" I just wanted the text box to display the frequency because some tasks are very similar like filling oil...

So I have a form that fills out a table and I have 4 combo boxes that are based off of each other where as I select a machine it only shows pm's for that machine in the next combo box. Now I want a text box to display the frequency of the pm based on what pm is selected. I tried this in control...

Ohhhh I didn't realize I could just leave off "" to make it a number and also I didn't know I had to have '' around EMLK Blue Works wonderfully. Thank you both.

So this is my query and I am trying to average expr2 for each machine, I tried making a form and using a text box with control source set to: =DAvg("Expr2","Query1","Machine = EMLK Blue") I just get error. and expr2 is: Expr2: IIf([Expr1]>=[Frequency (#)],"0","1") which seems by itself it...

So, imagine having a list of customers and all of their different order amounts; EX: customer1 order1 amount1 customer1 order2 amount2 customer2 order3 amount3 customer1 order4 amount4 say all of that information is in a query and I want to average each customer's total amount...

Oh, well I feel dumb now because i was setting it to open on the form but then i could just close the form and reopen it which was throwing the error so i just moved it to open with the main menu and now it works perfectly. Thank you so much for the quick replies and helping me.

So, the set cmbrightclick = nothing doesn't seem to be working then. that line should clear it so it can be run again, right? is there something else that needs to be added or that line changed in some way?

Okay, so the weird thing is if undo everything, delete the module, close everything out and reopen it, create a new module, put in the code it works the first time, if I run the module again it stops working. Am i not supposed to put it as a module?

I'm trying to make a custom shortcut bar. I know I can change the file type to not be editable and just save a backup to edit, don't want to do that. I want to have this one database not be editable unless I want to edit it. I know I can go to options and disable the menus. I have the menus...

What are your thoughts for getting it to look at the latest date for each PM?

I have a form that runs some functions and I want to be able to show unique values only for the form. Is this possible? I have the form pulling its data from a query which I have unique values turned on. The query has report#, machine, component, PM, tech, datecompleted, and frequency. I have...