Recent content by budbeth

I'm new to AS 2005 and am not sure the proper place to put this.... I need to be able to access the following in other cube calculations: Previous Month Current Balance: SELECT CURR_BAL FROM PERFORMANCE P INNER JOIN MASTER M ON P.ACCT_OID = M.ACCT_OID WHERE M.PROCESS_DT =...

I would think that if you put the formula in the DATA tab query, you could just refer to the field as REVENUE.

Add another group (Group #2) for the Transaction Type. Then create a formula to count & add to the group footer. Beth L.

I was able to get the following to work: Dim objXLApp As Object Set objXLApp = CreateObject("Excel.Application") objXLApp.Workbooks.Open strpath With objXLApp .DisplayAlerts = False .ActiveWorkbook.Saved = True...

Sorry - I forgot to mention that I have the code on an Access form in a reporting interface database. budbeth

In VBA, I'm trying to open a .csv file and SaveAs a .xls file. It will work with early binding, but I have to use late binding due to different versions in use here. The following code will work up to the SaveAs line. Then I get an error #1004, "...Programmatic access to Visual Basic Project...

Try SendEmail instead of Send. Beth L

I recently found & used some code I used successfully in VBA. In place of the VBCrLf, it used |. Hope this helps, Beth L

Yeah, I knew the merger was coming a awhile back. I was on their Crystal Decisions site one day and the next -- less than 24 hours later -- it was being switched. If we're lucky they will continue the Knowledge base... Beth L

Glad I was able to help. Just an FYI -- I went back to the Crystal Decisions web site to look something else up & found out it's down as they convert it for the new company, Business Objects, that bought out Crystal. Beth L

From the Crystal Support web site Article ID c2001866: Synopsis How can a whole number, like 98268.00, be converted to a date, where 98 is the year and 268 is the number of days since January 1st? Solution Create a formula that formats the field as a 5 digit string, passes it to a string...

Mid([datefieldname],5,2) & "/" & Mid([datefieldname],7,2) & "/" & Mid([datefieldname],3,2)) HTH Beth L

I need to do the following in a trigger: IF NOT EXISTS(SELECT...) --record doesn't exist IF inserted.CODE = "N" --CODE = "N" INSERT INTO... SELECT.. FROM table ELSE --record doesn't exist & CODE = "S&quot...

Does anyone know if this can be done? I have a Public variable (strItem) in my VBA code and want to pass it to my VB.exe I'm trying to get the VB.exe to grab the variable and use it to find records for my DataGrid. Any pointers the the right directino are much appreciated... Beth L

I'm trying to use the following to look up records. I think my problem is the second RELATE - Loc TO Loc. When I use only the first RELATE - Item_No TO Item_No I get too many records. I need to filter by the second RELATE but can't seem to get the syntax correct, no matter what I try... SHAPE...