Search results for query: *

Hi, Is it possible to have just one copy of a distributed form that users can access and submit responses through? I ask as this is what I've done with the 'distributed' pdf on a local server. I tested it and although the respondants are indicated in the 'new' section of Tracker I can't...

Good afternoon, Am using CRXI and am trying to construct a report that identifies how many records were 'open' at a particular historical point in time. I.e. I have 6500 records each with a separate closed date, I need my report to say x number of cases were open in this particular month. I...

Good afternoon, I would've posted these seperately but as they are quite closely connected and on the same project it seemed a bit pointless. 1st question: I have created a very simple report and want to filter the records based on a range parameter. I've created the parameter but it's not...

Good morning, Am using an Access 2003 database that has had this issue for some time. Basically it is creating copies of itself, seemingly at random. The database is, imaginatively, titled Access Request Database but the copies are all named db1, db2, db3 and so. If the copies are deleted...

Good morning everyone. The title of this thread almost says it all. What I need to add is that I only want the form to cancel opening if the filter value passed from form A does not exist and the user hasn't clicked the 'Add New Case' button on Form A. What is happening at the minute is my...

Good morning, Possibly a newbie question, blame it on it being Friday. How do i reference a query in the 'Expression Is' section of the conditional formatting dialog? Thanks in advance for your help.

Hi, I have a main form and 7 tabbed subforms. When I carry out a search of my records it only appears to search the first subform and ignores the rest even if the particular subform that I know holds the information is active and open. How do I ensure that a search covers all of the subforms...

I've checked out other similar threads but haven't found anything that seems to match close enough. Basically I have a subform that is used as a 'Status updates' notation area with each note occupying one record on the subform along with the status itself, the date and the user name of the...

Good morning, I have a nice very simple form. What I need is to distribute that internally for use as a template to be completed and sent to external clients. There is no need for the form to be returned or any data collected. Can anyone provide a pointer as to how this can be done? Once the...

Hi, I'm running CRXI on XP and hope you can help. I currently have the following crosstab: Jan Feb Mar Outcome1 {@InTime} {@InTime} {@InTime} {@OutTime} {@OutTime} {@OutTime} Outcome2 {@InTime} {@InTime} {@InTime}...

Hi, I have a report that contains 3 linked tables. Currently the report produces the sequence shown in Fig 1. Fig 1. For a case that has two departments and two questions associated with it: CaseID(n)----->Dept(n)----->Quest(n)---> -->CaseID(n)----->Dept(n+1)--->Quest(n)--->...

Hello, I've looked around the forum but have been unable to find an answer to this question. I'm using CRXI and have created a daterange parameter to select records. The issue I have is when the parameter prompt window runs it asks for the date to be entered in the following format...

Afternoon everyone, I have a formula that returns the percentage of one value against another. The formula itself is working correctly. count({@Within IGO Deadline}) % Count ({Main.ID}) My records are grouped first by Legislation and then by Quarter. My problem is that the formula is...

Hi, As stated I'm brand new to Crystal but have some basic Access and VB knowledge. I need to show the percentage of cases that have passed their deadline as part of my report. The actual formula for doing this shouldn't be a problem as it would be something along the lines of: 100 *...

At the risk of sounding massively dumb here, I've got a fairly large pivot table but am unable to see all the data on it because when it's expanded the bottom goes off the screen and I don't have any scroll bars. Am I being really dense here? Any help would be much appreciated as I'm wasting...

Good afternoon, We use Acrobat Standard to manipulate scanned pages and as part of this process we use polygons and stamps to hide parts of text that we don't want the person viewing the files to see. Obviously, we can't just give the viewer a copy of the pdf as they can just move the polygons...

Good afternoon, This may be better off in the VBA Code Forum. If so I apologise. I have a control - 'Legislation' -that when a certain value is selected - 'DPA' - two dates are calculated, another control 'FOIType'(a combobox) has it's value set to "n/a" and the focus moves to another control...

Maybe this is a question of 'if it ain't broke...' but I currently have a form whose ID box consists of three controls squashed together to appear to the user as one ID code as below: e.g. 06-0054 I've created is a text box that is producing the right numbers but doesn't keep the...

Before I start to beat my face against the desk I sincerely hope someone can help me out. It would seem like the simplest thing in the world, I'm trying to fill a variable with the current year to use elsewhere in my code however Year(Now) is producing a type mismatch. 'Month(Now)' and...

Good afternoon. I have an Option group consisting of 4 options Q1, Q2, etc and a command button that I want to run a query whose criteria is based on the selection in the Option group. The criteria should basically be: If Q1 selected then choose records where [DateClosed] => 01/04/08...