Search results

Chris & John; attached is my DB, cleaned up some to reduce the file size. I tried several more times to get this running to no avail. The time control you setup for me is installed on the form but still giving a debug error. the times that should show up in the drop down combo box are pulled...

Can you talk more about the Setvisibility private module. What do I do there? after going step by step through the form event, and the other three events, and placing your code into my project, I can compile W/O error but when I change the form out of design mode, I get the error of "Runtime...

Doing the renaming is fine. The reference names you used in your example make sense. I understand that I can also just change the references in the code to match what I've named stuff. I did that with the SQL statements. the real problem I'm having is trying to understand where to plug in...

OK so far but is there a better way to copy the code from your example over to my project? chris

thanks for the info John. How do I get the controls/code from that form over to my form? This control needs to be in a stack of drop down lists. I tried dragging and dropping the form onto my form, and that creates a subform. When I size it vertically and horizontally, and click on it, there...

looks good except that my hours table for both shifts is all on one table. Your solution uses two tables. I can see that it would be easy to do the color changes that way. I'm picking it apart to see how to plug it into my DB. Seems like though if I change my table into two tables to match...

I've looked at several other posts relating to this issue but all are different from my needs. I have a form with a combo box on it. The combo box row source is a table. The combo box has times in it, i.e; 6:30am, 8:30am, 10:30am, 12:30pm, 2:30pm, end-days. Underneath that list, is a...

got it figured out.

Can this be done with just a regular select query? I don't necessarily have to have this piece on my pivot table query. chris

I have a pivot table I'd like to add another calculated field to. This calculated field would be the result of a known value in a table, divided by a value added by the user when they run the pivot table query. Currently the PT query runs and asks the user for beginning and ending calendar...

bump to the top

if someone could point me in the right direction?

nooooooooooooo!!!!!!!!!

Hello Bob from Portland. I'm down here in Bend. I was hoping someone of your caliber would answer me. I've seen many of your posts and it's obvious you know what your talking about. I plugged your code into the field under Query design and ran the query as a pivot table view. The query runs...

I'm trying to create a totals value in my pivot table. I am drawing from a query that has several fields, the ones used in the math are: LF Run--how much material was run LF Produced--how much became finished product Waste--difference between LF Run and LF Produced is the amount of waste...

Wazz; I've created this so far: A table called "tblEquipment" with a primary key called "EquipmentID" and listed all the equipment equipment, each as a separate field. I also created a table called "tblProblems" with a primary key called "ProblemID" and listed all the problems available, each...

Bump for thoughts on this?

I have a current DB with forms that I've created and so far, for what it does, it's fine. I need to add to a form and I'm stuck on how I need to create/modify existing tables and exactly what control to drive it all. I want to add a combo/listbox to the form. the data in the first combobox...

I tried these and neither worked. I think I need to start over with this and maybe rethink a few things. Some of the instructions provided to me I don't understand. Here is a little more detail. The categories I mention are different pieces of equipment in a manufacturing process. Each...

--Can you explain this more? any further help is appreciated.