Search results

Thank you!! It works great now!

OrderNumber contains two value combination from 2 different variables if that makes sense. So I need to search for both varCod and OrderItemRep in that OrderNumber column...

Does anyone see anything wrong with this line of code? It keeps giving me a syntax error. thanks. If DCount("[OrderNumber], [ItemNumber]", "[dbo_EntryStructure]", "[OrderNumber] LIKE '" & varCod & "*' AND [OrderNumber] LIKE '*" & OrderItemRep & "' AND [ItemNumber LIKE] '*" & ItemOrderRep &...

I tried that but it's still returning null values. I'm wondering if it has something to do with this part of the code: PostValCol1(x) = Left(ArrRepOrder(x), InStr(1, ArrRepOrder(x), "-") - 1) PostValCol2(x) = Mid(ArrRepOrder(x), InStr(1, ArrRepOrder(x), "-") + 1...

Hi, my code is behaving a little weird. I'm trying to store all the OrderNumber + Item combinations in 2 arrays and then because the OrderNumber column really contains 2 values I'm interested in, I splite it up and store that column's values in 2 arrays. So in total, I have 3 arrays. An array...

Thank you guys so much. It works great! :)

Oh it works now! I just forgot to include one of the lines mentioned. But it's only extracting the last 4 digits of the array. For example: {018-J018325096} Is now: {018} = Array 1 {5096} = Array 2 I need it to be : {018} = Array 1 {J018325096} = Array 2

Thanks for the reply billmeye. I tried it but now it says that subscript is out of range?

I would appreciate any help you guys. This is the last part in my code that I need to incorporate to make the whole thing work. Please help.

I tried: PreVal() = Split(ArrRepOrder, "-") PreVal() = Split(ArrRepOrder, "-") PreVal = Split(L, ",") But it doesn't seem to be able to recognize any

Set rop = CurrentDb.OpenRecordset("Select OrderNumber, ItemNumber From dbo_EntryStructure Where (ProductNumber = '" & txtPartNumber & "')") While rop.EOF = False ReDim Preserve ArrRepOrder(j) ReDim Preserve ArrItem(j) ArrRepOrder(j) =...

Keeps saying type mismatch on this: PreVal() = Split(StrVal, ",")

Hi, I have values in an array that are formatted like this: {00123-2396667, 46932-780, 8708-0987, 456-22} What I am trying to do is break/split the array into 2 arrays so the result would look like this: {00123, 46932, 8708, 456} AND {2396667, 780, 0987, 22} Does anyone know how to...

aHHHH. stupid me. I should put g-1 instead of just 'g' duhh. it's an array!

Hi, I am having trouble checking if the last array value is equal to 'D'. This is what i have so far but it keeps saying that 'subscript is out of range'... 'g' by the way is equal to 1. It just really means that there's only one value in ArrAC. If Not ArrAC(g) = "D" Then

Okay. Thanks guys :) got it fixed

Also, I've been testing out my code to find out what is causing this problem and for some reason the table prints out just fine with this code: strSQL = ("INSERT INTO " & strTable & " Select c.OrderNumber, c.Item, c.RepId FROM CalculateTotal c WHERE ([Structure] like '*"...

how did you know one of the tables was a query? and the reason is I don't want to show the entire query, I only want to show some of its values along with values from other tables. And I want to show all of these values in one table. Thus my code for all of this.

Ok. I'm lost now. What are you talking about? Why in the world would I use a query to display the results?? The results are being created through code, not from other tables.

I need the table to be automatically deleted and created* not the code lol