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

    Counting Days in Access - How????

    Just a note: While Tek-Tips is great, there are some fantastic books out there for beginning Access developers. I'd recommend: Access Database Design & Programming by Steven Roman- a very analytical look at database design and how Access handles these concepts. Very high-level, well suited for...
  2. wishlish

    Counting Days in Access - How????

    Good luck, Reg. And the advice from Greg is right on. Speaking as someone who just finished his first significant Access project, it takes time to learn this stuff right. I've bought so many books off of Half.com that my desk is wall-to-wall manuals! You just have to sit down and let it all stew...
  3. wishlish

    Access 97 Purchasing?

    Any idea if this works if I purchased Access 2000 myself? Does the "boxed" EULA give you rights to A97? If so, any idea how I can get it? That would really be cool. :)
  4. wishlish

    Access 97 Purchasing?

    Hmmm...still a bit expensive, though I thank you very much. I guess I'll have to keep looking. Thanks!
  5. wishlish

    Counting Days in Access - How????

    I think you need a comma there. DateDiff("d" InvoiceDate, PaymentDate) should be DateDiff("d", InvoiceDate, PaymentDate) Try that.
  6. wishlish

    Access 97 Purchasing?

    I tried your suggestion, and while it SHOULD work, I had a situation that didn't work, so I'm looking to purchase A97. Thanks, though.
  7. wishlish

    Counting Days in Access - How????

    I think that code is better than using Excel. Thanks, Greg!
  8. wishlish

    Counting Days in Access - How????

    I have a followup on this- is there a way to count the number of BUSINESS days between two dates? I know in Excel you can use the Networkdays function- is there a way of duplicating that function in Access?
  9. wishlish

    Access 97 Purchasing?

    I have a copy of Access 2000 at home, but found that using it to build a database for work (where Access 97 is the only Access available- long story) was a bit awkward. I even had a situation where I could only use A97 for a certain task. So I'm looking to purchase an inexpensive, LEGAL (no...
  10. wishlish

    Module to create multiple reports crash

    I fixed the problem, and I *think* I found the problem. I had started this database in Access 97, and converted it to 2000 to work on at home (I have 97 at work). That's where it crashed. When I converted it back to 97, and ran it at work, it ran fine. I did a search on the forums, and I found...
  11. wishlish

    Module to create multiple reports crash

    I have a Do Until Loop that creates a filter critera, DoCmd.OpenReport's the report with the criteria, SendObject's the report two times (in different formats, so different customers don't have to use Snapshot while others can), closes the report without saving, and then loops back, getting the...
  12. wishlish

    Automating the e-mailing of a report based on a parameter query

    Ok, got this to work, but now I have a new problem. When I loop this to do this a second time, Access crashes. Why? I'm going to put this problem in a different topic. Thanks, Ken!
  13. wishlish

    Automating the e-mailing of a report based on a parameter query

    Would it be easier to dump the parameter from the query and filter this report in the doCmd.OpenReport command? If so, how do I write the filter code? Thanks, Ken!
  14. wishlish

    Automating the e-mailing of a report based on a parameter query

    I am going to be sending out report cards to our vendors. The report cards will be generated using Access 97. I have a table of the vendor's ID and e-maill address. I created a query off of a table of all our records that selects the records that match the ID #, then created a report based off...

Part and Inventory Search

Back
Top