Search results

  1. cardgunner

    Hidden from view unless toggled

    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...
  2. cardgunner

    Hidden from view unless toggled

    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.
  3. cardgunner

    Open form go to new record

    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.
  4. cardgunner

    Open form go to new record

    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
  5. cardgunner

    Open form go to new record

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

    Open form go to 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...
  7. cardgunner

    show all the records or specfic records

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

    show all the records or specfic records

    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?
  9. cardgunner

    show all the records or specfic records

    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...
  10. cardgunner

    labels in your text box

    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...
  11. cardgunner

    labels in your text box

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

    labels in your text box

    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.
  13. cardgunner

    New Record On Top

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

    labels in your text box

    Can you do a conditional format of a label?
  15. cardgunner

    labels in your text box

    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.
  16. cardgunner

    labels in your text box

    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...
  17. cardgunner

    New Record On Top

    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.:)
  18. cardgunner

    New Record On Top

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

    New Record On Top

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

    New Record On Top

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