Recent content by rjkealey

Hey all I am trying to add a asp page where user enters 2 zipcodes and it returns total mileage kinda like google but stay on my page and list total miles any ideas where I can get an access db to do this Thanks in advance

Are there any free ones that is a purchase one I just need to see it in action that you have to buy before you see it in action

Hey All, Wondering if there is a good tutorial and example code to play with trying to learn how to sned a form via email after it is filled out by client Any help would be greatly appreciated. I am a newbie and part timer at this so I would need a good simple example RJKealey

Hey All, I am trying to get a value(fldSalesperson)from a access db and see how many deals they have per month I need help or a tutorial on incrementing 2 vars after comparing to (fldSalesperson) IE: varSP varNum varDeals if fldSalesperson<>varSP(varNum) then varNum++ varSP=""...

I HAVE STILL NOT BEEN ABLE TO GET THE CORRECT INFO FROM DB ARE THERE ANY TUTORIALS I CAN RUN THROUGH? WHEN I DO THE ABOVE IT DOES NOT COMPARE DATES CORRECTLY ANY HELP OR IDEAS WILL BE GREATLY APPRECIATED RJKEALEY

STILL WORKING THIS MESS OUT I SAW FLDYEAR WAS EMPTY FIXED THAT THOUGH FLDDEED IN DB IS " 11/25/04 " I HAVE A PAGE WITH 2 BUTTONS 2004 AND 2005 I WANT USER TO PRESS 2004 AND IT WILL GO TO LIST OF ALL 12 MONTHS USER SELECTS MONTH AND SEARCHES DB BY FLDdEED AND DB WRITE ONLY RECORDS WITH MONTH...

SELECT * from tblCharlotte WHERE Year(fldDeed)=' ' AND Month(fldDeed)='September' order by fldDeed

WELL I DO NOT GET ERROR ANY MORE BUT IT IS NOT COMPARING DATE IN DB I PUT RESPONSE.WRITE FLDYEAR AND FLDDATE AND IT SHOWS CORRECTLY BUT IT WILL NOT COMPARE TO DB AND SHOW RECORDS THANKS DNG RJKEALEY

KEEP GETTING ERROR Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'Year(fldDeed)=' 2004 AND Month(fldDeed)='12' order by fldDeed'. /currentMonthPropListTable.asp, line 60 THANKS AGAIN FOR YOUR HELP RJKEALEY

I HAVE BEEN TRYING THAT BUT CAN NOT GET IT TO WORK HERE IS MY SQL STATEMENT sql="SELECT * from tblCharlotte WHERE fldDeed like '%" & fldYear & " AND " & fldMonth & "%' order by fldDeed" RJK

I HAVE ACCESS DB WITH FIELD OF DATE ADDED (fldDate) I AM TRYING TO COMPARE DATE ENTERED BY USER(FLDMONTH & FLDYEAR) WITH DATE IN (FLDDATE)ACCESS DB AND RESPONSE.WRITE ALL RECORDS MATCHING (FLDMONTH AND FLDYEAR). I AM HAVING TROUBLE GETTING IT TO COMPARE DATE BY MONTH AND YEAR THEN WRITE THOSE...

HEY ALL I AM TRYING TO CONVERT A TEXT FEILD IN ACCESS WHICH HOLDS A DATE SUCH AS 12/21/05 TO A DATE FEILD ON MY ASP PAGE SO I CAN TRACK ORDERS PER MONTH SUCH AS SHOW ALL RECORDS WHICH HAVE 12/21/05 ANY HELP IS GREATLY APPRECIATED RJKEALEY

Thanks all I really appreciate the quick response and help it worked great thanks again RJKealey

I am trying to compare a field in the db before it will allow a new record to be added I need to check fldParcelId ( from form) and compare it to fldParcelId(db) Can I put in my SQL to compare first? RS.Open "Select * From tblCharlotte", MyConn, adOpenDynamic, adLockPessimistic, adCMDText...

its running it will i restarted IIs and no go rjk