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

  1. ecojohnson

    Populate random data into a table

    Hi gmmastros Thanks for the tip. Here's a star.
  2. ecojohnson

    Populate random data into a table

    Hi everyone. I am trying to create a table that has two columns, column1 and column2. I want a loop so that column1 starts with 1, and end with 2000 (counting up by 1). I want column2 to have a random number between 1 and 999. I have each of these working separately. For column1, I have...
  3. ecojohnson

    Adding a date range to filter results

    Great - thanks. I wanted to try to get this figured out before the weekend. I'll give it a shot. Thanks again.
  4. ecojohnson

    Adding a date range to filter results

    Thanks Skip. I was able to get close, but the macro returns an error: "Run-time error '9': subscript out of range". The code in question is: Selection.AutoFilter Field:=1, Criteria1:=">=" & Sheets("Sheet1").[A1], Operator:= _ xlAnd, Criteria2:="<=" & Sheets("Sheet1").[A2]
  5. ecojohnson

    Adding a date range to filter results

    Hi everyone. I am trying to create an excel report where I specify a date range on one of the worksheets. Cell A1 might be something like: 4/1/08, and cell A2 might be something like: 4/30/08. The remaining worksheets are set up so they each have various information on them, and this...
  6. ecojohnson

    'Save to file' not working

    Yup - thanks for the help. I appreciate it.
  7. ecojohnson

    Help with a date formula

    Thanks lbass It worked like a charm.
  8. ecojohnson

    'Save to file' not working

    Hi drtree Yes, that's one thing I wondered as well. However, I have full admin rights on both machines. That's why it's so strange. I'm scratching my head so much, I'm not going to have much left. My only other idea is to uninstall and reinstall. I really don't want to, but if that's what...
  9. ecojohnson

    Help with a date formula

    Argh. Sorry. My version of crystal is 9.2.2.634.
  10. ecojohnson

    Help with a date formula

    Hello. I manage a permit tracking database and use crystal reports. I am creating a report where I want to count the number of permits where the date the permit was issued was in the current year - without including permits from the current month. So, for example, I would run the report today...
  11. ecojohnson

    'Save to file' not working

    Hi everyone. I downloaded and installed a 120 day trial version of SQL Server. This included the entire suite (query analyzer, profiler, etc.) I was trying to run a trace using SQL Profiler, and then save this trace to a file, but ran into a problem. On the Trace Properties dialog, there...
  12. ecojohnson

    Inability to create a global header

    Hi everyone. Is it possible to create a global header? This would be where I could create multiple reports that all have the same header (rather than recreating it every time). I know this question must have come up before, but I don't see anything specific to this. On one of my searches...
  13. ecojohnson

    Query question

    Yup - that was it. It was the ORDER BY that I was missing which did the trick. Thanks so much!
  14. ecojohnson

    Query question

    Hi dinger2121 Thanks for the tips. However, this does not work. Using the TOP function will return the first person, not the person with the highest number of reviews. It seems I somehow need to use the MAX function, and I cannot do this without creating a new table from a query (similar to...
  15. ecojohnson

    Query question

    Hello. I have a problem that seems absolutely trivial, but I cannot solve it. I have a MS-Access database table (called REVIEWS) that has the following columns: NAME NUMBER Andrews 12 Green 4 Jones 8 Smith 15 Green 10 Jones 9 My goal is to write a query that returns the person with...
  16. ecojohnson

    Virus mail delivering to address different than in headers

    Thanks Dan. I appreciate it!
  17. ecojohnson

    Virus mail delivering to address different than in headers

    ymeq - how exactly do you track this in ESM?
  18. ecojohnson

    Distribution groups pounded by SPAM

    Ok - well thank you for your reply. I appreciated it very much.
  19. ecojohnson

    Distribution groups pounded by SPAM

    Wow, that's a bit of a relief (well, not really, but I guess it's nice to know since "misery loves company"). I agree with you, if I don't hear anything from the forums, a support call to Symantec may be in order. I'm going to install the new version of our spam blocker. I'm not sure if...
  20. ecojohnson

    Virus mail delivering to address different than in headers

    Hi Dan. I think I'm having a problem similar to this. However, my virus scans came back clean. Did your virus scans detect this virus, or did you locate this virus some other way?

Part and Inventory Search

Back
Top