Recent content by ramindya

I have created a multi selected list box functionality like in the attachment which has a unbound control with possible choice of list items and also a text box were the selected choices can be inserted into the text box. What it does? I am able to select one or all the choices that is present...

Database information: I have three tables Patient , Scheduling and Tracking tables Patient table has ( MRN, Name ) Where MRN is Primary Key. Scheduling table has ( ID, MRN, StudyID ) WHERE ID ( Autonumber) is primary key. Tracking table has ( ID, MRN, StudyID ) WHERE ID ( Autonumber) is...

There is source database named DBsource with source table named tblA_MainBaseTable and destination database named DBDest with destination table table named tblA_MainBaseTable (same as source table) Now I want to delete the existing tblA_MainBaseTable in the DBDest and copy the new one from...

Hello: Attached is the application that I am working on. The application has two list boxes and I am able to move the data from one list box to another list box which updates the data in the table (tblnames) but it does not save the data permanently whenever I open the application it default...

I have a table named tblMain and the schema is: ( MRN is Primary key ) tblMAIN MRN STUDY1ELIGIBLE STUDY2ELIGIBLE STUDY3ELIGIBLE ..... upto STUDY30ELIGIBLE Sample data for the table is: ( For simplicity I reduced to 3 studies actually there are 30 more studies ) MRN STUDY1ELIGIBLE...

I have a table named TableA which consists of following : ( ID is primary key ) ID SSN Lastname PHONENUMBER 1 123456789 ASHOK 5097863736 2 123456789 ASHOK 6572527257 3 897262562 KUMAR 9897867298 4 897262562...

I have a table named TableA which consists of following : ( ID is primary key ) ID SSN Lastname PHONENUMBER 1 123456789 ASHOK 5097863736 2 123456789 ASHOK 6572527257 3 897262562 KUMAR 9897867298 4 897262562...

I have a table A that has following fields MRN, DATEOFLASTCONTACT, NAME. There is no primary key in this table. I want to delete records from the table for the same patient whose date of last contact is less than max date of last contact. Example: TABLE A: ( BEFORE RUNNING SQL QUERY ) NAME...

Hello: I have a table tblCallLog which has a field called "Calldate". I need to calculate number of counts of days which meets the following condition: Currentdate - Calldate <= 60 This is the Sql "qryPhone1calllog" I tried but it does not work.. SELECT tblCallLog.CCSSID...