Search results

I have not been able to try this code because the checkbox selections are not working. It gives me an error that "Control can't be edited because its boud to an unknown field". What could be the problem? I have the field created, the only area that the properties box has for entering in a field...

I would like to use this just for check boxes. Would this code work? DoCmd.OpenReport "FinalREPORT", acViewPreview, , "[ReportPeriod]='" & Me.cboReportPeriod & "'" & " AND [YesNoField1Name]=" & Me.CheckBoxNameHere & " AND [YesNoFieldName2]=" & Me.CheckBox2NameHere So would I still need this...

I figured it out, I had entered in an extra letter somewhere. Thankyou! How do you modify this code for multiple Yes/No fields? ' this opens the report in preview mode and you select the customer using the single quotes because Me.cboCompanyName ' returns text and text needs to be surrounded...

I created a table and then created the combo box based off the table. The table lists the items in the order I want them in, but the combo box lists them in ABC order. How do I change it to show them in the order that I listed them in the table?

I guess I dont understand what a recordset means. When I look at the forms properties, the record source is blank. And the field list button is gray.

I am using your example as a template but it is not working properly. The form that these buttons are in, is it based off of a table? How do you get a field list to choose from?

How are you relating the drop down menu to the button command to pull the report?

what I was trying to do was create a form that had buttons that would allow you to select something from a prepopulated dropdown and then generate the associated report with that parameter selected. I tried to simulate what you did with the simple sample you sent, but the back end piece wasn't...

So what I have is an input form called Leadership Reporting that contains a form and subform. They enter the report period in the Leadership Reporting form which is linked to tblLeadershipTeam, then they complete the subform which is linked to tblActivity. I need the report to pull information...

Hi Boblarson...did you have any luck with this DB?

Oh my, is there anything that I can start to make this DB feature work? I really do appreciate all your help with this! Thanks a ton!

Thanks! Here is the DB

The ReportPeriod is a text field. I tried to attach my DB but it is too large. How do I compress it to send?

This is the code that I have. Private Sub cmdOpReportingPeriod_Click() ' this opens the report in preview mode and you select the customer using the single quotes because Me.cboCompanyName ' returns text and text needs to be surrounded by quotes. DoCmd.OpenReport "rptReporting"...

I have tried to replicate the form that boblarson had a sample of but I cannot get mine to work. I am using the Select by CompanyName example. I entered in all my information into the code, but when I click the Open button it gives me a popup window stating "Enter Parameter Value". This...

what would the code/commands be for selecting yes/no fields? I have about 8 that I would like them to be able to choose as many as needed.

boblarson and Kryst51 you two are genius! This is exactly what I was looking for! Thanks!!!!:D

Sorry I should clarify.... I have the drop-down in my form. I need to report on certain information in that form. So I am creating a query and basing the report off that query. Queries allows you to create parameters so you can pull certain information. When a user opens my report I want...

One of my fields is a dropdown list. I'd like to query by that field and I want the user to chose from one of the pre-populated options. Is there a way to create a parameter in queries that will allow this?

Thank you everyone for your suggestions!:) The only thing that suited what I needed was the direct code. I just customized it to include both fields.