Search results for query: *

Thank you again Loomah! Thanks for letting me know how to modify the code to make it unique if the decision was made to show less data. However, when I run the program, I receive: Run-time error '1004': ShowAllData method of Worksheet class failed Then it highlights the .ShowAllData line in...

Yes it worked! Thank you Loomah! Is it easy to show on the result page which datasheet it came from? Perhaps just add the name of the datasheet to the first cell of each row in the "Results" page so the datasheets are not modified? Again, thanks a lot for your Excel expertise! -Lory

Is there a way to only insert the row once to "Results" if the value happens to be in more than one column but the same row? Thanks for your help!

OH, i changed it to a string and it worked! Also, I changed lookat:=xlWhole to lookat:=xlPart so it does not match whole value in cell. THANK YOU SO SO MUCH LOOMAH!! :-)

Thanks Loomah!! Yes i am looking for the search data anywhere in the dataset not a specified column. Is there a way to put that code in a button_click()? I tried to do that but it seems to complain about the "ByVal Target as Range". Thanks again for your help.

Hi, Just want to clarify that the search toolbar is basically a cell where the user types in the "string" they want to search for in the data worksheets within the workbook. Thanks again, Lory

Hi, I have a large excel workbook consisting of 2 worksheets (which later on we may add more). Is there a way to have a search toolbar on the first worksheet letting the user type in a search string that will query all the rows in data worksheets and display it in the "results" worksheet...

Hi, I have configured my SSG520 to send a SNMP trap when it detects a link down, however, the trap that is sent looks like: Enterprise: .1.3.6.1.4.1.3224; Generic: 2; Specific: 0; Variables: [1] mgmt.mib-2.interfaces.ifTable.ifEntry.ifIndex.4 (Integer): 4 [2]...

Thanks a lot ArkM!!!

Hello all, Will anyone be able to give me a list of all the commands that I can use with HTTP 1.1 servers? (example: GET) Thanks a lot. Lory

THanks SantaMufasa!! It works perfectly now. Thanks again : )

The script works...however, there is still a couple problems. Since my table has about 200 columns, my select statement is very very long. I cannot do select * because I need the fields in a specific order. So I've got this SELECT statement that looks like: SELECT 'BAND "'||field1||'"...

Thanks JaggieBunnet and SantaMufasa for your quick replies! Yes, this is exactly what I need. Thank you so much. I'll give this a try and if I have further questions I'll let you know. Thanks again :)

Hello all, I'm new to Oracle and need to output all the records from an Oracle table to an ASCII file. The problem is I need to format the ASCII file in a certain way... Each record has to start with the word BAND in uppercase letters then the first name field, last name field, address field...

Thanks Craig0201 and Ed2020!! :) It works perfectly! You guys are genius! Thanks again for all the help.

Thanks CajunCenturion and TheAceMan1 !! I'll keep that in mind. So the datatype variant can accept any datatype, it's sort of like a wildcard?

Actually I combined the function and the sub that calls the function into one sub since that won't have any problems passing long arrays. Thanks for the replies!

Thanks for the reply Ed2020. same thing, perhaps Access 97 can't have arrays as return types?

Actually, I would like it to return an array which is of Long datatype. What is the syntax for array as return values? Thanks again!

Thanks Ed2020 I gave it a try and it gives me syntax errors on the following lines... Public Enum EncryptionMode ... End Enum Public Function vbEncrypt(strText As String, strPassword As String) As Byte() Public Function vbDecrypt(strText As String, strPassword As String) As Byte() Private...