Recent content by Dedicated

I have a form with 3 tabs - I'm trying to print a single page from let say tab 1. When I select Print --> Selected Record - I get not only the page I need but 3 blank pages that follow. What can I do to correct this. I've already set page breaks for each tab. If the width is > then the page...

Question: I have a database in which only 2 users gain access to - password protected. Within this past week they can no longer be in the system at the same time. What causes this? One suggestion was that the data might be corrupted. I'm trying to figure out a logical reasoning why they are...

PaultheS...Thank you soooooooo much!

Emp2: IIf(([Empl2Name]<>[EmployeeN]) Or ([CaseC]=-1) And ([Empl2Name]=True),[Empl2Name],Null) Emp5: IIf(([EmployeeN]=True) And ([Empl2Name] Is Null) And ([CaseC]=-1),[EmployeeN],Null) How do I combine these 2 "IF" statements. I need to pull a report on all employees from both Emp2 & Emp5.

Okay, thank you.

Nested query - I had to search employee's name under 2 seperate criterias...I named the fields in the query [Emp1] and [Emp2]. Now since I have the correct info I need to create another query with a single field which combines the names together. So, I need a list of all employees from both...

All my monthly rpts are pulled by Month (Text) in my query. I need to generate a report pulling from April thru June of 2005. Since I can't use the "Between" operator so what other options do I have? I used a separate table to list the months and then linked via lookup wizard. Should I add an...

I have a created a Y/N field to identify if a specific date was entered correctly in our dbase, if NO I would like to prompt a dialog box so we can enter the date shown in our system. How do I do this?

I would like to create a query were I can check to see if the 2nd part(tab 2) of the audit on my form has the same Employee name as the 1st tab and/or if the name is null but the audit was been done by the same employee on the 1st tab and the checkbox marked to reflect such. I don't know how...

I have a from in which I'm trying to pull a report on a single employee listing total possible scores for each section of the audit. I have 2 empl fields because 2 different employees can be audited on 2 parts of the process on the same form. EmployeeN (drop down list) and then Empl2Name (data...

I have a unbound drop-down list on my form with 8 columns. I'm using this form strictly for a resource tool. When I click the selected row all data should filter to the designated fields (8 fields). Problem: When I click on the selected row is automatically shows the 1st row of data, I can go...

You are WONDERUFL!!!!! The entire team would like to thank you for assisting us.

Are you talking about in the properties dialog box under Event, On Open? I did this and it was looking for the macro. Would not execute........

Objective: Maximize page size on switchboard. I know I have to go to Form Properites -->Event -->On Open and then add my Macro in order to maximize my form when opening. However, if I cannot use my macro due to system contraints, is there another way to maximize your form upon opening?

Thanks so much for your advise. I thought that was the case but I wasn't certain until you confirmed it.