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

Part and Inventory Search

Back
Top