Search results for query: *

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

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

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

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

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

Hello, I need to do a filter (after the database query has run). The formula field is a comma delimited string that I want to filter against a parameter array. The selection formula below fails with "This array must be subscripted. For example: Array[i]." AND SPLIT({@FILTER_Products},",")...

Excel 2000 When I insert a label onto a form and try to move it above a tabstrip, the label just goes into the the active tab. When other tabs are selected the label disappears but comes back on the original tab. I need a persistent label over all the tabs. I tried using the Bring Forward...

Below is some sample data that I need to extract the number (age), the M or F (gender) and the rest after the M or F. The problem is that age is the first character for single digit ages, the first two chars for double digit ages, and the first three chars for triple digit ages (real old). I'm...

Excel 2000 This example is a direct copy of how I can duplicate the problem. I can't figure out why the Change event would fire right after ThisWorkbook.Close. It causes an error when the workbook closes because the Change event has some activesheet references in it that aren't applicable if...

Hello all, When accessing records through a basic datagridview that has a bindingnavigator in VS 2005, changes made do not save to the database even though I click the save button and no errors occur. The database is attached from the application folder and uses the below connection string...

Oracle 8i CR XI R2 Hi everyone, I have read that adding a select statement that correlates to a field in the main SELECT statement is possible. I tried doing so and was told I had an Invalid Column. "BKB437_REV_CD_COV" is the external table in question. Any ideas? (SELECT...

Is there way to force Crystal to NOT verify the SQL in a SQL Expression. I have found that when a SQL Expression references two or more disparate tables it takes a VERY long time to verify. I know the SQL is right so I don't want Crystal to verify it. Thanks for any help, Joel

This is posted in the Data Access forum but it pertains to formula's as well and so I wanted to make sure it appears in searches here. Hi everyone, I just loaded my first faq: FAQ766-6779: How can I use a Multivalue or Date Range Parameter with a Command. You guys have helped me figure out a...

Oracle 8i Hi everyone, I created a View that adds RowNum to an existing table as shown below. When I join to this new view from another table, I was expecting to get the RANK column for each primary key in the other table that has a one-to-many relationship to this view. I didn't realize...

Hi everyone, I just loaded my first faq: faq766-6779. You guys have helped me figure out a lot and I wanted to give back something to the community. I have seen this issue come up before and have run into myself. I finally figured out a workaround to it. It is of course a last resort...

CRXI R2 Is there anyway to reference a parameter in a SQL Expression? I want to return a database field conditionally in a SQL Expression based on a parameter answer. Probably not, but worth asking ;-)

Hello, If I sum a database value in a subreport in a group, the SQL performs the group by on the server. But if I declare a shared variable to do the exact same thing it does not. Is there a way to get crystal to perform grouping on server with a shared variable in a sub report so I can pass...

CR XI R2 When I refresh a main report, I noticed that the "Subreport: Reading Records" happens twice for the same amount of records (4486). The subreport is in GH1a and contains two shared variables that are references in GH1b. Both variables are two different sums in the Report Footer of the...

CR XI R2 Hi everyone, I need to put together a package of about 15 reports and am hoping anyone can share their tips for accomplishing this. The reports are different enough that they must reside in different .rpt files but the user needs to be able to: - Refresh them all from a single...

CR XI R2 Oracle 9 Hi everyone, I am trying to make a simple SQL expression against a database. When I click ok, Crystal does a check against the server and Crystal hangs for hours until I receive an error about a temp table being out of space. I unchecked "Compile SQL Expressions" thinking...