Search results

Thanks Wayne Do you think maybe I could Zip up what I have and have you take a look at it? I appreciate the quick feedback,This is driving me crazy!!

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

Thanks Sambo I will give it a shot. I appreciate all the help from everyone on this site. Happy Holidays

Thanks Pat I appreciate your feedback, Can I switch gears a moment? I found a way to do what I want but for all of the access pros out there, I am sure I will get an earfull : ) What I am doing is using a "Label" as a description with a "Yes/No" Field attached. This will do what I want only...

Shay I see that when I save my post, It throws off the columns so Here is what it should look like: Col1 = LAB Col2 = CBC Col3 = Hematology Col4 = Laboratory Hope this one shows better. Thanks

Sorry As far as I can tell, I will need a second table to show the following, Again these are predetermined. Table 2 = Col1(Named whatever) Col2(Named whatever) Col3(Named whatever) Col4(Named whatever) Col1 Col2 Col3...

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

Thanks PdX How would i check to see if there is a record for the subform? Sorry, I am a newbie. Rick

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

Dumb Again Sorry Fizzio, Where would I put this bit of code? On the "Form" Property? Thanks

Sorry Sorry I was not clear, The status field is a drop down box that containes: 1-Active 2-Pending 4-On-Hold 5-Closed/Comp # 5 is the one in question. Hope this helps. Thanks again

Can you show me an example of not showing the records if the following conditions are met: Status = Complete AND Checkpoint date is < Today Thanks

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