Search results for query: *

I have a couple of macros where I had set the path in the code, not realizing at the time that because of different rights, not everyone has the same path. Also, it is not good to hard code the path if drive letters and such are eventually changed. For example, one person may have P:\LoanData\...

I have code that in August when I created was working fine. For some reason today, the csv file that is created is empty. I have not changed anything to the code and when I step through the code things look like they work, but the file is empty. Here is the code that calls the procedure that...

I am using Powerpoint 2002 SP3. In Print Preview under options I checked off the box to show slide numbers for my handout, however the slide numbers are not appearing. Any ideas of what I may be doing wrong? Thanks

I am using Crystal XI. What I would look to do is display data as follows Year Value Year Value Year Value 2007 100000 2012 53000 2017 0 2008 150000 2013 0 2018 155000 2009 106000 2014 53000 2019 0 2010 200000 2015...

I am using Crystal XI and was wondering is using running total the only and best way to create a weighted average the does not include zero values? The weighted average function includes zero values in the weighting and the user does not want that to happen. Thanks

We have a proces where users inter information in Excel and Access linked to that data. Access is used to extract that data and append it to a table in SQL Server. The rows get added to SQL Server, however, not all of the data is populated. Looking at the Excel spreadsheet only the data in the...

We are using Powerpoint 2002 and I have created only 1 Powerpoint before. The idea I have for a Powerpoint presentation I want to show is probably advanced for my level. Within my powerpoint presentation I would like one of the slides to act like some web page setups meaning. I have about 10...

We are using BO XI and are sending a file via FTP. The person who is receiving the file would like a naming convention of source_pos_yyyymmdd.txt where yyyymmdd is the current date - 1 or - 3 if the day the report is run is a Monday. Note, the data in the report has the same date criteria. Is...

I have created a dynamic parameter that has 4 levels. The first level only has to types of data and L or an S and for some reason only the L is displayed. Why is that?

I've been thrown into the fire and asked to make some reports using Crystal 11. To date I have not used this version. I don't have a book for reference and I do not think Crystal help can help. I have set up 2 dynamic parameters usings fields from a database. Lets say field1 is Department...

We are using Crystal 11 and I cannot find a feature that was in Crystal 5 and 8.5. There was a button to click to get back to the report wizard. Is that feature not a part of C11? I cannot find it anywhere.

We have an Oracle process, that when completed, FTP's a flag to our Crystal Enterprise environment. That triggers a report that when completed shoots off an email to a distribution list. From that email we have someone here that 30 minutes after the email opens up an Excel spreadsheet that...

We have an Oracle process, that when completed, FTP's a flag to our Crystal Enterprise environment. That triggers a report that when completed shoots off an email to a distribution list. From that email we have someone here that 30 minutes after the email opens up an Excel spreadsheet that...

We are using Microsoft Project 2003 - my boss created an Excel spreadsheet with a list of enhancements. The list contains an ID NO., requester, description (not a task name, but rather a summary of the issue), priority, rank, status, and notes. A coworker created a project plan to turn the...

I have an existing Crystal 8.5 that is omitting data. There are 3 core tables used in the report, two of which are history tables. The issue is twofold, (1) to link the history tables the third table has to be used and (2) one of the history tables does not have records for the date being...

I have the following code in ThisWorkbook. When I go to close the spreadsheet I get a compile error stating that the variable was not defined. Private Sub Workbook_BeforeClose(Cancel As Boolean) If Not DEBUGMODE Then ThisWorkbook.Saved = True End If End Sub I took this code from...

I'm mentally stuck. I have the following: select b.loan, b.int_coll_p, (select isnull(sum(r.interest),0) - isnull(p2.interest,0) from nyl_sfp_poolmast p1 left outer join nyl_sfp_remit r on r.pool = p1.pool left outer join (select pool,accrued_int as interest from...

I have the following piece of code in an Excel 2002 macro. What it basically does is clear out any data that goes past the last row of records, thus basically clearing out in summary values. The issue I have is - if a file does not have summary values - it clears out my last of row of data...

Using Excel 2002 I have a macro which copies data from one spreadsheet, opens another spreadsheet, copies the records to the spreadsheet that was opened, and this closes that spreadsheet after the paste. It is possible for the user to already have that spreadsheet open. I have found code that...

I know my questions are probably pretty elementary, but this VBA thing is OTJ for me. My macro opens files in a folder and takes various actions of the activated sheets. I thought using Application.ScreenUpdating = False and Application.ScreenUpdating = True would keep the opened workbooks...