Search results
-
M
Query not combining and filtering values based on a form
Okay, just realized you wrote about the auto update but I was to late. I already changed the form name to frmMultiSelectqry and changed DropDown qry test to qryMultiSelect. I have not touched the Record Source in the form. It says qryDropDownTest. I tried using the form and it still seems to... -
M
Query not combining and filtering values based on a form
I am following instructions but something like the name of the form or query is up to me. Wait, I'm getting confused. Right now the Record Source for the form is qryDropDownTest? Is that right? If so, what is DropDown qry test? Is that used at all? bc if it's not being used by the form I... -
M
Query not combining and filtering values based on a form
I guess they should be changed. Right now nothing is dependent on them so it's a good time to change them. Not sure what to call them? Maybe frmMultiSelect and qryMultiSelect? If that's not good, please change to what you think is best. -
M
Query not combining and filtering values based on a form
I changed the order of the Detail section to: Project_Name, Supplier_Name, Location/Affiliate_Name, Unit_Cost, Quantity_Purchase, Total, Picture. But... You're going to hate me for this. Instead of the Madeup Code from the DropDown qry I need to add the Description field (which is in the... -
M
Query not combining and filtering values based on a form
Are you kidding!?! You do not need to apologize to me. I total understand. -
M
Query not combining and filtering values based on a form
"I will be able to walk you thru adding to the Record Source, changing the the Form around, etc, etc.. No problem." Great, eagerly awaiting your instructions. "Allow Edits - Sorry that was me typing and not enough coffee. It should be Allow Additions to No and that is on the Form level." Got... -
M
Query not combining and filtering values based on a form
Okay, I looked at the code behind the Set Filter button. It's obviously all Greek to me. As I mentioned before I don't know SQL (would like to start to learn). I know basic Java so I can sorta kinda follow what's going on but not really (I'm going to look at the code more thoroughly this... -
M
Query not combining and filtering values based on a form
Gina, Thank you does not even begin to express how much I appreciate what you have done for me. I can't believe it, this is incredible! This is exactly, exactly what I was thinking of. Just didn't know how to do it. Couple questions: 1) You need to explain to me how you did this. Seriously... -
M
Query not combining and filtering values based on a form
Boy, what a luxury! I'm thinking maybe the form because with the query they would need to close the query window in order to run another query. And if it were in the form they could keep running different queries without having to close and reopen the form. Am I thinking correctly? But... -
M
Query not combining and filtering values based on a form
Ok I have attached a copy of my db. The form I'm talking about is called DropDown form. The query it uses is called DropDown qry test. The table it is querying is called Equipment. -
M
Query not combining and filtering values based on a form
I totally understand. I appreciate the time you are spending on this to help me. -
M
Query not combining and filtering values based on a form
I need the name of the fields in the Table (or Query) those three Combo Boxes are attached to and the name of the Combo Boxes, i.e. 1st combo box name: Combo1 Row Source:SELECT Project.Project_Name FROM Project; 2nd combo box name:Combo3 Row Source:SELECT [Supplier].[Supplier_ID]... -
M
Query not combining and filtering values based on a form
I have looked at it the sample db. Not sure what to do with it? The form in it is pretty much what I'm looking for because you can pick and choose which fields you want to search on (but his form does not have drop downs which I need to have in my form), but I think I might be a little to deep... -
M
Query not combining and filtering values based on a form
Ok, I downloaded the sample database from the Allen Browne web site. -
M
Query not combining and filtering values based on a form
Thanks for the reply GinaWhipp. I have seen that article before. The problem is that he/she does not recommend using a query (not sure of any other way of getting the results) and it also does not tell me how to do it. It lists the SQL statement but I’m not sure what to do with that, as I... -
M
Query not combining and filtering values based on a form
I have a form (DropDown form) that has 3 drop down fields, you select your values from the drop downs and you would push a command button that runs an event procedure which runs a query (DropDown qry test). The user should have the option of picking any combination of fields to filter by. Or... -
M
Question Getting rid of password's on opening all database's
That worked! I went to the change password option put in my old password and in the space where it asks for the new password I put nothing. The next time I opened the db it didn't ask for my password! Thank you burrina for your time in helping me with this. I appreciate it. -
M
Question Getting rid of password's on opening all database's
That's not how I set the password to begin with. I set it by adding the Users and Permissions button on the ribbon and clicking on User groups and accounts. But there is no option in there to "unset" it. Only an option to change it. I also trying holding the shift key and opening the db but... -
M
Question Getting rid of password's on opening all database's
I'm sorry I'm relatively new to Access, you need to be more specific as to where I find this option to unset it.