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!

Register Log in
  • Congratulations derfloh 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: cp950
  • Order by date
  1. cp950

    HOW TO : Show NULLs in Table View

    I know SQL_Server does it. Is there an MS_Access option that'll show NULL fields as something other than blank? Zero-Length would look like " " Space would look like " " NULL would look something like "<<null>>". I have a DB with poor NULL handling and it would be a huge...
  2. cp950

    Row Visability based on group

    You could do it in the SQL source... SELECT * FROM [Comments] CCC WHERE [Date] = (SELECT Max([Date] FROM [Comments] AAA WHERE AAA.Date = CCC.Date
  3. cp950

    Excel export includes old subreport format?

    I am using SSRS and Visual Studio 2012. I had to completely rebuild a subreport (major changes in data content, etc.) but it still uses the same parameters (from/to dates). I created it, verified it, exported it to EXCEL -- it was 100%. I added it as a subreport to my main report. When I...
  4. cp950

    Excel - Wrap Text

    SUCCESS!!! I had been getting a row of ######## as wide as the cell (in some rows, not all!), had it set for autofit and text-wrap, but kept getting only that one row of #########. Some of my comments are a dozen lines long and some change daily, so manually inserting alt-enters just cannot...
  5. cp950

    error in simple extract of Oracle to SQL table

    Never mind -- moron (me) left a comma of line #06
  6. cp950

    error in simple extract of Oracle to SQL table

    I am writing a DTS package that'll acquire data from an Oracle database to make SQL updates. The first step is a data-transformation into an existing SQL table. I used a SQL statement as the source (one source table with 8 left joins). My problem: no matter how I write it, I get an error...
  7. cp950

    Insert to SQL table -- numbers are changing

    I did not even know how to search for this, though I did try... I am using Access_2000 to collect user data. When done, I insert it into a SQL_2000 table. Access PRICE field is Currency, and the SQL field PRICE is Float. I am moving the data with a simple append query. The kicker...
  8. cp950

    Groups appear out-of-sequence

    Found it on the 10th search of Seagate's support system! 1) Delete the group 2) Re-Insert the group It now sorts correctly. I don't get the logic of it, but it DID work...
  9. cp950

    Groups appear out-of-sequence

    Turk: No, its a SQL datetime. I figured if it was a text I'd see the date in month and date order, but nope!. I can determine NO form of order -- not even DAY (Fri, Mon, SAt, Sun...)
  10. cp950

    Groups appear out-of-sequence

    Ms. Vampire : (like the ID! [wink] ) I checked, and they are set that way. I also checked keep-together and repeat-on-new-page. No difference. Spooky, no?
  11. cp950

    Groups appear out-of-sequence

    I created a new report (CRW version 7.1) that takes in a single record-set (MS SQL view, unsorted) and prints a summary (summarising transactions by COUNTRY within DATE). I set the details up for the records and suppressed it. The Date and the Country fields ARE in the suppressed detail. I...
  12. cp950

    &quot;TOP n&quot; -- setting &quot;n&quot; by query/form

    OK, thank you VERY much! And if I needed to use this data in subsequent queries, I could make this query a Make-Table type, and off I go. Right?
  13. cp950

    &quot;TOP n&quot; -- setting &quot;n&quot; by query/form

    I need to pull the &quot;TOP n&quot; of a table, based on simple criteria (like Top 3 Salarys of employees, where Department = X). I know I can set &quot;n&quot; easily in design-mode, but this I need to run by form by a user who won't know Access. The &quot;n&quot; will always change (Top 5...
  14. cp950

    Autonums -- duplicates and out-of-seq hits

    OK, I am back. I made a number of tests, and did a bit of research. I have ruled out the import, as the days this last one appeared the imports-preson was in Omaha. But the fact still sticks in my craw that the last chinese-character record I got had a whacked Autonum. ((to clarify, the...
  15. cp950

    Autonums -- duplicates and out-of-seq hits

    JIM: Thanks for helping! Yes, the &quot;invoice number&quot; is used throughout the company's processes. Trying to change it to something else would be unacceptable to them, and I fear quite foolhardy. I fully plan on checking for unacceptable values (nulls, dups, etc.) and making the thing...
  16. cp950

    Autonums -- duplicates and out-of-seq hits

    WildHare: Thanks for responding! Unfortunately, this field is used as their Invoice#. So obviously I cannot delete it. Would reforming it as LONG and defaulting it to a &quot;DMax+1&quot; do the trick? There are NO defined relationships, either in the data half or the forms half. How did...
  17. cp950

    Autonums -- duplicates and out-of-seq hits

    I inherited an Access97 datatbase, where the primary transaction table has large records. its ID# is a Long-Integer AUTONUM. It is NOT a key or an index. Occasionally, a record gets created where it has a dupliate ID#, somewhere in the middle, not the last-number. Almost always, the rest of...
  18. cp950

    autonumber assigning duplicate values ?

    I am getting the same problem, now. It happens occasionally and erratically. Invariably, there are mostly oriental and non-sensical characters in these duplicate records. Did anyone effectively resolve/prevent this?
  19. cp950

    Preview same report several times

    I need to simultaneously preview the same report several times, each with a different filter. Then the user shall close or print the open report(s) they desire. I created a button that does the series of &quot;DoCmd.OpenReport&quot; commands, each with a different filter. The code compiles...

Part and Inventory Search

Back
Top