Search results

I have a "User" field in a table that gets populated from an imported file. The data in the field looks like the following: MT<>PWI<>Smith MT<>PWI<>Jones MT<>PWI<>Doe How do I strip the MT<>PWI<> from the record(s). This will also need to work on our monthly imports. Thanks in advance

I have a form where a user can ADD/Update records. If they click the update icon, the form opens with the recordset showing the first record in the table. Problem is, There are alot of records and if a user needs to update his or hers data i would like them to be able to pull up just theirs...

I Have a database that has the following fields: Entity (Dropdwnbx with 3 selections) Department Number Department Name Department Head Job Position Position Qualifier Here is my delimma, PLEASE HELP!! I would like the user who may be updating the record to select one of the 3 entities from...

I have two tables, Table1 = Dept#, DeptName, Depthead,PhoneNumber,JobDesc, PosQual,Enteredby,phone#2. Table2 = (This table will contain 116 line items) Example: Col1 col2 col3 col4 1. Lab Blood gas...

Hi, I am working on a "hippa" database, with the following tables/fields: Table1 : Entity, Dept #, DeptName, Date, DeptHead,PhoneNumber,JobDesc,positionQual,Enteredby,Phonenumber. Table 2: Code(Code# will be 1,2,4,etc) PHI Description, Function. Table 3: Patient Population(Memo)...

Hi Gang, I have a field "Status" and 2 fields called "Checkpoint date" One of the checkpoint date fields are in a subform. How can I archive only the closed records with "Checkpoint dates" less than today? (In both main form and subform) Thanks in advance

This may be in another forum but, i could not find anything that seemed to be what i needed. Here goes, I have a "Projects DB" with the following tables. table1 = projID# Desc. Status...

I have a projects d/b that consist of employees and their projects. Currently, I have the users doing a "Find" on the "Responsible" field, Then they have to tab through their projects to get to the one that they need to update or modify. What i would like to have happen is have a Dropdown box...