Search results for query: *

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

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

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

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

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

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

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

Ok. Here is the issue. I have DAP report that is based on a query.Report is grouped on StudentID. I want to display memo field text only once with a record but it repeats as many times as student's Assessment history displays. I can't move memo field up in a group as well. When I try to move in...

I have text field that i want to pop up message if user enters greater than 255 character. Can someone tell me how to validate it under Validation rule Option. Sam

I have created a vbscript that set labels to "hidden" if there is no data in a particular field. Now i get blank spaces in my pages that does not look good. Is there a way out i can scroll up the page whenever these labels are invisible. Sam

Hi All, I've been trying to accomplish this and can't seem to find a direction. Can someone please get me started or at least point me in the right direction. I have a table structured like the one below: ID StudentID LastName FirstName Title StartDate EndDate 1 1 Smith...

Could someone tell me how to make labels invisible if value of the field is blank, in a query or Report. Sam

Ok ..I have created Data Access Page based on history table(tblhistory). On Data Access Page I have used Option button (Yes and No)used for student's attendance assessment. When a Supservisor is looking at student information page(Say StudentID 1) and click on No option. Popup window should...

Hi, I have option buttons(Yes/No) on Data access page. If option No is clicked ,it stores NO value in "optno" field of tblstudent table.There is also a memo field in the table "NoComment". I want popup window/form to accept user comments and once he click on OK button, it should be saved to...

Hi Experts! I have option buttons(Yes/No) on Data access page.I want a popup window when user click on NO option that will accept user comments and this should be saved to memo field of Access table. Could somebody tell me how to do it in either javascript or vbscript. I would greatly appreciate...

I am using three checkboxes on DAP which represent three states. When a user check the checkbox1(say Maryland), "True" value is enterd into the table. Could someone tell me how to intrepret this " True" as Maryland in a query.Appreciate any help Sam

Hi I have command button which should quit the webpage if clicked. If I am using window.close, it is working though it is giving me message " the page will be closed...." I want no message just close the page. Sam

I have two Data Access Pages and two tables. I have update query that is updating table 2 to table 1. I want to autorun this query when I close DAP or when i click save button on DAP.Could some one help me out.I would greatly appreciate any suggestions thank you Sam

Hi Could any one tell me how to make referential integrity between fields. Suppose I have a field A which is associated with field B. If I want to delete Value of field B, It shouldn't allow me. I appreciate your help Sam

I have 2 tables with studentID as primary key in both tables. I am using DAP for data entry. Is it possible to enter primary key that gets store in table1 should reflect in table2 as well. Please help. Sam