Search results

Access 2007 Download: Access Developer Extensions: http://www.microsoft.com/downloads/details.aspx?FamilyId=D96A8358-ECE4-4BEE-A844-F81856DCEB67&displaylang=en Access 2007 Download: Access Runtime...

Hi Curtis, Here's a little tip to find them. 1. Click the Microsoft Office Button 2. Click Access Options 3. Click Customize on the left side From here you can browse through all the various Ribbons commands. If you'd like to use a specific image for your own button, hover your mouse over that...

You could try my CSD Tools Access add-in. One of the many functions allows you to document the table field names and a few properties. You can optionally export the contents to Word or Excel. You can find my free add-in here: http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html...

Hi Mike, Click the Show All Actions button in the Show/Hide group on the Macro Design Tools tab. (It's a toggle button.) By default, Access 2007 only displays "trusted" macro actions. Clicking this toggle button shows you all 70+ macro actions. In order to run those particular "untrusted"...

I haven't had time to test it quite yet, but hopefully very soon. -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials...

You're welcome, glad to help. Good luck with your projects. -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials...

No problem Bob, glad to help. :) -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html Access...

Sure, you can easily do this. What you need to do is to define a table level validation, not a field level validation. Field level validations cannot reference other fields, but a table validation rule allows you tighter control because you can check across many fields. You need to open the...

Hello FireStorm, I'm interested in hearing about your scenario. Can you describe in a little more detail what you hope to accomplish? Can you describe your application a little bit? Size, complexity, business need, etc? In what way would you like Access to help you here? How do you envision...

Hi Kupe, Microsoft really changed up Access 2007. I like to compare it to a snow globe; they really shook it up big time! You're not alone in seeing an initial decrease in productivity. You will find yourself scratching your head trying to find where everything is for several weeks. Give it...

No, there is no "classic" view switch in Access 2007. -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials...

Hello Vil, I'm interested in hearing about your scenario. Can you describe in a little more detail what you hope to accomplish? Can you describe your application a little bit? Size, complexity, business need, etc? In what way would you like Access to help you here? How do you envision your...

Hi Curtis, If you open the database in Access 2003, is your custom menu bar selected under Tools | Startup? -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft...

Doco, With my recent move I might have lost contact info. Would you mind sending a message to me when you get a moment? Use the contact form on my web site. Thanks! P.S. Sorry for the interruption everyone. :) -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services -...

Hi Curtis, No, that's not quite what I meant. Roy has provided the more specific steps. You need to select your custom menu bar under the Access Options dialog box. After setting it up, you'll see no trace of the Ribbon. -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS...

Doco!! Good to hear from you! :) -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials http://www.accessmvp.com/JConrad/accessjunkie.html...

Access 2007 has seen a lot of changes and in my opinion they've added some cool new features. Don't discount it completely. :) -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter...

Hello Tricky and Kidrobot, I'm very interested in hearing about your scenarios. Can you describe in a little more detail what you hope to accomplish? Can you describe your application a little bit? Size, complexity, business need, etc? In what way would you like Access to help you here? How do...

Hi Curtis, You need to assign your custom menu bar under Access Options in order to see the menu bar in the "classic" state without seeing any Ribbon tabs. -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office...

Hi Dave, You can still lock your database down in 2007 probably just as much as you can with previous versions. As Bob pointed out, if you're using ULS, you'll need to keep the file format as MDB to use those functions. You can create your own custom Ribbons to display just what you want to...