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

    Update Query that clears fields that are not in the new data

    UPDATE [Linked Portfolio Report] INNER JOIN Hierarchy ON [Linked Portfolio Report].CC = Hierarchy.Businessunitid SET Hierarchy.[No notes] = [linked portfolio report].[# notes], Hierarchy.Balance = [linked portfolio report].[lgr balance]; My original post left out that this I am running Access...
  2. Renasant

    Update Query that clears fields that are not in the new data

    I have an Microsoft Access update query that I run each month with no real issues. We download data from our mainframe (we are a bank) to excel. The excel worksheets are then used as linked tables to update parts of the access database. The only problem is when something becomes blank...
  3. Renasant

    only 255 characters showing in CR XI for Access Memo field

    Bug Found in CR under "Report Options" uncheck "select distint records" and the whole memo field will display. No other changes made just unchecked this totally unrelated option for the report and CR displays the entire memo field.
  4. Renasant

    only 255 characters showing in CR XI for Access Memo field

    I have several MEMO fields in my access database that are being truncated at 255 characters in Crystal reports. These are very long fields with data typed by users. We use them as reports to managment to show progress in problem loan resolution. Field Explorer shows them as Memo fields. Can...
  5. Renasant

    Always Load Form with the same filter applied

    Thanks Duane. That makes sense. I got the change in place and it works!
  6. Renasant

    Always Load Form with the same filter applied

    I do not have the skills to do the sequel. I need to know how to do this in Access 2007.
  7. Renasant

    Always Load Form with the same filter applied

    I need a form to always open with a certain filter applied rather than the last filter applied. I wrote the filter in advanced filter/sort and saved it as a query. I have tried two methods to define the query as my filter. I used the Form Property Sheet and tried the <Advanced Filter/sort>...
  8. Renasant

    Conditionally Format an entire row in Excel 2007

    Thanks Skip. Excel calculates left to right across the sheet, so the mixed reference is necessary. I am reading up on Relative, mixed and absolute cell references.
  9. Renasant

    Conditionally Format an entire row in Excel 2007

    Thanks Skip. I tried that even before your post after seeing the issue earlier today. It works, but why? Forum Managers: The other conditional formating question from today did not show up on the search for "find a forum". Sorry for an almost duplicate post.
  10. Renasant

    Conditionally Format an entire row in Excel 2007

    Changing the formula to: =$C6:$C44="city name" (with the relative refernce on the column only) worked. The conditionally format now affects the entire row. But the question for the FAQ is WHY?
  11. Renasant

    Conditionally Format an entire row in Excel 2007

    I am trying to conditionally format an entire row in Excel 2007. This used to be easy in 2003, but I cannot make it work in 2007. I am trying to change the color of an entire row based on the value of a cell in that row. My formatting formula looks like this: Formula: =C6:C44="city name”...
  12. Renasant

    Report with multiple headers, footers and back pages

    Do you ever have the report run to show company a and b and c all in one report? Is so, would a group by company work to show them. then all of the logos could be put in the single group header and footer on top on one another and conditionally suppressed unless it matched the goupname you...
  13. Renasant

    NUMBER formatting with more than 10-decimals

    The field would "show" as a number in .csv and excel. You could sort or search the text field in csv or excel. You could not use it for calculations in Excel unless the user converted it, which seems plausible if they had the expertise to export the report from crystal. Anyway, wouldn't...
  14. Renasant

    Delete Query cannot delete and error 2950

    CORRECTION: I ran the table analyzer and performance analyzer last month. The delete query now points to a new query that access created for me to represent my old table. My append and update queries both point to this new query rather than the underlying table that access named table1...
  15. Renasant

    Cannot Delete from a Table

    CORRECTION: I ran the table analyzer and performance analyzer last month. The delete query now points to a new query that access created for me to represent my old table. My append and update queries both point to this new query rather than the underlying table that access named table1...
  16. Renasant

    NUMBER formatting with more than 10-decimals

    Could you convert it to a text string for display? Maybe a formula that declares it as a string rather than a number. Just don't use the tex string in any calculations for the report.
  17. Renasant

    Office 2007 messages moved by rule marked as read

    IF Blue Horizon's fix does not work, then edit the rule and be sure that "mark it as read" is NOT part of the rule. That is an option in the rules wizard.
  18. Renasant

    Cannot Delete from a Table

    I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not...
  19. Renasant

    Delete Query cannot delete and error 2950

    I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not...

Part and Inventory Search

Back
Top