Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RustyAfro

    MDB not deployed in VB 2008 clickonce app

    Thanks, that definitely helped! I needed to go to the Publish tab and click on "Application Files" and set the mdb to "Include" instead of "Data File" (I'm using it for other purposes than data). Thanks!
  2. RustyAfro

    MDB not deployed in VB 2008 clickonce app

    Hi all, I have a basic console application with an mdb file added as a file to copy always. After publishing the app using click-once, the published directory has the myaccess.mdb.deploy file. When setup.exe is run, the app installs fine. But when I look in the actual installation directory...
  3. RustyAfro

    Initialize/Set with either an array or delimited string

    Nice, I didn't realize I could pass an array directly to the .TO collection. I'm happy to kill the loop! Thanks, and a star for you too!
  4. RustyAfro

    Initialize/Set with either an array or delimited string

    Hi Dave, In the end I used overloading as well since I didn't like having an error at runtime if a non-string or non-array was passed in; I'd rather have an error in development/debug. The only different thing I did different from yours is kill the property all together and made three...
  5. RustyAfro

    Initialize/Set with either an array or delimited string

    Yes, that does work. Here's a star, thanks!
  6. RustyAfro

    Initialize/Set with either an array or delimited string

    Fiddling with this I found that using an Object seems like it might work. Anything wrong with going this route? I think it would be weakly typed and doesn't allow me to restrict to only an array or string but it's the only thing I can think of other than creating a differently named SET...
  7. RustyAfro

    Initialize/Set with either an array or delimited string

    Thanks for that, its basically what I did as well. If the calling code needs to change the emails on a second call of the same class isnstance, should I just make two separate properties, one with a SET for an array and one for a string?
  8. RustyAfro

    Initialize/Set with either an array or delimited string

    That didn't seem to work for me. If I try to pass an array of string emails to the Property, I get an error that the array cannot be converted to string. The goal for me is to let the class accept either an array or a string from the calling code and let the class take care of converting the...
  9. RustyAfro

    Initialize/Set with either an array or delimited string

    Hello, I want to make a class that requires a variable of email addresses upon initialization. The class should be able to parse an array of email addresses into a semicolon delimited string OR just accept an already pre-parsed string of semicolon delimited emails. I'm trying to figure out...
  10. RustyAfro

    Return a string with comma and ' in it.

    Hi Jax, Your right, it is a simplification of the practical need. True, if it was a programming environment I could easily take care of this. But I'm working with an enterprise reporting tool that gives no option to scrub the string before it is passed to Oracle to execute. The tool never...
  11. RustyAfro

    Return a string with comma and ' in it.

    Sorry, let me clarify. I meant to say that "SELECT ('''a'',''b'',''c''')" returns what I want, but I cannot actually implement a solution like that because I have no means to add additional single quotes to force oracle to treat the quotes and commas as part of the entire string. Unless there...
  12. RustyAfro

    Return a string with comma and ' in it.

    Hi Mufasa, I was afraid you would say that :-(. The below returns what I want, but I have very little control over the practical need behind this question so cannot add more single quotes unless it can be done through a function call. SELECT ('''a'',''b'',''c''') as MyField From Dual A 3rd...
  13. RustyAfro

    Return a string with comma and ' in it.

    Hello, I need the below SQL statment to return a string "'a','b','c'" exactly as shown as a field. Oracle see's the commas as separate fields. Is there some Oracle function that will return whatever is passed in as a literal string instead of trying to parse special characters like ' and ...
  14. RustyAfro

    Excel Querytable Connection to Password Protected Workbook Problem

    ...& strComputer & "\root\cimv2") 'query Win32_Process for all Excel Instances Set colExcels = objWMIService.ExecQuery("Select * from Win32_Process Where Name = 'Excel.exe'") 'Count the instances of excel returned, if >1 notify user If colExcels.Count > 1 Then IsExcelAlreadyRunning = True...
  15. RustyAfro

    Excel Querytable Connection to Password Protected Workbook Problem

    Thanks SkipVought, That's a good suggestion, but its not uncommon for the users to have 6-7 different Excels open before they run my app. Having them save and close everything before launching my app will not work as a long term solution.
  16. RustyAfro

    Excel Querytable Connection to Password Protected Workbook Problem

    ...CurrentDirectory = GetNetPath(Left(ThisWorkbook.Path, 1)) End If 'Assign connection string connString = "ODBC;Driver={Microsoft Excel Driver (*.xls)};DriverId=790;" & "Dbq=" & CurrentDirectory & ActiveWorkbook.Name & ";" & "DefaultDir=" & CurrentDirectory & ";"...
  17. RustyAfro

    Remove duplicates in a comma delimited string.

    LBASS, thanks for your tip, just saw it. Trying the redim preserve in the loop as you have it. Thanks again! Joel Seguin Health Net IT Health Economist
  18. RustyAfro

    Remove duplicates in a comma delimited string.

    Ok, I have a working solution below. I want to declare the size of Rev_Array_Final in the declaration but get an error when i do so (forcing me to redim it). Other than that it seems to work ok though I am open to suggestions for better performance. Thanks everyone ;-) whilereadingrecords...
  19. RustyAfro

    Remove duplicates in a comma delimited string.

    Arggh, dontcha hate it when you post code and then see a typo? "Rev_Codes[counter];" should be "Rev_Array[counter];" I think I almost got it now, It's returning this string: 250,,260,,270,272,,,,278,301,,,,,,,,,,,,,,,,,,, I thought the i:=i+1 was only occurring after the "THEN clause, but it...
  20. RustyAfro

    Remove duplicates in a comma delimited string.

    I have a string that looks like this: 255,255,124,532,322,322,322,664,342 I need it to look like this (No Duplicates) 255,124,532,322,664,342 I wrote this code, but it just returns a bunch of ",,,,,,,,,,,". The max amount of elements is 30 in the original string, but I'm not sure if I am...

Part and Inventory Search

Back
Top