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 strongm 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: *

  1. Travlnbard

    Counting records in Group Footer

    Thank you! It worked (almost) perfectly. I had to change @FooterVar to: whileprintingrecords; numbervar Counter; stringvar output:=""; numbervar Open; if remainder(Counter,2) = 0 then output:="C" else output:="O"; if output="O" then Open:=Open+1; Output It didn't like have the "Open:=Open+1;"...
  2. Travlnbard

    Setting default Word version

    What OS are you using? For Windows 2000... Go to Windows Explore and select Tools > Folder Options from the menu bar. Select the File Types tab and scroll through the list until you see the DOC file extension. Select it and choose the "Change" button below. Select the version of Word you...
  3. Travlnbard

    Counting records in Group Footer

    I am using Crystal 8.5, connecting to an Oracle database. Let me state from the beginning that there are probably better ways to get at the information that I need but this is what I have. I am willing to rewrite the report from scratch or fix what I have. Any help is very welcome. I have 3...
  4. Travlnbard

    Counting Rows Returned Trouble

    Thank you! That worked perfectly! I am going to try what lbass recommended too (just to see the difference and for my own knowledge). You both are great for getting back to me so quickly. Cathy (a.k.a. Travlnbard)
  5. Travlnbard

    Counting Rows Returned Trouble

    NEWBIE ALERT! I am using Crystal 8.5, connecting to an Oracle database using a tnsnames.ora file to connect. I am trying to create a report that will show what calls are open for each user. A single call can be opened and closed several times. So I need to determine the date of the last...
  6. Travlnbard

    Can't view highlighted text

    The document was not sent as RTF. But the 2 users involved were able to work around the problem and said to close the call. I am going to let it drop since the problem is on a PC that I do not have ready access to. Thanks for your help.
  7. Travlnbard

    Can't view highlighted text

    I have a user who created a Word document and highlighted text within that document. He sent it to another user (at a different location) via e-mail. The recipient cannot see the highlighting in the document. He tells me there is a checkmark under Tools, Options, View, Show, Highlight...
  8. Travlnbard

    Filtering data using multiple conditions

    It turns out that I have other issues with my code but I think that is going to work once I get the conditions in order. PHV, Why did you put the & before and after the variables? Sorry if this is a dumb question but I am very new to VBA. Thanks, Cathy
  9. Travlnbard

    Filtering data using multiple conditions

    I am new to coding in Access. I am trying to filter certain records to my main form. I think that it is simply my syntax that is wrong. Basically what I want is to filter all data for condition3 when condition1 or condition2 are true. Forms!Main.Filter = strCondition3 & (strCondition1 Or...
  10. Travlnbard

    Signature

    Thanks for the info. That did not fix the problem. However, I uninstalled GroupWise (and deleted the C:\Novell folder) and then reinstalled GroupWise and the problem was resolved. Simply uninstalling and reinstalling did not do the trick. Cathy
  11. Travlnbard

    Signature

    We just upgraded to GroupWise 6.5 and some users are having this issue and others do not. Did you ever get it resolved? Thanks, Cathy
  12. Travlnbard

    Urgent..!!! Converting Pdf document to Excel document

    Just out of curiosity, can you do a copy/paste into Word? Is there a specific reason to import it into Excel? I have found that PDFs copy very well into Word and then you can edit any data there. Of course the tables in Word would then convert easily into Excel. Just a thought, Cathy
  13. Travlnbard

    Urgent..!!! Converting Pdf document to Excel document

    Open the PDF in Adobe Acrobat Reader. At the top of the Adobe window you will see File | Edit | Document | View | etc. Go to View > Continuous. That will change the way you are seeing the file and will allow you to select all. Then it is a simple copy and paste, once. Cathy
  14. Travlnbard

    Method '~' of object _Application failed error in Access 2000

    Thanks for your help on this. What I ended up having to do was to Run Regsvr32.exe to Register the DAO360.dll file. Thanks again. (Next time I will remember to click the box that says e-mail notification.) Cathy
  15. Travlnbard

    Convert text YYYYMMDD to date mmddyyyy

    Tranman, Thanks so much for your assistance. It works great! (And since I have had to it for 18 date field this posting has been a great help.) Cathy PS Next time I will remember to mark the post for e-mail notification so that I know when someone replies (duh).
  16. Travlnbard

    Urgent..!!! Converting Pdf document to Excel document

    Try changing the view in Adobe from Single Page to Continuous. Hope it helps, Cathy
  17. Travlnbard

    "Create your Drawing Here" box in Word 2002...

    I don't know if it will remove it completely but it may reduce the time that it apears. Try this: On the Tools menu, click Options. Click the General tab. Clear the Automatically create drawing canvas when inserting AutoShapes check box. Hope it helps, Cathy
  18. Travlnbard

    Convert text YYYYMMDD to date mmddyyyy

    I have the exact same problem, but I do not know where to type the input field string referenced above. I would like to covert the fields permanently from text to date. Confused in NY (a.k.a Cathy)
  19. Travlnbard

    Method '~' of object _Application failed error in Access 2000

    Did you ever solve this problem? I am getting it in Access 2002. Thanks, Cathy
  20. Travlnbard

    File association for one file

    I tried this but Access XP seems to be smart enough to realize that it is more current than Access 2 and it will not allow me to choose Access 2 over it. I cannot associate anything to Access 2. However, I was able to create a shortcut to Access 2 and modify the shortcut target so that it...

Part and Inventory Search

Back
Top