Recent content by pinkpoppy

Hello, I have a search form. The search form has a combobox and a subform. When a user selects from the combobox (they select a supplier code), the subform will display the the searched results. In the subform, users are allow to add new records. When the user add a new record, the supplier...

Just an update, I was able to solve my issue with the sample above, thanks!

Thanks! The combo box and the subform is both on the main form. Do I need to put the code behind the export button?

Thank you for the suggestion. I've tried your suggestion and ran into an issue. I implement the code behind the command for the export button correct?

Hello, I am modifying a database that was created by someone else. The database has a form which a user can choose from a combobox and the result is then display in a subform. Combobox1 has a query behind it. when the user clicks on it, it shows in the dropdown the available last,first name...

I have a formula that is counting a field, but it is also factoring the 'details' section when I insert a field. How do I stop the formula from not factoring in the details section and only count and display one the field I need?

thanks! it is displaying the right number now.

It is counting the total number of records there are instead of 9 that I need.

Yes, but it is not getting the right count.

I have a report displaying by groups, but I need the total count of records displayed. Example data: Group 1: State Group 2: Last Name NM Smith NM Benson GA Richardson GA Floyd GA...

How can I write a formula that uses the range operator and also a parameter value? For example, I need a crystal syntax formula that checks to see if a database field of 1 - 12 has a parameter value of 11. Something like this if it is possible: if {tablename.field} in (1 to 12) = {Parameter...

I am doing a survey of a group of people for a special demographic research. I need to find what age is missing from this group. I need to display from 2 different tables: Table1 has the "RACE" field and Table2 has the "Age" field. For example, my report current display as follows for year...

This is an example of my database. We keep track of how customers pay for products that are on a monthly basis. Customers are required to pay every month. I need to find which State, Customer(s) have not paid for a certain month. This report will need to run every month, so I will enter...

I have an item array: A600 I need to increase it by 1 (A601). How do I increase it and have it shown in a textbox? Thanks

Thank you so much. Works great!