Search results

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

Hello, Let me explain again: I have a form with multiple combo boxes. Each boxes filter the information from the previous box. So I can go to a granular level if needed to. My form also have a sub form. The sub form have many tabs. Each tab represent a monthly forecast. One tab, also...

Hello Everyone, I am currently working on a form with multiple sub forms. Each sub form represent past forecasts with detail level, such as product type (ie box/bulk,etc). I was wondering if there is any way to link all of the sub forms to the combo boxes When a specific type of product is...

Ok, I give it a shot, but now I am getting this error Run Time Error 3075: Syntax Error (missing operator) in query expression ..... My code is listed below...... Private Sub Frame1_Click() Dim strCriteria, task As String If Frame1 = 1 Then strCriteria = "([Ship date] >= #" &...

Thank you Sneuberg, Perhaps I didn't explain myself correctly. If so, my apologies What I am trying to is: After the form has been filtered based on date range. I want to be able to apply the Option Group, to select based on additional criteria (A or B), so that the form can show the results...

Hi Everyone, I am a newbie in this forum. I am currently working on a access db that has multiple forms/Queries/Tables. The form that I am working on, comes from a Query. The information in the form is re filtered based on date range. Then, the remaining results need to be filtered based on a...