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 SkipVought 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: *

  • Users: 553
  • Order by date
  1. 553

    Field Size

    How can I increase the 255 character field size. I have a comment field in my form that will require more than 255 characters, how do I work around that.
  2. 553

    Insert new row in acess form

    I have a main form with employee information. I then have a a subform called cases where the emplid for the main form is linked to the subform by the field complaintee's id. The case no is the primery key (autofill). In the case that there are more than one case for the employee, I want to be...
  3. 553

    Autofill in Access Form

    I have a subform that has the field name - Emplid. I want to be able to enter the emplid and the Employee Name is them populate on my filed called Name? Thanks!
  4. 553

    Median with multiple conditions

    Hi Zack - Thanks for the quick response. I tried the formula you provided but I am still getting a 0. Can I send you my spreadsheet?
  5. 553

    Median with multiple conditions

    Sheet 1 is my summary sheet which contains the following: Cost Center Job Title Med Accounting 1st VP Controller Accounting Financial Analyst Accounting General Accounting Mgr. Accounting Jr. Accountant Accounting Staff Accountant Accounting SVP/CAO Accounting Tres. Analyst Accounting VP...
  6. 553

    if statement with an average condition

    I have a worksheet (Employee Detail)which contains hours per employee. Each employee belongs to a specific region. I was trying to retrieve on different worksheet called sheet8 within the same workbook the averages per region using the following: =IF('Employee...
  7. 553

    nest if statements with more than 7 conditions

    I have a worksheet called benefits with a column Monthly Contribution. I need to bring in the employeer contribution by writing the statement below. I was trying to write an if statement but I can only have 7 levels. How do I do this in Visual Basic. My conditions I was using in Excel is as...

Part and Inventory Search

Back
Top