Search results

Still looking for help on this. I tried setting the DefaultView in code and read somewhere that it could only be set in the properties window for the form. If anybody knows different, please let me know. Also, still only getting 1 record on the form, no matter which option I switch it to. Thanks

Yes, I have tried continuous form, datasheet, etc, etc. Nothing changes. I am also trying to manipulate the form property in code but I am getting errors. Forms!Results_frm.DefaultView = 1 Getting this straight from Microsoft - (tried to post the link, but was not able to). But I am...

It is an implied join. I did not call out the join with a Join clause, but am joining the two tables in order to match up the records. The Process_Meetings table provides me the One side of the relationship and the Process_Meetings_Capabilities provides the Many side of the relationship. My...

I have a form that a user will use to search records. Upon selecting a record, there are three buttons that allows the user to look at more detailed information. This information will be on the many side of the relationship. So I will have multiple values. The called form is just a popup...

Thanks Paul. That definitely worked. Cleaned things up a bit and now I have all three buttons working with the correct output. I appreciate you taking the time to help me understand. I like that last trick. Using a constant and supplying that in an AS clause. That is real nifty.

Paul, Ok. Great find. I appreciate that. So I can hardcode the binding in the properties of the textbox, but that doesn't allow me the flexibility to choose an option from my primary form. Btw, I did do that and the results displayed as you suggested. So now I want to make this happen...

Paul, Attached is a scrubbed version of the DB. Most of the tables had to be truncated. However, it shouldn't affect the behavior of what I am trying to do. If you will go to the Project_Scope_Deliverables form and open that form. Then click on the In Scope buttons, you should see the...

Paul, Sorry. Should have mentioned. I have ran the query in the SQL query tool and it does return the row as requested. As far as the db, I would have to delete all the records in most of my tables as it has client specific details regarding our project. If that will work for you, then I...

Paul, thanks for the suggestions. Popup and Modal were initially set to Yes. I set them to No and it still did not allow the results to display. I also created a message box after the opening of the form and I do get the form to open and the msgbox to display. I then reset Popup and Modal...

I am relearning Access again and need some assistance. Using 2010. Would like to open a new form as a popup to display the results of a query. Trying to avoid eliminating objects in my DB, so not wanting to create Query Objects, but just creating the SQL on the fly. The purpose of opening...

Hey all, I am a consultant in the US. I use Access from time to time, but it always seems to be a couple of years in between the times that I use it. So it seems like I am always relearning. My consulting is not for Access, but I use Access as a tool for managing project artifacts and such...