Search results for query: *

I've been asked to help analyze customer service survey results. Here is a sample of the data. Q4 - Q9 relate to specific questions that the customer answers. They can score Q4-Q8 as 0,3,6,9,12. 0 being Unsatisfactory, 12 being Excellent. They can score Q9 as 0,10,20,30,40. 0 being Unsat, 12...

Crystal Dev v9. Microsoft SQL 2005 database. I have a parameter that allows multiple discrete values (string) There is no default value for this parameter. I would like to limit the number of values that the user can enter into this parameter to six. Can this be done? Linda

I installed a new hard drive as master and set up the old hd as slave. I installed the Windows XP OS on the new HD as well as programs etc since I believe the old hard drive is getting ready to quit (clicking). If/when the old HD quits can I change the new hard drive to be C: instead of F: ? I'm...

I have a form that is based on a query which contains 2 tables. These tables have a one-to-one relationship. This form allows edits and deletions. I have a SAVE button on my form. The code follows. Private Sub SaveBtn_Click() On Error GoTo Err_SaveBtn_Click DoCmd.DoMenuItem acFormBar...

I have the following code on a form. It works fine, however, I would like to force the NO button to be the default when this message box comes up. Also, somehow show that NO is pre-selected for them by changing the appearance of the NO box. Private Sub DeleteBtn_Click() On Error GoTo...

I have two software applications. Both use ODBC datasources to connect to the SQLServer databases. Both are TRYING to use the default PORT 1433. Is it possible for this to work correctly, or do they have to have different ports! Software vendors are NO help! Thanks, Linda

Using Transformer and selecting Run I get an error at finished. Error below- (TR1901) There is an error in the expression parser. (Measure) in d:\temp\cubename.mdc Can someone tell me what this means. Thanks Linda

Does anyone know what this error means and how to fix it? I am in Impromptu Administrator trying to set up an SQL database. My user name and password are correct. Error number -4: DMS-E-CONNECTREJECT, A connection has been rejected by the remote interface during operation 'attach database'...

I need to find all cells (in 1 column) that have more or less than 12 characters. If the column contains exactly 12 characters than I don't want to see it. Can someone help please. Linda

My question concerns SQL Server, MS Access, and Crystal reports 8.5. I usually create my crystal reports using an odbc connection to the SQL server database. This particular report contains so much data, I decided not to stress the server with it each time the user wants a report. Instead, I...

I don't know if this is possible, but if so, can someone help. I would like to include a parameter (?Fiscal Year) in my record selection, such as... Table.Date in ?Fiscal Year I don't want the user to have to enter actual dates in the parameter because I only want to pull one fiscal...

I have a form with 2 text boxes for users to enter search criteria. There is a search button which works great. I got the code for it from this forum. What I need to do now is this, When a user enters the search criteria in textbox1, and hits the enter (or tab) key, I want the textbox2 to...

I have a macro that runs via button on a form. The macro uses the TransferText action to run a query and send the output to a .csv file. This works great, BUT.. I want to validate that the user puts data in when prompted by the query's parameters. I don't want it to run if the user makes a...

Hi... I have a report that contains an on demand subreport. I made the subreport 'on demand' because it contains notes that pertain to the main report's details. These notes are used for reference when needed, so I did not want to have the subreport run automatically (takes longer to process and...

I have a report with a Report Header, Page Header, 5 Group Headers, a Page Footer, and a Report Footer. The report footer contains a crosstab report that summarizes the data found in the details. In Format Section, Page Header, Suppress formula editor I used WhilePrintingRecords...

I have a form (Form1) with a Command Button that runs a Macro (UpdateMacro). The Macro runs 4 update queries. When last query is complete, a message box opens with 'Update Complete'. User clicks OK, and the macro reopens Form1 in maximized view. I want a field on the form that will show the...

Whenever I use Pervasive Control Center on a client machine to access database tables on a Pervasive 2000i.SQL server , the server folder within the configuration folder 'drops', and I have to reinstall Pervasive on the server. Any idea why? Linda

I'm running an old Dos program on XP. There are alot of things I have been able to fix, but this isn't one of them. I have a batch file that contains one command: copy h:\division\or_sch_f.txt lpt1 obviously, it is just supposed to print a specific text doc to the printer on lpt1. When the...

I am running a dos application from WinXP. I need to be able to direct printing from within my application, w/o user intervention, to the printer on LPT3. Before XP, the batch file used a setprt 3 to set the printer to LPT3. That no longer works. I can capture a specific printer to LPT3 from...

I have a dos-based program running on XP. With Win95 a user could type PCONSOLE to access the printer console. Of course, this is unrecognized in XP. Does anyone know a command I can use from the command shell that will get the same results?? Linda