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

    How to base one report on mulitpule queries.

    Hi want to create one crystal report that returns the values for several items. I opened up a new report and the only thing I added was a command. In the command I added the following quieries: select Count (*)As CallsIn from heat.calllog where...
  2. Janet95

    Crystal 10 Report Help????

    Hi, I'm extremly rusty on Crystal and I need to create a report for our VP ASAP so I'm in a panic and not having any luck. I have a table called Calllog The fields I need in the report are CallLog.ClosedDate and CallLog.RecvdDate. All I need is a count of records with a CallLog.ClosedDate...
  3. Janet95

    Missing Sub Forms???

    Hi, I ran into this problem a long time ago, however I cannot remmeber the solution [sad] I have a form with mulitpule pages with subforms in each page. For some reason all of a sudden some of the subforms dissappear. If a record doesn't exist or if I go to add a new record the subform...
  4. Janet95

    Crystal 9.0 CrossTab format Question

    Hi, I'm just now begining to work with Crystal Reports and I have a crosstab report that works great, but the format is not. I can seem to put my crosstab anywhere execpt for the report header and footer so this throughs of my page numbering. How can I get my crosstab to be in the Details...
  5. Janet95

    trim / out

    Hi I have a small task I've been scratching my head over and thought it best to start from scratch. I have a table with a date field, data type is date. The problem is I want to sort it by month, however if I sort by asc or desc is does it by year. I created a new table that fills in a date...
  6. Janet95

    Record Set - how to check all records

    Hi, I'm having a problem with some code (record set) I wrote. I want to check for members of a group to see if they have been absent for 30, 60 and 90 consecutive meetings (not calendar days). Basically a person will have a record in the db for everyday a meeting took place. Their record...
  7. Janet95

    Problem Creating MDE

    Hi Everyone, I'm having a problem creating an MDE. My database is 11mb in size and in 2002-2003 format. It has 3 modules, 50 tables, 450 queries, 35 forms and 33 reports / subreports. It is not a replica databas. I have went to a form and opened the code and performed a compile project...
  8. Janet95

    Can't Create and MDE File

    Hi, I'm having trouble creating an MDE version of an ACCESS 2000 database. I tried converting it to 2002 with no luck and I also opened up a form in design view, opened the view code mode and debugged / compiled it with no luck. Do I have to do this with every form and is this the right step...
  9. Janet95

    subforms missing when adding new record

    Hi, I have a form with multiple tabs. Each tab page has a sub form within it. Every time I go to add a record the sub forms are missing. This worked at one point. I checked the Sub form Field Linder properties, which link the child and master fields between the form and they seem ok. Any...
  10. Janet95

    Best way to learn how to write complex queries?

    You know the saying give a man a fish and he’ll eat for the day, but teach a man how to fish and he’ll eat for a life time. I often see many talented people responding, with relative ease, to questions about queries that I think are very complex. I’ve purchased SQL for Dummies and Access 2000...
  11. Janet95

    Open report command button

    Hi, I posted this question in the reports forum,but I think it belongs here. I have a subform that has a command button that is used to open and run a report, only for the specific record shown. The problem is that when I press the command button the report shows behind the form so I can't see...
  12. Janet95

    subform and reports

    Hi, I have a subform that has a command button that is used to open and run a report, only for the specific record shown. The problem is that when I press the command button the report shows behind the form so I can't see it. I've tried to make the form/subform invisiable but it doesn't work...

Part and Inventory Search

Back
Top