Search results

Hi All, I have a form with 22 subforms (in about 11 tabs). Each one of these subforms has a controlling field in the main form (table) that dictates if the associated subform needs to comply with data entry rules or not. For example: Field in main form cboMed (Yes; No) Subform: frmSubMeds has...

Hi All, I'm trying to create a function that insets into a table. The idea is to use this function to create an entry in table tblBackupLog. I intent to use this to backup the database, and add an entry into the table. Public Function addBackupLog(strAction As String, strComments As String...

Hi Experts, I have an union query getting data from two separate tables. I'm using this union query to search for records using simple text search. Query looks like this: SELECT table1.Name, table1.Surname, table1.DOB, table1.id, table1.diag FROM table1; UNION SELECT table2.Name...

Hi All, I have a complex (to my standards) requirement. I have a field called a patientID, this is a field that is filled by the users that create the record. It has to have the hospital id at the start. Example: Hospital = Queen Victoria Hospital PatientID = QVH001 This application that i'm...

Hi All, Just wondering if there is any way to create a dynamic report to allow users to select any fields from the table and add an operand like 'AND', 'OR', '<', '>', '=' etc between fields and then generate the report. Example: Table: Employees FirstName LastName DOB Address City Country...

Hi all, I have a situation wherein i have to calculate the age of a person at a particular time based on two dates. Eg: Date Of Birth = 01/01/1990 Date of Insurance Start = 14/02/2000 Age at Insurance start = ?? -------- I'm using DateDiff as follows...