Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. a75537

    Combobox Selected Item - Change Forecolor

    Hi all, I have a combobox with a list of items that I loop through, and when a condition is met I want to change the forecolor of the item in the combobox that meets the condition. For example - my combobox has 10 items, and 3 of the items match a criteria - I want these 3 items to appear in...
  2. a75537

    Microsoft Outlook 10.0 Object Library - Setup on Client

    Outlook is installed on the client PC - but I think you pointed me in the right direction. My development PC has Outlook 2002, while the client PC has Outlook 97. I'm guessing I need to use a different object lib for Outlook 97? Thanks.
  3. a75537

    Microsoft Outlook 10.0 Object Library - Setup on Client

    I've included the Micorsoft Outlook 10.0 Object Library in my project and everything works fine on my development PC. The code is really simple - just opening Outlook with an attached file: ---- Dim OLApp As New Outlook.Application Dim objMailItem As Outlook.MailItem Dim objAttachment As...
  4. a75537

    Panels & Radio Buttons

    Hi all, I have a Windows Form with 80 panels. Each panel contains 3 radio buttons (one radio button for Yes, one radio button for No, and one radio button for N/A). I would like to be able to retrieve the value of the radio button using the Panel. Lets say the Yes radio button has a value of...
  5. a75537

    No-Touch Deployment - Initial Form

    Thanks for your responses - it sounds like I may have to live with it. I will do some more research though, and post again if I find out any new information. Thanks again.
  6. a75537

    No-Touch Deployment - Initial Form

    I've just figured out how to distribute my .Net Windows Forms app using the No-Touch Deployment method. When I'm ready for distribution I'll simply create a shortcut on all user's desktops pointing to my executable file on a web server (after installing the .Net Framework). I've been testing...
  7. a75537

    Report Totals Double when Printed

    I do have some code in the OnFormat event of the Report Header, but it has nothing to do with the calculations. I'm just setting the caption of a label in the report header. Do you think this could be the problem? Thanks.
  8. a75537

    Report Totals Double when Printed

    I have a report that lists questions, and whether or not the questions are answered yes or no. The totals are displayed at the end of the report. For example: Question 1 Yes Question 2 Yes Question 3 No Total Questions: 3 Yes: 2 No: 1 Accuracy: 66.67% The report is displayed perfect on...
  9. a75537

    Toolbars and Templates

    Hi all, I've created a template using form fields where the user enters/selects information. A custom toolbar is attached to this template - it has one button called 'Send' that writes the information the user enters out to a file. When the user opens this template the only toolbar I want the...
  10. a75537

    Linking Tables - Undesirable Results

    synapsevampire: EMPLOYEES - EmpId, Department, Name INBOUND - EmpId, Date, Score1, Score2, Score3 OUTBOUND - EmpId, Date, Score1, Score2, Score3 I want my output to be: EMPLOYEES.Deparement EMPLOYEES.Name @AvgScore @AvgScore would be the total sum of (INBOUND.Score1 + INBOUND.Score2 +...
  11. a75537

    Linking Tables - Undesirable Results

    I have 3 tables: Employees Inbound Outbound The Inbound and Outbound tables both have the EmpId value as a field to link to the Employees table. The Inbound table contains info on all Inbound calls the employee received, and the Outbound table contains info on all Outbound calls the employee...
  12. a75537

    Top N or Sort by Formula Field Work Around

    I have a table called Score which has a field called Answer. Answer will always be either 1 for yes or 2 for no. In my report I have a formula called @NoAnswer which is placed in the details: if {Score.Answer} = 2 then 1 else 0 The field {Score.Answer} is also placed in the details section...
  13. a75537

    Get 2nd Name with same ID

    Thank you. This works perfectly. I didn't realize you could add the same table twice.
  14. a75537

    Get 2nd Name with same ID

    Thanks for your quick replys! My goal is to have a crosstab report with the Monitor's names across the top (columns) and the employee's names down the side (rows). They intersect at the average score each monitor gave the employee. Everything works fine except for getting the monitor's names...
  15. a75537

    Get 2nd Name with same ID

    I have an Employee table and a PhoneMonitor table which are linked by the EmpID field in the Employee table. I can then pull the FirstName and LastName fields from the Employee table based on the EmpId field in the PhoneMonitor table. This gives me the name of the person who's phone call was...
  16. a75537

    Error 2115???

    I've figured out a work around, but still don't understand this error. I put a 'dummy' label on the form and changed the caption to the value that I want for the text box(Me.cboReviewSection.Column(2)). I then set focus to the text box and change the text box text value to the caption of the...
  17. a75537

    Error 2115???

    I'm trying to do something really simple and I keep getting an error. I have a form with two combo boxes and a text box. The first combo box contains Review Types and the second combo box contains Review Sections based on the review type selected in the first combo box. I want the text box to...
  18. a75537

    Average of Group Average

    This report is grouped by department, and then employee. It is used to calculate quarterly incentive payouts. I have calculated the average points for each employee by using a summary field("Insert Summary..."). I now want an average of all employee's averages by department. Sample...
  19. a75537

    Hierarchical combo boxes - how do I add records?

    Please send me your solution. You can either post it here or send it to me at a75537@yahoo.com. My preference would be to have everything displayed on the same form, but I may use your solution if this is not possible. Thanks.
  20. a75537

    Hierarchical combo boxes - how do I add records?

    I'm trying to build a database application(Access 97), to help different departments build internal audits. Each audit can have multiple sections, and each section contains multiple questions. I've built 3 tables: AUDIT - AuditIndex(Autonumber), AuditType AUDITSECTION -...

Part and Inventory Search

Back
Top