Recent content by mango97

Hi, I'm working on one of my first complex databases and as a result I am using the me! property for the first time. I've been experimenting with showing and hiding controls on the click of a button and have ran into a problem: One of my controls named WO# and I have been unable to get the me...

Whoops. I had it like that, and it wasn't working. Was trying other things. Must have forgot to change it before pasting here. Same error still: Completed: DCount("[RequiredPartFID]","PartAssembly","[PartFID] = " & [PartsID] & " AND " & [CompleteDate] & " IS NOT NULL")

Same error as above. Here's the new code: Completed: DCount("[RequiredPartFID]","PartAssembly","[PartFID] = " & [PartsID] & " AND" & [CompleteDate] & " IS NOT NULL")

I have a new error now "Syntax error (missing operator) in query expression '[PartFID] = 1ANDIS NOT NULL'." which is followed by error "Unkown". Here is my updated code: Completed: DCount("[RequiredPartFID]","PartAssembly","[PartFID] =" & [PartsID] & "AND" & [CompleteDate] & "IS NOT NULL")...

Sorry for delay, been away from the internet. I eventually came to this conclusion myself and have been working on a query. Here's how I want it to work: 1) A query calculates if a part has been completed. If it has been completed it shows the date it was completed. 2) A second query...

Hi everybody, I'm working on a project management database for my fathers small business. Data Entry goes as follows: Users enter a Work Order, and all the parts that must be created for that work order. The parts have different processes (tasks) done to them to be created. The database runs a...

I don't quite understand what you mean by "build another query on top of that and link ShopProcesses to that query", However I did try the code (and got it to work!). The only problem with the code is that for the first and last tasks in a part there is no "Previous" or "Next" field and results...

I was able to get the DCount functions to work properly :D Ill post the code here just in case you want to see it... Before: DCount("[PartsFID] + [TOrderNum]","TaskOrder","[PartsFID]=" & [PartsFID] & "And [TOrderNum] <" & [TOrderNum]) CompBefore: DCount("[PartsFID] + [TOrderNum] +...

Since the number will repeat themselves for each part how would I make sure that the correct part is referenced? This is what I have so far, Before: DCount("TOrderNum","TaskOrder","[TOrderNum] <" & [TOrderNum] And [PartsFID]=[PartsFID]) I followed your earlier advice and have changed some...

When a task is "Ready" it means that the previous tasks have been complete. So what I was previously doing was having a macro run that after a task was designated as complete it would find the next task and set its [Ready] field to yes. It's only real use is for conditional formatting. When a...

ok, so that can find the next task. How would that set the [Ready] field to Yes? Or, how can I use that to highlight when the next task is ready?

I moved the fields in Task Complete to the Task Order table. When a value is entered into the [CompDate] field a macro (or something) must run that determines what the next task is (same part, next task number). Before this code would work because it would communicate via 2 fields, however I'm...

All seems logical to me... I've been working on fixing my back end and have gotten stuck working on an AfterUpdate macro. The macro should update the next task to appear as ready once a value is entered into the CompDate field. Here is a screenshot of the macro: Link to Larger Image The...

Been meaning to do this for a few days. Will likely get to it on the weekend (I'm responsible for maintaining inventory for the different shops so much of my work day is spent there) I have a form that functions similar to this (WorkOrderEntry) and the view this accomplishes is mostly only...

I got a form approved that uses a tab control, I'll add the file to the OneDrive. My only problem is that when a tab is highlighted the form scrolls so the tab isn't visible. Is there a fix for this?