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 TouchToneTommy 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
  • Content: Threads
  • 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

    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
  3. 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
  4. 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 =...
  5. 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
  6. 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...
  7. 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
  8. 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...
  9. cluser

    section goes to another page

    I'm new to crystal report, I always have trouble to adjust the section section. 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 the same page. And sometimes the third page is only...
  10. cluser

    section or image only show on odd page

    I want the logo only appears at the odd page but not on the even page, how can I write the code, also I have a image in page footer, needs the same thing. Thanks
  11. cluser

    order of section

    In my report, I notice in design view, the section are like these: Report header Page header group header1 detail group footer1 report footer page footer should page footer be at the top of report footer, is that I accidently moved it, I cannot move back, but in section expert,it is in right...
  12. cluser

    page footer

    I have a page footer, I only want its content shown on odd page, but not even page, how can I do that? Thanks a lot
  13. cluser

    two pages report

    My report has two pages,I now make them using the same data source, in each page there are texts, also have detail section that shows the fields. I created the first page, but don't how to create the second page, for the page also has header and detail section. How can I implement this? Thanks
  14. cluser

    conditional field

    Hello, I would like to have a field display in my report. called UserID, If the students are grade k, 1, 2, I want it to be lunchcode, if they are grade 3-12, I want it to be students ID. it seems iif can only has two cases. How can I do this, what code and where should I add ? Thanks
  15. cluser

    report with different data source

    I would create a letter report that with two pages, the two pages don't have the same data source -query. Is there any way that I can use two data sources in one report, or merge report. Thanks
  16. cluser

    how to display in detail section

    Hello, I would create a report for students demographic information. The report will be used as a letter, and send to parents. Like: Dear Parents: Here are your 3 children info: Student1 name, student2 name, student3 name. But in my query, I have one field called studentname,then I group...
  17. cluser

    Mail merge

    We would like send letters to parents of students. We have an excel sheet of all students information, including address. How can I use mail merge to send mail for each family and including all their kids information in one letter? I think may be group address, but don't know how to do it...
  18. cluser

    Lock pages

    I created a report for students progress. I want to control the report has only two pages for each student, but there is always the third page comes out and blank, how can I lock the report only have two pages? Thanks

Part and Inventory Search

Back
Top