Search results for query: *

I am trying to create a SQL query (SQL Server) that will take what is currently in rows and spread out over a column. For example, the data currently displays like this: lookup_key group_name 100 CARDIOVAS 100 CARDIOVASMS 101...

CR 9 I created a directory from our database in CR and I'm just about finished with it, except one problem. The font size scales down a half size when I export to Word. Which, I assumed, I could just fix easily by using a font in Crystal a half size bigger, therefore getting the needed font...

CR 9 I created a directory from our database in CR and I'm just about finished with it, except one problem. The font size scales down a half size when I export to Word. Which, I assumed, I could just fix easily by using a font in Crystal a half size bigger, therefore getting the needed font...

ACT! 3.0 and CR9 I want to pull some simple reports from ACT because the report builder function is horrible within ACT. I'm using Crystal to build a report grouped by Record Manager, but it seems the field is encrypted. Does anyone know a solution to this problem?? Any help is appreciated!!

We are running a very old version of ACT! (2.0) and a user has asked that her records remain hidden from all other users. Is this possible? The simple security setup in ACT! doesn't show such options, but I was hoping someone knew a trick. Thanks in advance!!

CR 9 I created an index using arrays with the assistance of the following article: http://support.businessobjects.com/communityCS/TechnicalPapers/cr_arrays.pdf However, I'd like to have the index alphabetized and can't figure out how I'd do it. Can anyone lend assistance? Thanks in advance!

I need a way to combine two queries in order to run them in unison for a report that needs to call them as a stored procedure. The delete query is as follows: PARAMETERS [{?LinkReceiver}] Text ( 255 ), [{?DateTime}] DateTime; DELETE * FROM TableOfContents WHERE...

CR9 I have a report that I would like to display the first record of each page in the page header. I thought it might be possible to use minimum({table.record}) if I could figure out how to have it re-evaluated for each page. Like the following: PH Page 1 Adams County D...

CR9 I have a report with multiple columns and I need to place a index tab on the edge of the upper right hand corner for odd pages and the upper left for even pages. I understand how to conditionally have it switch back and forth via different page headers and conditional suppression, etc., but...

I know there's a thread on this, but I can't seem to find it. Guess that will teach me to bookmark. How do I set up a report to pull only those records on a seperate list? For instance, I'm pulling offices with all respective employees. I only want to pull the offices that are listed on...

I currently have a report that is grouped by OFFICE. Individual PROVIDER fields are in the Detail section for each office. A provider number is being populated in our database for each provider and I only want to see those offices with 50% or more of providers without the number. Such as...

Does anyone know how to UNinstall the Crystal add-in for Access?

I have created an on timer event that mimics the MKB article found here: http://support.microsoft.com/kb/210297/en-us The only difference is that I changed the IDLEMINUTES to 20. Also, I added in the following event procedure to the module: Application.Quit acSaveYes So, the full module is...

Would anyone be so willing to provide code in order to send groupwise appointments from an access bound form? I have a bound form that I'd like to add a send button to that would use information from the form and send an appointment. Fields on the form are name, email address, date, time...

CR9/Access DB I created a crosstab that looks as follows: Appointment Phone Call Fax Mail Person1 5 6 8 10 Person2 6 4 10 9 Person3 8 11 4 6 "Blank" 1...

WinXP, Excel 2000 I have a form created in Excel and I want to lock down a combo box. I would like to have an inputbox appear that asks for a password, then code to verify the password and allow use of the combobox if correct. If anyone could help me with this, I would be very...

WinXP, Excel 2000 I have a form created in Excel and I want to lock down a combo box. I would like to have an inputbox appear that asks for a password, then code to verify the password and allow use of the combobox if correct. If anyone could help me with this, I would be very...

Is there a way to suppress zero data labels in a chart? Any assistance would be appreciated. Thanks!!

CR 9 and 2 Excel Spreadsheets I'm trying to write a formula field that shows only those from table1.field1 if not equal to table2.field1, table2.field2 or table2.field3. I thought this would be relatively simple, but the formula isn't working correctly and is as follows: If {table1.field1} <>...

I have a query in MS Access that pulls fax numbers and I have Excel set up to receive that information via MS Query. However, although the table and query in Access where the fax numbers are stored have input masks for the fax numbers that include ;0 to store the data like that, it pulls it...