Search results

Thanks for replying!...it doesn't work though. It sees that it was open before so it just closes it all the way when I press F11

Hi, this is a really dumb question but I cannot seem to figure out how to open up the view of all the tables I have! There's no arrow or anything coming up when I slide the mouse over the sides to make it larger...please help:o

Also, I am currently uploading the Excel file from my documents folder only. It can't find it unless it's in the documents folder. How do I change that? I want to upload Excel files from any drives on my computer or even Sharepoint. Please help. THANK YOU!!!

Hi, I'm trying to import an excel file that includes a column of Part Numbers that I am interested in. I am trying to import that excel file into an access table called 'TableForImport'. That table has a column called 'PartNumber'. Thing is it's not just one Excel file that I am...

lol and I just realized a mistake I made. Check for 'INT' and 'inte'. NOt 'INT' and 'INT' :p

Thank you guys so much! :) I've tested it and it works great! Doing exactly what i need it to do! Here is my final code in case someone needs it: Set rstt = CurrentDb.OpenRecordset( _ "Select LEFT (RepId, 3) As RepIdd from CalculateTotal where ([Structure] like '*" & u & "*') Group By...

Oh I found a really good resource! http://www.access-programmers.co.uk/forums/showthread.php?p=670210 I'm testing it out on my code right now! I'll let you know how far I get and if it works for me! Thanks so far! :D

Thanks Pbaldy. It works but it's not recognizing that it needs to work with the If statement above it. It's returning that everything is INT since it recognizes at least 1 INT in the column 'Rep Region Code' when it's supposed to only see if that Location ID value from the statement above it...

This doesn't work either...i don't understand what i'm missing here If DCount("[Rep Region Code]", "[tbl_LBP_Sales Location Num]", "[Rep Region Code]" = "INT") > 0 Then

okayyy. gotcha

How come it works just fine for the first IF statement when its column names are within quotation marks? If DCount("[Location ID]", "[tbl_LBP_Sales Location Num]", "[Location ID] LIKE '*" & varCod & "*'") > 0 Then

It returns 'external name not defined' for Rep Region Code when it's not in quotation marks though...

I'm a little confused. What about post three? Having the fields in quotes? It gives me an error when I take them out

I also need the group by statement in the Select statement since it has to return unique values for for each OrderNumber + RepId + Item row. If all three columns are exactly repeated in another row, then only return the unique row. I hope my Select statement before was correct...

It's returning values that have INT or inte when they are not supposed to be returned...I want to only return values that don't have INT or inte in column 'Rep Region Code'

Lol thanks CJ London. That's not exactly the problem i'm stuck on though...how do i fix the second IF statement in the code?

Hi, I hope someone can help me with this. I'm still researching for help but thought I'd post it here. whichever one helps me get the answer the fastest I guess. Anyways, I'd appreciate any help. Thanks in advance. I realize the second if statement is incorrect since my code isn't compeletly...

I've already done my research and I did not understand your answer. Thus, I asked another question. I'm still researching and the whole Redim/Redim Preserve thing is not making much sense to me. I already got your private message. Thanks a lot for reposting it here? Anyways, I guess I'll do this...

Wouldn't that statement only delete the first value of the array though?

I should also mention that my code is within a loop. this means that the value 'u' changes each time it goes through the loop but the array stays the same. Thus my need to erase the array before the next 'u' values in the loop. I would appreciate any help. Thank you.