Search results

But you are not able to toggle/expand that section while the report is being viewed if need be. Pretend your looking at the grouped on values or the sum of the values and you want to see what makes up the sum value. So you click a + on the report and it expands to show you the detail of the...

In SSRS 2005 I can specify if a row is visible or not. I can also create a toggle in one of the higher fields to turn the view on or off. It's a +/-. So the deatils is hidden unless you click the + then they are revealed. Does something like this exist in Access.

I did that as well and got the same error. I appreciate your help Bob but I had a saved filter and I went in somehow and deleted the filter or something but it works now. This is the issue with upgrades...you never know where the heck things are. Thanks again.

The data entry is set to no. when I take out stLinkCriteria and leave that line like DoCmd.OpenForm stDocName, acFormDS, , I get a compile error Syntax Error

That is what the command button wizard set. I went in after that and added the command to go to the new record.

I just upgraded to Access 2007. When in 2003 I would open a form and it would go the a new record but the form was not filtered. Now when I open the form it filters it. my Open event procedure is Private Sub Form_Open(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String...

Oh... that is not good. It may work for now but I'll have to keep looking.

That works. Thank you. But I'm puzzled at why it does. I know in SQL it's an or clause such as @prompt='' or fieldname=@prompt. The or makes sense to me it's either all or the criteria specified. Can you give me an example where this wouldn't work?

What is the syntax I need to use in the criteria of a query that will show all the records if I don't specify what the parameter value should be? So If I don't specify what the paremeter should be and just hit ok with the value blank it will return all the records? I have tried to use Like...

Kryst, You are right Mr. B example is pretty awesome. That is the exact look I was wanting. Exactly. But (there's always a but) when I clicked on the record indicator it created new records and in those new records it had the text of the label. However if I "overwrote" the label it didn't. I'm...

No, no, no, I was just trying what was easiest for me first.

I was trying that. Set the default value to "Label". Placed it over the text box. But I couldn't get the formatiing correct. I am using the conditional format tool and not working out. I also set the control source of the textbox/label to the textbox it is going over.

Thanks for all your time and suggestions. Have a good weekend. Cheers.

Can you do a conditional format of a label?

That is almost it. However I want it there untill you click in the field. When you click in the field it goes away. Usally the fony is Italic and Light grey in color. Like a waterwork of sorts.

In a form's text box can you have it labeled in the box, rather then on the side or above it? I have seen this in other applications on the web and such where the text box has it's label in the box. It looks like a watermark. You click or tab to it and it goes away. If you enter something in the...

I'm not sure if the users have that much mental capabilites. And I'm not that good, a novice really, at codes and programming. If it wasn't for this forum I'd be in trouble.:)

However I will want my OP to be able to edit ccertain fields in the history form as well.

Wow, I thought for sure there was a setting for this. I'm surprised.

I want the New record line to be the first record of my form. Is there a way to set this?