Search results for query: *

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!

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...

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!

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...

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

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...

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?

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...

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...

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...

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...

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...

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 ...

Just in case anyone has this same issue, I decided to just just block the user from using RustysWorkbook.xls if they have any other Excels open. I call the below function in the .xla file that launches RustysWorkbook.xls. If there are other Excels open, I prevent them from opening...

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.

I'm am trying to create a query table using VBA in an open password protected Excel workbook called RustysWorkbook.xls. This works fine as long as I have NOT launched any other excel workbooks (on the windows taskbar) prior to executing my code. But if i launch any other workbooks before...

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

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...

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...

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...