Search results

I have a main report that has many subreports. For some reason it's sometimes splitting the data in the subreports onto 2 pages eventhough I have it set to Keep Together. For example, this will be on one page: Specie: Skeletonema Duration: 72 hrs and this on the next: Effective...

Thanks! It worked! :)

I was wondering, Ok, I have a command button that, when clicked, opens a report that is filtered based on the product name in the combo box beside it. Is there a way to email this report based on what is selected in the textbox? For example, could I have an email button that opens the report...

Thanks! It works great. I knew it was something simple like that. :D

Quick question: I would like a message box to appear when the user clicks on a product in the list box that's more than 3 years old. I would also like the the log-in date txtbox to be highlighted if it's more than 3 years old. I know I have to do this in code, but I can't figure out how to do...

Thanks Thank you so much! I don't know why I didn't think of that. It's been a long day. :p

I was wondering, is there a way to shade duplicates in a query? I have a database that contains product formulations. When queried, all the products are listed along with their components like this: Product A Methanol 67% Product A Water 23% Product A IPA 10% Product B...

Thank you so much! I knew it was something simple. :p THanks again!

I ran into the same problem. The data was listed on the report in a different order than how it was entered on the form. It was suggested to me that you add an autonumber to the table that your subform is based on. It was also suggested to use a time-date stamp. I used the autonumber...

Just one more question......... I switched they way we are going to do things. Instead of a blank, it will be filled in by an X, since not every product needs every test. How do I get the product code to be highlighted if there is an X in the same row (alerts users that there is an unfinished...

Thanks Thanks! This will work! :)

I have a quick question - I need to highlight empty fields (no entry = Color). How do I do this? I have tried Conditional Formatting, but it doesn't want to work unless I type NA into every blank space. Is there a way around this? I will be working with a very large table that has MANY blank...

I think this is going to work! I puts it in the order it was entered. Some of the data doesn't go in numberical order (23, 24, 25, 2236, 2237, 26) on the report. But when I check on the form it is the same as the report. Is this because on some products I went back and added data after i had...

ok, your suggestions would work if we were entering new data into a new database. This database has been around for a few years, with about 2,000+ entries already and i don't want to re-enter them all!! any other suggestions on how to solve this problem? Thanks!

Thanks! Thanks guys! I think this is going to work! :)

Ok.......How do go about doing that?

I don't think any of those suggestions will help me (sorry!). I need my Report to look like this: Lethal Concentration 50%, 24 hrs 86.2 Lethal Concentration 50%, 48 hrs 75.6 Lethal Concentration 50%, 72 hrs 70.1 Lethal Concentration 50%, 96 hrs 65.3 Lethal Concentration 100%, 96 hrs...

I am having a problem with my report. What I need the report to do is print the results in the same order as they were entered on the form. Right now it wants to put them in whatever order it wants (I do not have them grouped). I could group them and have then ascending, but that still puts it...