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 dencom 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: kjschmitz
  • Content: Threads
  • Order by date
  1. kjschmitz

    Recordsource query criteria based on checkbox and combobox selections

    On my Form test_Projects I would like to be able to filter records based on both a project year combobox (cbo_Project_Year) selection and a completed projects checkbox (chk_Comp_Proj). Here is the recordsource of the Form (qry_Overall_Project_Management): SELECT Projects.Project_ID...
  2. kjschmitz

    Append Query Where Clause Coding

    Basically I am trying to combine certain fields from two tables into one using an append query. The trick comes in that I want to only include records that have changed since the query was last run. When I first run my query, I get the results expected to populate the desired table...
  3. kjschmitz

    Many to Many Relationships; Handling input from "One" Sides

    I'll begin by describing my situation verbally, in an effort to avoid unnecessary detail if it's not required. I am creating a system of tables to track construction bids from an owner's perspective. Within a given project, I need to add potential bidders (Construction Firms). Each project...
  4. kjschmitz

    Crosstab Query with Dynamic Rows and Columns for use in Report

    Bear with me as I am unsure if I am doing this in the correct manner. I have a collection of 5 tables pertinent to this question. Projects: Project_ID (PK - autonumber) Project_Name (text) [additional fields not pertinent] Eligible_Bidders Project_ID (FK)* Contractor_ID (FK)* Contractors...
  5. kjschmitz

    Form based on query (many to many) adding values to table?

    I have three tables in a many to many relationship. tbl_Projects which contains the Project_ID (PK - autonumber) field and Project_Name (text) field. tbl_Contractors which contains the Contractor_ID (PK - autonumber) field and Contractor_Firm (text) field tbl_Eligible_Bidders which contains...
  6. kjschmitz

    Excel Column Width Changing on File Open

    We have a spreadsheet that is being used by multiple parties (one user at a time) and sent via email to the next person in the "custody chain". It is important that the column widths stay the same during the entire process. One user opens the file and finds that the column widths have...
  7. kjschmitz

    Hyperlinks to same workbook using vlookup

    I have a Workbook that will constantly be growing as the years progress. One one sheet I have all of the project information collected in 25 columns and an ever expanding number of rows (currently over 1500). To assist the users I have created another worksheet within the notebook that they...
  8. kjschmitz

    Combobox won't respond to zero as first char. in string: Simple Fix?

    Pardon my ignorance, I have been trying to develop a database for my department (well beyond my training) and I have come across a small issue: I use a combobox (cboProjNumber) in the header of a form (frmStaffUpdateProj) in order to allow users to select a record to edit . It works fine the...
  9. kjschmitz

    Excel identifying (counting) decimal places

    Hello all, I have been getting a lot of great advice from many of you by reading through previous posts, but have stumbled upon an issue that I cannot seem to find a solution for: I am currently working in Excel 2003 (although I have access to 2002-2007) and am going to be undertaking a project...

Part and Inventory Search

Back
Top