Search results for query: *

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

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

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. :)

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

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

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.

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

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?

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

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

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

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!

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!

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