Search results for query: *

if date = "" then date = '' end if

Here try this statement below copy and paste it and it will work.... But only if accunumber is not a string made by concatenating pyy, pmm and pui.... "Select accnumber from tbl Where accnumber like '%" pyy & pmm & "%'" & "and initials =...

you need a conditional module to check for the existence of certain search criteria and then build the SQL statement to run it based on that... example ==>any word or any phrase: WHERE strSearchCriteria LIKE '%strAny_Word_or_Phrase%' ==>exact word or phrase: WHERE strSearchCriteria =...

If you really want to store it in Access you use the OLE Object data type

post your Dsn-less connection string

You mean how do you set the variable 'Desc' equal to the DB field 'Description'? Dim Desc Desc = objRS("Description")

You can also try this: your_variable = Trim(Replace(your_variable,chr(39),"’")) I'm assuming you are displaying the data in a browser once you've pulled it out from the database. By the way if it doesn't show up right in this message board the value that you replace the apostrophy...

Are you sure that your SMPT virtual server is running in IIS?

add a submit button to the form that when clicked submits the form to itself. use the info typed by the user to run a SELECT statement against the database that will grab the matching info if any from the database and then run a loop to populate the drop down with the data you retrieve. example...

Why don't you try and run a select statement against the database and grab the info you just added to it, in the page the user is redirected to. OR You can store the values the customer entered that were sent to the database in variables and then use those variables to build a querystring you...

Here is a suggestion. <SELECT name=&quot;location&quot;> <OPTION>-Select a Location-</OPTION> <% Do While Not RSEmps.EOF Response.Write &quot;<OPTION value=&quot; & RSEmps(&quot;intLocationID&quot;) & &quot;>&quot; Response.Write RSEmps(&quot;location&quot;) Response.Write...

I'm not sure but I didn't see anywhere in your code where you actually opened the recordset rs1.

Correction to the error I made :) I would like to know how to populate a table with the contents of a 2 field table in SQL. The way that I thought would work isn't.... Anyway here is the code I wrote to do it.... <% Do While Not objRS.EOF Response.Write &quot;<TR>&quot; & VBCRLF & &quot;<TD...

I would like to know how to populate a table with the contents of a 2 field table in SQL. The way that I thought would work isn't.... Anyway here is the code I wrote to do it.... <% Do While Not objRS.EOF Response.Write &quot;<TR>&quot; & VBCRLF & &quot;<TD width=% align=center valign=middle...