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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cluser

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

Part and Inventory Search

Back
Top