Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hpl2001
  • Content: Threads
  • Order by date
  1. hpl2001

    Fields missing in link window

    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?
  2. hpl2001

    Multiple multi value parameters

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

    BI4/Crystal 2016 upgrade issue with scheduled reports

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

    Calculating totals across a date range

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

    Report stored in history getting updated

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

    Report in History auto updating

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

    Lost a ton of records from one table

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

    Open form without preloading data

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

    Shared Database doesn't open under Windows 8

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

    Access/Excel data sharing advice needed

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

    Duplicating Code

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

    Front end making copies of itself

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

    Box closes too close to the text

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

    Crosstab - counting once per group

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

    Limiting 'Allow Multiple Parameters'

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

    Performace Issue with bound form

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

    DoCmd.OpenForm - 2003 vs 2010

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

    I am wondering if I can write a que

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

    Dealing with a possible Null in a text string

    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 +...
  20. hpl2001

    Button not working as expected

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

Part and Inventory Search

Back
Top