Recent content by MarshaPav

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...

No, the Save Password box was not checked. The table build from the Database Window is working, built with the DoCmd, it is not.

The connection string I am using is what was generated when I built it from the Database Window, i.e. Tables/New/Link etc. So the dsn is OK and evidently it doesn't need any more security.

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...

That did the trick! Thanks! Marsha

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...

Yes, I am using a reporting tree. Actually, my 'natural' account is segment 4. All I want to do is list each account, the budget for a month or whatever, and total by segment 3, segment 2, and segment 1. It doesn't seem like it should be that hard, but I sure can't get it to do anything like that.

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?