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!

  • Congratulations Chris Miller 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: cluser
  • Order by date
  1. cluser

    convert db

    We have a filemaker pro database, we wold like to stop using it, what other database can be used as a replacement? I know MS Access may be a possibility, is there any tool to convert it or what is the best way to convert it? Thanks
  2. cluser

    objects in db all dispppeared

    Not sure, a couple of teachers in our school use it. We don't know much about the db, we are a new tech department, they ask for help we only know the size now is 140kb
  3. cluser

    objects in db all dispppeared

    We have some access database, when we open it, there is no tables any more, no any other object in the database any more. What happened, only thing we know we update the office to 2003, but those dbs are 2000. Any help please
  4. cluser

    0 is missing after export to text file

    Thank you very much
  5. cluser

    0 is missing after export to text file

    I have an Access table with a field named lunchpin, it is 5 digit number, but when I export to a text file, it turns to be 4 if it has a 0 in front of it, for example 02119, becomes 2119, how can I keep the number still 5 digits, without losing the leading or ending 0s. Thanks
  6. cluser

    iif in access query

    Great ideas, Thanks
  7. cluser

    iif in access query

    That's a good idea, but for the last parameter, meaning after all checked, else parent, how can I do it in the table, Thanks.
  8. cluser

    iif in access query

    I have a query similar like this to get a institutionRole field, but it is in progress sysntax, now I want to do same thing in Microsoft Access query,it seems I can only use iif, but I don't know how to do it, it has multiple arguments, IF (ENT = "074") THEN ("MHSparent") ELSE ((IF (ENT =...
  9. cluser

    export to pdf

    I have a crystal report, I want to export it as pdf, but it has 9000 pages, when exporting, it runs slow, I don't know how long it will take to export all the records. Is there any to export faster? Thanks
  10. cluser

    there is space between a word when displayed in crystal report

    Hi, I created a report,but when i preview the report, the words displayed in the field some times has space between a word, What is the reason of that, how to fix it? For example, I have a username field like: WOOLLGRE000, but when it displays it is something like WO OLLGRE000, actually half...
  11. cluser

    send crystal report

    I'm new to Crystal report, if we have created a report, and I'll send to someone to print, what is usually the best format and the files to send them? I have an Access database as data source, sometimes I also use Excel. Thanks
  12. cluser

    section goes to another page

    Sorry,sorry, I did find in one of my groups there I checked to keep groups together, I previously didn't find it is because I thought there is only one group I need to check, and keep groups-together means to keep all groups together, so didn't check one by one. Thanks a lot for everybody for...
  13. cluser

    section goes to another page

    Thank you, but I didn't have it checked. The problem is now only the first page is shown correctly, but the other odd pages only have group header1 there, then all other sections go to next pages, Thanks for any more ideas
  14. cluser

    section goes to another page

    Hi, I have report header footer, page header footer, four groups header footer, their section property checked are: Report header: suppress, keep together Page header: suppress when at even page, Group header1: keep together, Group header2, keep together Group header3: keep together Group...
  15. cluser

    crystal report page adjust

    Sorry I have another thread about this, please see the thread name: section goes to another page. I've already tried your suggestion, it does't work either. And I also had the keep together checked on the group section.
  16. cluser

    section goes to another page

    Thank you, I don't have the "new page before" checked in the detail section,plus it shows correctly on the first page, but not on the other odd pages. The first page has page header, group header1 to group header4, group footer 1 to group footer 4, page footer. Thanks for any ideas and...
  17. cluser

    section goes to another page

    Thank you, I checked, I didn't keep group together. This is a letter report with two pages. I'm very confused why the first page is OK, and all other odd page doesn't display correctly, only has header left, all other sections goes to the next page. Thanks for any ideas
  18. cluser

    section goes to another page

    Thanks, but it's still like that. I have four group headers and footers, doed it matter? I have the first two pages displayed correctly. For all the other pages--which is about 20 records, the first page of the report only shows the group header1, page header and footer, nothing else shows...
  19. cluser

    crystal report page adjust

    Sorry that I should put these two messages together: I'm new to crystal report, I always have trouble to adjust the sections on pages. Now I just created a report with group headers and foot and the report will be two pages. The footer section sometimes goes to next page, sometimes stay in...

Part and Inventory Search

Back
Top