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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by samusa
-
Reading back names instead of numbers
Thanks! Sam- samusa
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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- samusa
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
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- samusa
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
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...- samusa
- Post #11
- Forum: Microsoft: Office
-
Copy to corressonding cells
Thanks! I just saved it. Go ahead and delete it. Thanks again. Sam- samusa
- Post #9
- Forum: Microsoft: Office
-
Copy to corressonding cells
Thanks willif! I will greatly appreciate if you could send it when you get a minute. Thanks! Sam- samusa
- Post #5
- Forum: Microsoft: Office
-
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...- samusa
- Post #3
- Forum: Microsoft: Office
-
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...- samusa
- Thread
- Replies: 11
- Forum: Microsoft: Office
-
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...- samusa
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
-
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- samusa
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- samusa
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
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- samusa
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- samusa
- Thread
- Replies: 7
- Forum: Microsoft: ASP (Active Server Pages)
-
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 -
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...
