Search results for query: *

Upon further struggles, I am convinced that this is my problem: WHERE ((Projects.Project_Year)=IIf([Forms]![test_Projects]![cbo_Project_Year]=2011,2011,2012))) Using the following still fails: WHERE ((Projects.Project_Year)=IIf([Forms]![test_Projects]![cbo_Project_Year] in (2011),2011,2012))...

Thanks misscrf; That allows my listbox to accurately display the projects by year, but I am still having an issue with the form loading the record (if not in the Default value year of cbo_Project_Year) when the listbox selection is made. In other words: 1. I select 2012 from...

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

My table structure is as follows: Eligible_Bidders Bid_Tab_ID dbLong PrimaryKey Indexed Project_ID dbLong ForiegnKey Indexed Contractor_ID dbLong ForiegnKey Indexed Bid_Amount dbCurrency Unit_Bid_test Unit_Tab_ID dbLong PrimaryKey Indexed Bid_Tab_ID dbLong...

Lack access to the DB right now, but I think my issue was using: ((Eligible_Bidders.Bid_Tab_ID) Not In (select Bid_Tab_ID from Eligible_Bidders)) and not ((Eligible_Bidders.Bid_Tab_ID) Not In (select Bid_Tab_ID from Unit_Bid_test))

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

Thank you Duane, I have convinced management that collecting data outside of the system on a printed "report" is not ideal, and have begun working on a form to allow entry of this data instead. I appreciate the example file and FAQ though, and will continue to reference those in future efforts.

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

Thanks again lameid, and hookom. Both of you were correct and it is working as expected now. I don't know why I always insist on making things more difficult than they need to be. Much appreciated, both of you.

This seems to work, but now I am having challenges writing the combobox row source statement to pull in all available contractors, even if they haven't been assigned to the tbl_eligible_bidders table yet. I'll mess around a little more before coming back with another question however...

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

One interesting post I found describing the same issue (albeit with no solution presented) http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.misc/2006-07/msg00286.html

Also, it should be noted that for some reason the standard column width is 8.11 on her computer, 8.43 on the rest of the workstations. Is there a way to universally (not individual workbooks) change that value?

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

Thank you so much, worked like a charm and my architects love it!

Thanks Geoff, that simplifies the first part, now how can I construct the hyperlink to go to that row reference? I must not be writing my hyperlink formula correctly...

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

One quick follow-up question: is there anyway to allow the user to input a project number and have it automatically add the dash (07-123) while entering the field to call the record without the input mask?

Thanks for the quick reply. The combobox is currently unbound. And your fix worked perfectly. Again, thanks, and have a star :)