Search results for query: *

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

Hey all I used to be able to view asp pages I was working on by saving them and open via IE but now I can not it shows the background only. I can upload to web and view fine but on localhost no go this happens on desktop and laptop anyone know why? Thanks in advance RJK

FATTYFATPANTS Thank for your help I really appreciate it and I got it working thanks to you here is what the outcome link looks like ************************************************** <td>Property Appraisar Sheet :</td><td><a target="new"...

Hi All I am havig a problem with a fld from my db that i want to take dashes out then convert to hyperlink EX. fldParcelId from db = 0095262-228970-6 I need to take both dashes out to get this value 00952622289706 Which I then can stick on the end of a hyperlink EX...

sorry here is what I was trying to do ********************************** <% If fldTitle="yes" Then fldTitleBox.value=checked Else fldTitleBox.value="" End If %> <td><input type="checkbox" name="fldTitleBox"></td> ***********************************

Hey all, I am trying to pull the value of a field from an access db and if true I need to have chkbox value to checked. I just need one value and one checkbox. I have done research and can not find value from db to chkbox only opposite I would appreciate any help Thk RJKealey