Recent content by tony_1974

Hello, Just a follow on the below, Any ideas on how to display the Sales/Month/Plant/Customer under the Combo Batch... Thanks, Anthony

Hello, Just a follow up on this.... Any ideas on how to tackle this? Thanks, Anthony

Email Sent, Thanks!

Hi, I sent you an internal message with the attachment. Thanks for your help, Anthony

I tried with explorer, google and Firefox and I am getting the same message. Any other browser that you can think of to upload this file?

I tried to upload the file, but I am getting a message that says: "Your submission could not be processed because a security token was missing" Not really sure what that is..Any ideas?

Hello, Thanks for the input, Let me describe this situation, perhaps this can describe the structure that you are referring to: Every Month, I receive a new forecast (comes in excel) . this sheet has the forecast for the next month and rolls over 12 months forward. I upload this info into...

Hello, Just a follow up on my previous message. Any ideas on my last question. I would like to put together the forecast for each month with their correspondent demand. However, it appears that the only way to do so, it's creating 2 sub forms. I was thinking that there was another way to do...

Hello, I figure out what was happening: When I created the Qry for November, I abbreviated to QryNovFcst instead of Qry NovemberFcst, so when the code was running it was looking for QryNovember instead of the QryNovFcst. All good now. I do have a question that perhaps some of you might be...

Hello again, After successfully worked for almost 9 months, My db is giving me error messages again. for Every Month that I have added, I add the same formula and worked fine. However, when I add the Month of November, I am getting the following error: Run Time error '2580' The record Source...

Hi, I removed the filter as indicated and whenever I click one of the options, I get a pop message that says: Enter Parameter value for the Quantity_KG Any ideas?

Hi, Sorry for my late reply, I made the recommended changes, but it seems that I am missing something here. I substitute the where for and and it looks like these: strCriteria = "([Ship date] >= #" & Me.OrderDatefrom & " # And [Ship date]<= #" & Me.Orderdateto & "#)" task = "Select * From...

Hi, It worked out, Thank you so much for your help! :cool:

Hi BigHappyDaddy, Thanks for the response, This is what I wrote based on your first suggestion: If Frame1 = 1 Then strCriteria = "([Ship date] >= #" & Me.OrderDatefrom & " # And [Ship date]<= #" & Me.Orderdateto & "#)" task = "Select * From QryIntransit where (" & strCriteria & ") where...

Hello, Thanks for your input. I have 5 tabs on my suboform (4 months of the current year including April + Current month Sales). So this is what I wrote based on your previous response: task = "Select * from QryMarchFcst, and QryDailysales subform, and QryFebFcst subform, and QryJantesting...