Search results for query: *

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

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.

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

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?

I need to generate a report listing each record#. My query shows the AuditID# [AuditID]AutoNumber for each record create in a form,but I need to show the acutal Record number affiliated with the audit number as well. How do I extract this information or create a query that will allow me to...

I have developed a dbase for auditing employees each month. Each audit will have it's own record (this means if an employee was audited 40 times for the month of June, then he should have 40 records for that month. On my report I needed to count the # of records audited per month. I used the...

Created several unbound text boxes in a field to calculate results on yes/no fields, not realizing that the data captured would not be stored in the table or query. Yep, I'm a novice! Only after 325 records later did I realize I made a BIG mistake! I created only 1 table and linked that table...

I have a report in which the Month is grouped with team listings and status of each team. Presently I have it set up under the "Sorting & Grouping" as "Descending" but I really need the report to show month by order...January, February, March, April, etc. instead of my "descending" order...

I was trying to establish me as the Admin on our LAN under our workgroup path, but have messed it all up big time. Now I can't use security wizard to prevent users from deleting or modifying objects. When I click on Security Wizard the following appears: "You must be a member of the Admins group...

I'm trying to set up security access rights for a single Access dbase in a network enviroment (LAN), and am having problems setting it up correctly. My end result was that all Access dbases were impacted on my system. Each required my password and held the same object restrictions. I believe...

I would like to generate a command button where I can search by first and last name to pull the record up in my main form. I have (2) fields [ProviderFirstN] and [ProviderLastN]. Do I need to create a macro? My main table is linked to the "qry Provider Main". Thanks, Dedicated

Main form (Audit Main) Subform (Employee) child Subform (Area Audit) child Problem: In my Table in the Datasheet View - When I clicked on a single record to view the subforms only 1 subform will appear (Employee). I had added the second Subform (Area Audit)this week, so I'm not...

I have a Yes/No field in which the majority of the time the answer is YES. Instead of constantly clicking the box to indicate true can I set YES as a default? Thanks, Dedicated

I have a Main form with a subform. I would like to be able to find a record searching the following fields: FunctionalArea; DeptTeam (drop down menu); Month. This would allow me to search for the area in question, the department team it belongs to, and the month of the Audit. Thanks,