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 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...
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...
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...
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"...
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...
I believe you can change the size of the field in the report design so it will show all 6 lines. You can also format the field to "Can Grow".
HTH
Beth L
OK - I changed the Data Source to the server name, but now I get this error:
Run-time error '-2147217843(80040e4d)':
Login failed for user 'beth'.
The SQL login for Beth has a Server Role of System Administrator. Database access is set to public, db_datareader and db_datawriter.
Maybe I...
Yes, the system DSN is on my machine (DATA_01).
The server has not changed at all, just my desktop machine.
When I look in Enterprise Manager, the database is there (DATA_01).
Could it be something as easy as renaming the DSN so it doesn't match the database name?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.