Search results

hi, instead of providing validation at the client side or in the server script.... cant i provide validation in the tables fields... I have a field named YearID, datatype text.. But I want to allow only text like this ==> e.g. 'F-00' 'F-01' Do I have to put any format property...

hello all, I have got 3 tables for employee training programs Employee TokenID (pk) Name Division Training_Program Prog_ID (pk) Cost Employee_program Serial_no TokenID (fk) Prog_ID (fk) Training programs are conducted for all divisions.Employee from two divisions can also attend...

how do i display all fields in a table, excluding a aprticular field sumthing like Select * from employee ( except tokenID) please do help thank you

helo al, I have two tables Employee TokenID (PK) name location post .. ..etc Rating TokenID (PFK) FinalScore I am trying to display all the fields from Employee table where Employee.TokenID= Rating.TokenID but I only want to display the fields from the Employee Table and not from...

hello all I am trying to set column values to a random number between 3 and 5 PMRating TokenID: text H1: double YearID: text UPDATE PMRating SET PMRating.H1 = (5+3-3)*Rnd()+3 This shows type mismatch error . What is the problem here.. please do help...Thank you

I have a two tables in my database related to employee ratings Employee TokenID Division Band PMRating TokenID H1 Now this statement SELECT DISTINCT Employee.Band FROM Employee This would display me all the band levels within Employee table in each row.. Is there any way I could built a...

hello all, I have two tables related to employee and his ratings.... Table: Employee ----------------------- TokenID (pk) Division Post Table: PmRating ----------------------- SerialNO TokenID (FK) H1 In this organization there are 5 Posts Some division may have all 5 , some may have...

hello all, I am using MS Access 97. I am trying to work out a query to extract the employee ratings based on certain matches... i have attached a text explaining the structure and the type of results I am trying to get... Please...If you could take time out to check this....it wud be great...

hello all, how do i keep a log of all the changes made to an access tables . And also if possible , by which user... Please do help...I m really new to this... Thank you

hello all, How does one keep log of what are the changes made to the access database in terms of the updates, appends etc.. please do help.. Thank you

hi all, how do i create view based on a condition. For example my database consists of a Employee table *Token ID Name AGE Location Division. Now the users of this table would be employees from different divisions. And i want to create a view for each division for records only belonging...

Hello all, Multiple selects are not possible in Access.. I have a employee table who are categorized based on their division etc... Division is a seperate table which enlists all the divisions and is linked to employee table by relationship table called Designation. EMPLOYEE *TokenID...

hello all Consider i have an employee database. And i want to keep a track and analyze all the training programs every employee has attended from the day he joined ( for both working and resigned employees). The analysis part is based on division-wise, level-wise, year-wise, location-wise...

helo all, I have two tables I want to copy all the contents of column in tableA to coumn in tableB. How do i update it using queries.. please help

hello all, Is there any provision to copy and overwrite a particular portion of data from excel worksheets into Access table based on the primary key match. I am using MS office 97.

replicate column helo all, I have two tables I want to copy all the contentc of column in tableA to coumn in tableB. Both the columns are primary key of respective tables. . One more doubt-- Can i have primary key of two tables with same name... Example: Table A...

hello all, One simple question .... Hows rollback done? Till what limit can it be done? And do the capapbility change for different versions U dnt have to guess....im a newbie :o

hi, Im using MS access97 as a database. I would be using simple SQL to get data from the tables using ASP. But I also need to create graphs dynamically from data from the resultset, Ive heard of a software called SQL+D which makes use of SQL queries in ASP to build charts dynamically. Does...

hi, Im using MS access97 as a database. I would be using simple SQL to get data from the tables using ASP. But I also need to create graphs dynamically from data from the resultset, Ive heard of a software called SQL+D. Does anybody know where i would get that? Or can anybody suggest any other...

hi, Im using MS access97 as a database. i would be using simple SQL to get data from the tables. But I also need to create graphs dynamically from data from teh resultset, Ive heard of a software called SQL+D. Does anybody know where i would get that? Or can anybody suggest any other...