Search results for query: *

I have a custom form that allows users to set up an appointment on a Master Calendar with provisions for table setup, parking requirements, etc. I have a button for them to print the meeting with all these things on it. It uses a script that opens a Word template. My problem is getting the...

I have an Access 2002 application where I link to several Visual Fox Pro tables. I want to be able to do the link with a Docmd.TransferDatabase. The ODBC connection string looks like this on my current linked table: ODBC;DSN=Visual FoxPro...

I have a file that looks like this: Account Month Amount 1001 1 100.00 1001 3 200.00 1001 4 300.00 1002 1 400.00 1002 2 500.00 1002 3 600.00 I want a query that produces this (for March): Account...

I have CR 8.0 that I am using the SQL Designer with. I am accessing an SQL (Great Plains) database that has account number, year, period (month), amounts. I built a query in the SQL designer and it looks fine, the months are 1 through 12. When I export it to Excel, it is fine. When I use the...

I know I can combine several companies in an FRx report, but I need to 'mingle' the accounts. For example, I need an account from company A, then an account from company B, then a total. Then I need an account from company C, then an account from company B, then a total. Is there a way to do...

I am getting an intermittent message when I set the recordsource using an SQL. I have my SQL statement stored in a variable called sTemp. I get the error on: Me.Form.RecordSource = sTemp Sometimes it runs OK. I can run it again immediately and get the error, then run it again and not get...

I have a very simple application for a user. It begins by copying three files to a work folder, then linking to them. The keys are irrelevant. Is there a way to suppress the "Select Unique Record Identifier" box that displays? She can hit OK without selecting anyting and everything is OK...

I am trying to get rid of some characters printed at the front of a total line in FRx. I have a row set up with a description of Cash. The link to the GL is '10010 to 15000'. The column prints Acct, Desc, and Current amount. I always want to print a detail level of Account Only. I get a...

I am just starting with FRx. I want to do what seems to me should be a very simple report. I want to list all the accounts in a small company. I want budget subtotals by the 3rd segment, then by the 2nd segment, then by the first segment. I am getting the budget amounts OK, but each account...

Is there a way for Crystal Reports to include information from multiple companies? I have an ODBC set up for each company, but how do I set it up so I can combine the information from different companies?

I am just starting to look at FRx with Great Plains. Is there a way that I can set up the rows to use fields in the GL account master other than the GL number. For example, could I use the Alias field to define a range in 'Link to General Ledger', or the User Defined field?

We have just installed Great Plains and have been looking at the different features. Our users do a lot of importing of GL entries, etc. and we thought the Integration Assistant for Excel sounded like the easiest to use. Where is it? We looked on the Install Additional Components on the Great...

We have a report that we are able to export from many PCs. We have recently installed a WTS server, using Windows 2000. We installed the complete professional CR 8.0 on the server. When we run the report and try to export the results, we get a message that says 'No export dlls found'. This...

We finally got a compiled report to export to Excel. However, after we tell it we want to export, it takes several minutes before it asks what file name we want to export to. This is version 8. We don't have the problem on machines that have the full Crystal installed, only those that have...

I have a parameter query that is truncating the last part of the prompt. Is there a way to increase the width of the input box? Or another way to get the whole prompt to show, other than rephrasing?