Recent content by lisa1965

AutoNumber database I am attaching my database objects. My form trnCourseCodesTable has a button to add new record, that button calls another form called filterCourseTitle. But my code is not matching my logic. What I want to happen is when the user select the add new record button, he...

I need some help, I need to create a form that when a user wants to enter a new record, the id will be based on what type of record they are adding. For example, there is a list of training courses (A-##, B-##, C-##) where the ## is the training course incident. When the user wants to add a...

Thank you, that worked.

I have a form with 2 combo boxes, the first box is a name selection and the second box lists all companies that employ that name. The cascading part of the combo boxes works great. I used the following code on the first combo box, employee name: Private Sub cboEmployee_AfterUpdate()...

Chart properties Right mouse click on the chart in design view and look at the properties. click on the row source property to view the SQL statment, click again to view the datasheet for this SQL statement. Put your sorting criteria on this query and your chart should now be sorted the way...

Reports in a List Box I found a post to show me how to list my reports in a list box on my filter form, but I don't know how to change the code to use that report. Can anyone help? ' Build criteria string for Report field strDocName = Me.cboReport.Value ' Apply the filter and switch it...

I have a form that asks the user for some report filters (Customer, Year). And I would like this filter form to be used on about 20 reports. I was hoping if someone can tell me if there is a way to allow the user to select the report to filter on. I am using the following code to execute the...

Solution Thanks for letting me post! I have figured it out and wanted to give the solution in case anyone else has a problem. On the properties of the chart in the Link Master Fields and Link Child Fields I am able to enter in multiple fields separated by semi colons. I was using the logical...

I am new to access applications and I have created about 10 reports, each contains a column results, bar chart and pie chart. The column results works great, the filter option is turned on for 2 fields in the report and the results filter correctly, then I created the 2 charts based on the same...