Recent content by mjanalyst

VilaRestal, Thanks so much. It looks great. I am going to try and intergrate this into my other datebase. I might replay back on Monday if I have any questions. Thank you again. Mike

VilaRestal, Thank you for the response. I have uploaded a example datebase with the genral idea of what I want to do. Unlike this example when I click the filter button it will open a form with sub forms. I like your OpenArg suggestion, but I have no idea how to do that. So if you could please...

Good Afternoon, I have a new issue that I would like to know if it possible to fix and if so how. In my database I would like to select a date on a form that is connected to a table that just records the date. I would like then to click on a button to open a form that has several subforms...

Hello, I am looking to limit combo choices that the user can select. I am having the records filtered to only show the same company. But I would like user to add new records only for that company that is already filtered. The user chooses the companies via a combo box that list all of the...

Bob, Thanks for the explanation. That makes a lot of sense. So after your lesson I went through and checked the data field types and the combo box columns. I did a little testing and it works now. Thank you so much for your help. Cheers. Mike

Bob, Thanks for the response. Utility data field is text. It is a list of utility companies you can choose from. I am not sure the answers to you 2nd and 3rd question cause I was given the code before and not sure what it references and I don't know what the 0 or 1 means. The original code...

Hello, I am still new at access and I am using a combo box to filter a 2nd form upon clicking a button. I posted on this topic the other month and was given some code that works. I am attempting to tweak it for another part of my database. I am receiving a Run-time error "3464': Data type...

Good Afternoon. I am looking for some help with code to filter a form that I will be opening. I would like to click on a button to open a 2nd form and have it filtered as per a employee name. Each employee will have there own button with there name on it and there record will show once they...

Great news guys it works now!!! pbaldy the code you gave did it for the parameter problem. Both thank you so much for the help. Greatly appreciated.

Bob. When I save the database it wont let me save it as a later version unfortunately. The form's record source that is being opened is called testing. Its a table that all my records are placed in. ESCO_Name is just one of the columns in that table. That is the settings that I currently...

Bob, I have attached a copy of the database. I got rid of the sensitive info and just the shell with company names are in there. I believe this version will be able to be opened in 2003. If it doesn't work let me know. Thanks. MJ

Hello Bob, I put in that code and this message box appeared. Oh and after I hit the ok on the message box access asks me to enter the parameter value again for ESCO_Name. I am wondering if Access is having the issue of matching up that parameter on the 2nd form that is opened for some...

Good Morning Bob. Thanks for your suggestions. I tried that this morning but unfortunately it didn't work. I received that enter parameter value box again for ESCO_Name. When I hit okay it takes me to my 2nd form that i am opening and displays no records. When I hit the cancel button it displays...

Guys. Thanks again for your help!! I am heading out of work. If you respond I will get back to you in the morning.

Guys thanks for the quick help. I put the code pr2-eugin just said DoCmd.OpenForm "Testing", , , "ESCO_Name = '" & Me.Combo19.Column(1) & "'" but I am coming up with the message " Run-time error '3075': Syntax error (missing operator) in query expression 'ESCO_Name ='Brown's Energy Services...