Search results for query: *

No they are on different servers. The one that is giving problems is the one located on the remote server. Actually on the local server there is a link table which resides on the remote server having permission problems. How would I set permissions for that other table. It resides on a machine...

Well its not someone opening it in Design mode or any mode, because I closed it on 012 and then tried it and got the same result.

Hi all, I bet this problem I am having has been solved many times before. I even looked at some other threads, but got too many results. Ok here is my problem: I finished my ASP page and I get connect fine to most of my tables. However the 97 Access database has a table linked to it from...

I have two pieces of code. Both are used to populate a drop down list box dynamically. However I would like to integrate them into one. First part of code: There are two dropdown boxes which are linked to each other. That means if I select a value from the first then the second one populates...

I am trying to pass a date value with a string onto the next page with ASP. However I cannot get the date format to work properly. I recall that one needs to include # signs in it. Can someone please take a look at my code below and help me out. If Len(trim(frmSearch.StartDate.Value)) > 0...

Hi guys, I have two parts to implement in my ASP. First of all I have a search page where there are 10 text boxes. In a nutshell I want to enable to user to search from any one of these text fields. So its a OR clause in the SQL part. The more fields the user fills in, the more accurate the...

I am having trouble with SQL when I want to check two text boxes. It gives me a syntax error. Below is the code that I have. (All in one line) oRS.open "SELECT * FROM tbldata WHERE DealNum=" & Request.Form("Deal") AND WHERE Sequence=" &...

It still giving me a syntax error. Below is the error its giving me: Syntax error SQLtxt = &quot;SELECT * FROM tbldata WHERE DateFrom < # &quot; & Request.Form(&quot;Date&quot;) & &quot;#&quot; AND Dateto > # &quot; & Request.Form(&quot;Date&quot;) & &quot;#&quot; It does not like pound...

I have two date fields in my database which are called Datefrom and Dateto. I am quering this database to retrieve a date that is greater than datefrom and less than dateto. So its in the middle of these two dates. I am all messed up with the syntax. Below is the SQL code. SQLtxt =...

Perfect solution. Many Thanks to the Awithers fellow. It worked right on. Now I understand why we use # # for in betweeens. Thanks all others who contributed

I am trying to search for a date from my Access datebase. The field name is 'DateFrom' and is in ShortDate format in Access. I have a date search text field setup in ASP. And I am using the correct date format in it, still when I search for a date that does exist in ASP, it does not return...

Greattt!!! It worked!!! I was just thinking about the Onblur method when ur reply cam up. Thanks a lot!!!

I have a search field where I want only Numeric values to be inputed. Below is the code I added. Sub btnSubmit_OnClick() If Not IsNumeric(FrmBarcode.Bcode.value) Then Alert &quot;Only numeric values are accepted&quot; FrmBarcode.Bcode.Focus Exit Sub End If End Sub This all works fine...