Recent content by MetroToday

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