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

    Dmax or Stored Procedure?

    Thanks Paul, still no luck!!! I tried the new code and still get the error... The above I have provided is an example of what I'm trying to do. I'm actually using different fields and tables but the context is the same, I even renamed my second table from DWR_Sequence to DWRSequence in case it...
  2. lukeargent

    Dmax or Stored Procedure?

    Hi Paul, Sorry my post must of come across wrong - it's already in a VBA module on the "ON Click" event of the button. It's a private sub - but are you suggesting to use a private function instead? Thanks Luke
  3. lukeargent

    Dmax or Stored Procedure?

    I have a problem when using ADP connected to SQL Server 2000 that works fine when using a plain and simple MDB file. I have a field that I want to increment based on the last value in the table but matching the linking field between the 2 tables. I.E. a DVD could have 10 reviews of which it...

Part and Inventory Search

Back
Top