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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.