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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by timbert62

  1. timbert62

    Error 3305 (Invalid Connection String) when connecting to Exhange

    howdy when trying to create a linked table in Access97 that is linked to a public folder on the Exchange Server, I keep getting "Error 3305 - Invalid connection string in pass-through query". I copied the code from an MSDN Library article. I have used the Microsfot Exchange and...
  2. timbert62

    too few parameters error '3061'

    hoooo-ray ! after i finally got the code right (thanks to the suggestion/advise on how to best debug sql code), i determined that the problem was no longer with the code of the function but with how i was using the function in a Access query. originally, i was using the FUNCTION defined by my...
  3. timbert62

    too few parameters error '3061'

    OK, now i am really confused i now have it to the point that the resultant sql statement = sql = SELECT [Age] FROM [rpt-qry Property Settlement Stats] WHERE [PROP_ADD2]="CHAPLINWOODS" ORDER BY [Age] which is what i thought i wanted. i even copied that statement & pasted it into...
  4. timbert62

    too few parameters error '3061'

    thanks for the tips i've incorporated both suggestions & end up with the debug print = sql = SELECT [Age] FROM [rpt-qry Property Settlement Stats] WHERE ([PROP_ADD2] = 'CHAPLINWOODS') ORDER BY [Age] it seems like i'd want " " around the CHAPLINWOODS, but i can't quite get it to...
  5. timbert62

    too few parameters error '3061'

    i have been staring at & fiddling with this for hours on end & can not figure out what is wrong i have read related tips on this forum, all of which make believe that is has something to do with how my quotes are ordered & the data types (especially in the WHERE clause), but i do not know...
  6. timbert62

    calculating a MEDIAN value -- ERROR message

    any help anyone can give me would be splendid & MUCH appreciated i am trying to get a bit of code for calculating MEDIAN values to work i found the basic code on the web & modified slightly THANKS TO SOMEONE ON THIS FORUM, i was able to get it to work when grouping by YEAR, but when i...
  7. timbert62

    SQL statement in VBA code

    that WORKED !! i was sure i had tried that (but obviously, i hadn't) thanks tim
  8. timbert62

    SQL statement in VBA code

    I am very new to VBA, so please bear with me as I try to describe what is probably a VERY simple situation. I need to calculate the MEDIAN value of the [AGE] field in each year, from a table that has records with AGE & YEAR for many different years. I found a VBA function...
See more

Part and Inventory Search

Back
Top