Search results for query: *

Hello. I'm hoping someone has seen this issue, because it's stopped my work. When I go into the database expert for my report, and look at the link window, I see only the names of the table. None of the fields show up so I can't work with my links. Any advice?

Hello. I'm wondering if I use 2 multi value parameters in my report of the entries from both parameters will match up. Ie, the report uses the first entry of multi A and the first entry of multiB, then it processes the second entry of multiA along with the second entry of MultiB, etc. TIA Holly

Hello: We are in the process of upgrading to BI4 and Crystal 2016. We are having an issue with our existing reports - in the new environment, when reports are run on demand they run correctly. We are finding, however, that when we schedule reports some of the subreports are missing linking...

Hello. This is making my head hurt. Here's the scenario. I have a group of customers that stay in a certain area. Customer 1 might be there Jan 5-10. Customer 2 might stay Jan 1-7, customer 3 Jan 6-20 etc. For my report, I need to iterate through all the days of January (although the date...

Hello. In my organization we provide report access to our users through a BOE webpage. I'm having an issue with a particular report when particular runs are being stored in the report history. When the report is later viewed from the history, some of the data is being updated. End result is...

Hello: I have a report that I'm scheduling, and when I look at the report instance in the history it is auto updating data on the report. It is NOT updating the runtime printed on the report, so it's very misleading. Is there a way to stop the report instance in history from auto updating...

Yikes! I have a multiuser database - the data sits on a central server and the application is distributed to the desktop. I came to work yesterday and one of the tables, that used to hold almost 200,000 records, only has 199 records in it. No records prior to midday July 18th. The other...

Hello: Is it possible to open a form without preloading the data? I don't want the query to run until the user clicks on a search button. TIA Holly

Hello: I'm doing some testing in preparation for an upgrade to windows 8 (I know...I'm in the government, we don't do things quickly). I have a shared access database. Currently users run the front end of the database from their desktop, and the backend is location on a remote server...

Hello. I have written a program in Access to manage storage of paper files for a business group. They need to send a form to an external organization. This organization requires the info in a very specific format, and have provided an excel template they want us to use to remit the...

I have a weird problem. I've created a 2003 database, and have split it into a front end and a back end. The back end is on a network share, and the front end is distributed to users to run from their desktops. What's happening is each time someone uses the database, a copy of the front end...

I have a database running in a multi user environment. It is split with a front and a back end. It appears that when users are accessing the database, a copy of the front end is being created. These copies have the names Database1.mdb, Database2.mdb etc. My front end is a .mde file. Does...

Hello: I'm using a box in my report that it set to automattically close on a page break. When the box is enclosing a large text field I find that when the top of the box is drawn on the second page it butts right up against the top of the text. Is there any way I can format this to provide a...

Hi: I'm very new at crosstabs and can't quite figure out how to make this work. I want to count the number of times various text values turn up in my report, but I only want to count one per grouping. So for example, I have a report that is grouped by Incident ID. For each incident, I want...

Hello: Programming with Crystal 8. I have a report with a parameter that I would like to accept a maximum of 10 values. Is there some way to limit the entry of multple value parameters to 10? If not, how can I capture the extra values in the report and display them? The report itself will...

Hello: I have a form that is bound to a query, and it is opening extremely slowly. The first thing the form does is collect some info that is used to narrow the query. How can I set things up so the the form does not try to bring down data until the my search button is pressed (at which point...

I have written a program in 2003, and I am testing it in 2010 as some users will have 2003 and some will have 2010. I have a menu button that works in 2003, but not in 2010. The code behind it is: DoCmd.OpenForm "frmBoxRetrievalParameters", , , , acFormEdit I have another similar button that...

I am wondering if I can write a query that returns the contents of one field from a table, plus the value of one field on a form. I'm trying to make a union query for a combo box, where I want all the office names plus one new name that only exists in a field on the form. Possible? Thanks. Holly

Hello: I have this line in the update code of a form: Me.txtTrackingInfo = "Reactivated: " + Me.cboFacility + "/" + Me.txtTransferNumber + "/" + Me!frmBoxSub![Schedule Number] + "/" + Me!frmBoxSub!Location + "/" + Format(Now, "yyyy-mm-dd") + "/" + Environ("Username") + vbNewLine +...

I have a button on my form that I want to enter some text into a text box field when I press it. The data is stored in a memo field in the table. The code behind the button looks like this: Me.txtTrackingInfo = "Retrieved: " + Format(Now, "yyyy-mm-dd") + " " + Environ("Username") + vbNewLine...