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: evansc
  • Content: Threads
  • Order by date
  1. evansc

    Parameter Prompt - Display Selection

    Two questions here: 1. In the report header, I am displaying the selections made from a dynamic parameter prompt. However, this only works in the case when a single option is selected. How can I display ALL the selections made by the user instead of just the first from the list? 2. I am...
  2. evansc

    Citrix 4.5 Crystal Reports XI parameter dialog issue

    We have installed the desktop version of Crystal Reports XI on our Citrix Server (version 4.5) and for the most part all works well. But when a parameter prompt is created and the dialog pops up, pressing "OK" and "CANCEL" turns the buttons blue, but nothing happens - we have to close the...
  3. evansc

    Crystal Report XI Over Citrix - Parameter Dialog fails

    We use XI (Release I) over Citrix. (I don't know the Citrix version at the moment but can get it if needed.). Almost everything works fine. But.... Say I create a report with dynamic parameters and run the report. The parameter dialog appropriately pops up and allows data to be input. But...
  4. evansc

    help combing multiple columns into one in sql

    I'm going crazy!! Someone who didn't really understand relational database theory (not like I'm an expert, but. . .) built a DB that is much more complicated than it needs to be. That person left and I got the job. I have to work with our IT people to hopefully redesign it completely (I would...
  5. evansc

    combining multiple records in one field

    Okay--this is kind of an odd request. . . I have a table that lists courts and the year they completed a project. So frequently a single court may have completed projects in multiple years. Obviously, the query lists them per record as follows: Court#1 2000 Court#1 2001 Court#1 2002 etc. I...
  6. evansc

    Calendar--showing items between start/end date

    I have a calendar report that seems to work fairly well. The main report is the calendar itself, with the dates/days, etc. To show the courses on each day I have inserted a subreport. It works fine, except that courses are inserted based on their start date, and sometimes we have two or...
  7. evansc

    Need to delete parameter in report--can't find it!

    I have a query that asks for the start date and end date in order to generate the results. I have a report built off of it. I changed the name of the fields so that there are no spaces. The query still runs correctly. However, when I try to open the report, I get asked for the start date, the...
  8. evansc

    VBA balking at spaces in code

    I'm running code in Access that is supposed to open a document in Word for a mail merge. The problem is, I get an error saying the path is not valid. Upon testing and researching this, I have discovered the problem is the spaces--it only reads this much of the path correctly...
  9. evansc

    form suddenly doesn't work

    I have a form that worked when I left work Tuesday. It is supposed to look at all the information in my "courses" table in descending order by year, ascending order by date, in edit mode. There is also a look-up list that allows me to select the date of the course and jump to that record. I...
  10. evansc

    Open word document from Access

    Is it possible to tell Access to not only open Word, but to open a specific document in Word? When I try that, I get told it's an invalid command. But I am able to open up Word.
  11. evansc

    Updating Yes/No checkbox behind the scenes

    I have a library DB. I track what items we have, whether or not they are on the shelves, and whose borrowing, etc. When I record that a video has been loaned out in one form, it accesses the table that tracks whether or not things are on the shelf and it unchecks accordingly. I'm working on...
  12. evansc

    syntax error on =IIf statement

    The following two syntaxes work perfectly: =IIf([End Date] Is Null,Format$([Start Date],"mmmm dd"", ""yyyy"),Format$([Start Date],"mmmm dd"", ""yyyy") & " to " & Format$([End Date],"mmmm dd"", ""yyyy")) =Trim("Thank you for agreeing to be a faculty member for the " & [Activity Title] & "...
  13. evansc

    mail merges/publishing to Word--problems with both

    I have a letter for faculty that we've always typed in Word based on a template. Well, now I have made a faculty DB that includes a lot of the information we would have to retype into that letter. So I want to make it easier with less typing. My first thought was to do a mail merge. But I would...
  14. evansc

    numbering items in a series

    I have a library DB. The Main table lists all the items by Number. A second table lists the number of copies I have of each item--linked by the number. A third table (currently) lists the items in the series for each Number. E.G., Item #320 has 4 parts. so the third table would have four records...
  15. evansc

    Turning off "Not in List" message box

    Is it possible to prevent the message box that says "Your item is not on the list. . . ?" As explanation, I have code running on the not in list eventin a combo box, which requires that in the table the properties be set to only accept items in the list. Part of the code is a message box...

Part and Inventory Search

Back
Top