Search results

In my table, the column, or field, that I want to use as the determination of what is displayed is called "IM" and it is a "Yes/No" data type. In the detailed report, the check box that is tied to this field is called [chkIM]. When I change the On Format event to [chkIM], I get the same...

[IM] is a field in the table for which the record is being called up. When I click through from the Summary Report the source for the detailed report is the master table with a filter set by the On Click event from the summary report. I want to turn off a number of items, of which Me.Label75...

Ahh, there it is. Hmm, now the fields show whether IM is checked or not, rather than not showing whether IM is checked. Sure I can do this in a report?

I don't see an On Format event on the list. I guess I should have said Access 2007.

Is it possible to toggle the .visible status of an object in a Report based on the value of one of the fields in the record? I have a report called rptDrillDown which gives the details of a record after being called by an On Click event from the summary report. So far, so good. It's calling up...

Well, I dropped the "+" symbol and replaced it with a Text Box displaying the Study Number, which is the search term anyway. It works now. Thanks for all your help, Paul. Rob

Hi, Paul, I 've tried to implement the code on your page, but I'm running into an error that I can't pin down. Here's what I'm doing: I've created a summary report. Next to each entry in the report I added a small image called "DrillDown" (the plus from Windows Explorer that indicates...

All right, I've been wrestling with this for most of the day... I want to create a summary report with minimal data, and a link on each entry that will open a detailed report for just that line. (This is for Admins who will not have write priviledges to the db so they can't open forms - at...

Unfortunately, not every record is going to need a Work Order. In fact, the majority will have a null here. That's why I have a button to fill it in (the automation is because the tech will likely not know what the next work order number is). Thanks for the tip on the nomenclature. Rob

Almost feel like I'm cheating coming here to ask rather than doing all the research and homework myself... Anyway, I have a button that calculates a value, and I want to then populate a field on my form with that value. I've successfully calculated the value (and have a msgbox to confirm it)...

Thanks, Paul - I have no idea what you just did, but it worked! Rob

Hi, all I'm working on my db for tracking studies. Some studies need a Work Order number and some don't. I'm working on a VBA button that will populate the W/O field with a number one higher than the highest W/O Number on record. Working through it, I've set up a messagebox to make sure...

This is a pre-emptive question. In our organization, most folders are read-only for everyone outside of your group. We have managers outside our group that would like to have access to reports from our study tracking database. I'm going to set up a simple front end with a form with buttons...

That was the trick! Thank you! Rob

Now I've gone and done it. (Let me preface this by saying that I'm working on a copy of my front end, not the original). I have my db start with a particular form that most of the people will be using and it has links to the other forms they need. I went and changed the name of this form while...

That did it. Thanks, Linq! Rob

I have a form where certain items are made visible and invisible as needed by check boxes and buttons. I had everything working just fine. Then I moved everything into a Tab Control so I could have multiple tabs on the page. Now nothing turns on and off as I click the controls. Did moving the...

See, I was right, it was easy! Thanks, Paul

Filter on Checkbox - Resolved I have a Yes/No field (Archive) in my table for archived studies that is tied to a checkbox (chkArchive) on a form. I would like to hit a button (btnActive) and filter out all the records for which that box is checked. Currently I'm calling an On Click event...

Very elegant, and thanks for the quick reply! I was trying to do somthing in VBA, but this works much better for my purposes.