Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. samusa

    Reading back names instead of numbers

    Thanks! Sam
  2. samusa

    Reading back names instead of numbers

    Hi, I have a column in a table that uses 1-9 to represent names and these names are saved in another table. I want to get names instead of numbers when I execute a query. Can anyone help me out?Thanks! Sam
  3. samusa

    Updating Excelsheet

    Hi, Is there a way out to link MS Access query results to excelsheet so that whenever query is executed it will automatically update spreadsheet. Appreciate it. Sam
  4. samusa

    Copy to corressonding cells

    Thanks a ton! It works fine however when I used =VLOOKUP(B3, test, 2, FALSE) , I got #N/A in cells where there was no match. I just want them blank, so I used following: =IF(ISNA(VLOOKUP(B3, test, 2, FALSE))," ", VLOOKUP(B3, test, 2, FALSE)). This works fine and leaves all those cells blank...
  5. samusa

    Copy to corressonding cells

    Thanks! I just saved it. Go ahead and delete it. Thanks again. Sam
  6. samusa

    Copy to corressonding cells

    Thanks willif! I will greatly appreciate if you could send it when you get a minute. Thanks! Sam
  7. samusa

    Copy to corressonding cells

    Actually I want to copy results of the query to the second column and it should match with Ist column layout. e,g; Ist Column Second Column Bindview Windows Visio .... .... The query returned Ist column and second column results. Now If there are 100 application listed in first column...
  8. samusa

    Copy to corressonding cells

    Hi all, I have an Excel spreadsheet with different columns and the first column has application names. The second column and the rest of columns get data by running different queries in MS access database.Let us assume I have 100 applications listed in first column and I am running a query for...
  9. samusa

    Conveting ADP to MDB

    Hi Experts! Access ADP database is linked to SQL server. I have access to ADP file via Remote Desktop. I need to write some queries and at the same I want to do it locally on my desktop. Also I want to keep my local copy linked to ADP file so that it is always connected to real data. Can someone...
  10. samusa

    How to call ASP file in Data Access Pages

    yes Data access pages end up with .htm. Can you tell me how to convert htm to asp. Also is it going to make any difference. Sam
  11. samusa

    How to call ASP file in Data Access Pages

    Thank you for your reply. It is not working. May be I am missing something. Is there a way I can hide sub pages from URL in address bar like if default page URL is www.test.com and if a user clicks on another page say empinfo.htm , address bar should show www.test.com instead of...
  12. samusa

    How to call ASP file in Data Access Pages

    I already tried it but not working. I have placed it on top of the Data access page . can i put it in after <HTML> or after <BODY> tags Sam
  13. samusa

    How to call ASP file in Data Access Pages

    Hi Experts! This is driving me crazy. I have created data access pages in MS Access and a logon page in asp.Data Access pages contains XML, VBS and Java Script.Login page is working fine and once user is enter user name and password it directs it to main page of the application.However there is...
  14. samusa

    Include file in Data access pages

    Still I have to put following in all Data access pages.It is not working <% if not session("validuser") then response.redirect "login_failed.htm" 'something like that or asp page end if %> Sam
  15. samusa

    Include file in Data access pages

    No it is not. Here is the asp file code where from it grabs the value of LoginID. <!--#include file="db.asp"--> <% dim Username, password Username = request.form("uname") password = request.form("pword") %> <% Dim struserSQL 'SQL command dim rsUser struserSQL = "SELECT * FROM...
  16. samusa

    Include file in Data access pages

    I didn't get you. Do I have to use session function in vbs and put that script in DAP or I can call this script in a DAP. Sam
  17. samusa

    Include file in Data access pages

    I have created data access pages and a logon page in asp.However there is a file tiltled securitycheck.asp that need to included in all DAP's. Here is the code of this file: <% 'This Page is a Security Check Page 'This code checks if the user has logged in. 'It checks the session variable called...
  18. samusa

    User Login for Data Access Pages

    Thanks fneily for your quick reply. It will work fine if the user enters the URL of logon page. However if a user directly enter the URL of DAP2, he/she can bypass the logon page. Is there a way to redirect the user to logon page if user tries to enter URL of other than logon page. Sam
  19. samusa

    User Login for Data Access Pages

    I want to create a login-password page to grant users access to data access pages. If anyone has done anything similar to this, please let me know.Any help is appreciated. Sam
  20. samusa

    DAP and Memo Field

    Anyways, somehow i managed it. About writing a book, I am still going through learning process and just playing with DAP's. You are the DAP GURU... Sam

Part and Inventory Search

Back
Top