Recent content by Zeppelin

  1. Zeppelin

    - TAB - COPY FROM FORM to FORM

    Access XP: I want to use the tab feature so I created a new form in the same DB. When I try to copy things from the first form to the new form the gui moves over but the action does not. I have to manually create the same action's on the new form. Is there some special way to copy these over...
  2. Zeppelin

    REPORT ERROR: Cant save changes

    Thanks, next time I will try that as of course its working today. Its really random when this happens.
  3. Zeppelin

    REPORT ERROR: Cant save changes

    This is weird. I have Access XP. I went to try and create a report today and as soon as I try to open a blank report it comes back and tells me "Microsoft Access can't save design changes or save to a new database object because another user has the file open. To save design changes or to...
  4. Zeppelin

    Add date range to report

    :D Close this thread and give that man a Cigar :D Thanks, that is exactly what I needed.
  5. Zeppelin

    Add date range to report

    The date range is on the querie and I run it from either the report section or a form so I need it to work directly from the report. The querie field: Field (Case_Completed) Criteria Between [Start Date] and [End Date]
  6. Zeppelin

    Add date range to report

    When I run my reports they kick off a date range selection I have in the queries. (between date a and b) I want to take that value I put in when prompted and have written to the header of my report so I dont have to keep manually changing the text on the report.
  7. Zeppelin

    Combo Box Lookup

    I have a table that lists Group Names that I use to feed a combo box. Group AAA Group AAB Group CCA Group CCB I wan to be able to list combinations of groups as a selection for the combo box like: Group AAA Group AAB Group CCA Group CCB Group AAA & CCA Group CCA & CCB Also I would like to...
  8. Zeppelin

    Should Contain versus Must Contain

    Yep Already done, thanks:D :D :D
  9. Zeppelin

    I need a BLANK return not a zero

    Mile-o-phile , After banging my head on the table I was seeing crosseyed.
  10. Zeppelin

    I need a BLANK return not a zero

    Well DUH that worked. <bangs head on table> Thanks Mike! :eek:
  11. Zeppelin

    Should Contain versus Must Contain

    I had my heat set on one query :(
  12. Zeppelin

    I need a BLANK return not a zero

    I want to return a blank value to feed a report. This statement works but when I run the querie of course it stops and asks what value I want for the empty [] so I have to press enter. There is no other output to this other then the report so I dont have to worry about further calculations...
  13. Zeppelin

    Should Contain versus Must Contain

    All the data I have available from a materialized view, single table. Better example: CASE 10 John Smith <dates> <other data> 11 Harry Jonsone <dates> <other data> 11 Suzi Quatro <dates> <other data> 12 Sherlock Holmes <dates> <other data> 13 Harry Jonsone <dates> <other...
  14. Zeppelin

    Export to Excel

    Are you using XP? Top Center of the screen while in the report edit mode allows you to export to Word or Excell. Try it instead of file/save as etc. So far I have not as of yet had any problems converting using that function.
  15. Zeppelin

    Should Contain versus Must Contain

    This is complicated to explain so please bear with me. I am pulling up data about service call cases using Access XP. A case may be assigned to one or more groups or one or more individuals. I want to pull up the data for one group or individual and see what other groups or individuals are...
Back
Top Bottom