Search results

I usually don't use spaces - everything that I create is TitleCase but I'm working with imported data most of the time. Ironically, the reason that this calculated field currently exists as "Past Due" rather than PastDue is because I was having an earlier issue where I was getting a parameter...

Thanks for the reply! I get the same "flashing" error. Is it because I'm still referencing a calculated field - [Past Due]?

Good morning all, I've spent two days scouring the web for a solution to what should be a simple problem. I've got a summary form that displays various metrics for the month's shipments. The form has controls that reference several queries based on one table. I have Dsums and Dcounts that...

that was the default query when i pasted your code into the SQL window?

Thank you so much for your help. I created the LeadTime table based on Plog's format suggestion. I then made a table based using my SplitField qry (identical to the spreadsheet I originally posted). I created a new query using both tables and modified your code with my tables and field names...

Arnelgp, This code is in a module Public Function SplitFile(intField As Integer, strValue As String, strDelimiter As String) As String Dim varSplit As Variant On Error GoTo Err_SplitFile varSplit = Split(strValue, strDelimiter, , vbTextCompare) SplitFile = varSplit(intField - 1) Err_SplitFile...

I really don't have any control how the daily data comes over - it's exported out of our system in that format - I'm not sure how to modify to your specs, easily on a daily basis.

The Lead Time table that contains the numeric values isn't completed yet as I'm still trying to figure how this all fits together but I was thinking of: [SS],[AE], [AG],[PL]...[FR], etc. (processes) 1,4,5,1,2....3, etc (lead time in days) The daily sales order information with respective...

Good morning all, I'm going to try and explain my issue as precisely and concisely as possible... I have an imported table field that is a series of alpha-codes, concatenated with ",". Each code identifies a process step and corresponds with a certain number of days left in the entire process...

I understand that forms become subforms when they are added to mainforms. As I mentioned, my DB is filled with them and I've never had this issue. I also don't think that I'm confused about pop-up forms (but anything is possible) - "my" pop-up forms are forms that are hidden until I...

Thank you for reply. I'm really not a total novice when it comes to Access but this little subform is causing me a lot of problems. Per your suggestion, I've renamed this form (and all of my subforms) to sfrm_xxxxxx. I deleted the subform entirely, and made sure that it was, in fact...

ok - the problem that I have is that when I replace the OpenForm command with visible=true, I get an error message that says "you can't go to the specified record". If I switch the code back to OpenForm, it works again.

Thanks for the reply! Are you suggesting that I change the DoCmd.OpenForm part of my code to visible=true? It's not working for me so I think I'm missing something. Would it possible for you to show me which part of my code needs to be modified? Private Sub TagNumber_DblClick(Cancel As...

Good afternoon all! The following code works exactly as I need it to - by double clicking a master form, I can open and populate fields on a child form. The problem is that the code is telling the form to open in a new window, and I'd like to just open in the subform window (I don't want to see...

So the purpose of my post was to determine how to "pass" the information. Can I just add a line (obviously not, because i've tried it) or am I missing a comma, or space or an underscore or and ampersand.... Private Sub TagNumber_DblClick(Cancel As Integer) DoCmd.OpenForm...

Thanks for the quick response! I don't understand how this will populate the [net] field on my new form with the [net] value of the original form? Perhaps I didn't articulate my need properly - i already populate [tagnumber] but at the same time, i'd like to also populate [net]. B

Good morning! Super novice question, I think. How can i add another value to this code: Private Sub TagNumber_DblClick(Cancel As Integer) DoCmd.OpenForm "frm_IPOAllocationWorksheet", acNormal DoCmd.GoToRecord , , acNewRec Forms!frm_IPOAllocationWorksheet.TagNumber.Value = Me.TagNumber End...

Thanks! I'll try this out in the AM!

I use DLookUP all the time - that's why it's particularly frustrating that I can't get this one to work. It appears as a control in a Textbox on my form "DailyReviewForm". I want the textbox to be populated with the data from the field "MFGPart" which appears in the table...

Thank YOU for following up! Cheers!