Search results

  1. AccessJunkie

    Hotkeys not working in Access 2010

    Hi Shadow, Yes, this is a known issue we are currently tracking in Access 2010. It seems that when the hot keys are placed on controls inside a tab control, they are not responding. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft...
  2. AccessJunkie

    Hotkeys not working in Access 2010

    Hi, By chance is this button placed on a tab control in Access 2010? -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside Out Access 2007/2010...
  3. AccessJunkie

    Load form on startup in Access 2007

    Hi, Are you saying you no longer want to have the startup form property set? If so, you just clear the property. The entry point is a little different between versions, but it's essentially doing the same thing. Here are the instructions for Access 2007: 1. Click the Microsoft Office Button...
  4. AccessJunkie

    Access 7 Macro error 2950

    Hi, Can you point me to the specific database template you downloaded on Office.com? -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside Out...
  5. AccessJunkie

    Cascading Combo Box Help

    Hi, Here is the short answer to your problem: Your SQL statement is trying to compare string values (Bones) to an ID value. As such, your SQL returns nothing and thus your second combo box displays nothing. Modify your SQL statement to account for the text display value in the first combo box...
  6. AccessJunkie

    2010 web form

    Hi Matt, Glad to help. For your next issue about having a combo box select records on your web form, you might want to start a new thread since this issue is unrelated to your original problem with the Web Display Form property. For your new thread, be sure to include good information on what...
  7. AccessJunkie

    2010 web form

    Hi Matt, No, there is no method by which you can take existing client queries, forms, macros, and reports and convert them to web objects. I'm assuming you are indeed publishing to a SharePoint 2010 Server that has Access Services installed and provisioned. I'm also assuming you passed the...
  8. AccessJunkie

    2010 web form

    Hi Matt, The extra information is indeed helpful, thank you. I believe your issue is that you have not created any web forms in your database. Access will only list web forms in that drop down list since Access Services can only display web-ready forms in the browser. Have you created any web...
  9. AccessJunkie

    2010 web form

    Hi Matt, Can you explain a bit more about your specific issue? Are you saying when you click the drop down of form names in the Web Display Form property, you can't select a different form? Or is your issue something different? -------------------- Jeff Conrad - Access Junkie - MVP Alumnus...
  10. AccessJunkie

    Encapsulate embedded Marco with IF THEN..

    You're welcome, glad to help. I hope you continue exploring the new macro interface and the improvements that were made in this space for 2010. I realize not everyone wants to use macros, but they are much improved in 2010. Also, if you want to create new data macros attached to table events...
  11. AccessJunkie

    Encapsulate embedded Marco with IF THEN..

    Hi, If you select an If block in the 2010 macro designer, you can then click the Up or Down arrow buttons on the right side to move the whole block up/down or inside a different block of actions. You can also use drag and drop with your mouse too. Does that work for you? If not, could you...
  12. AccessJunkie

    Book, MS Access 2010

    Hi, I've had similar reports from time to time. Unfortunately I have no control over how the CD was packaged. In almost every case, I was able to unblock the person and have them install the sample files by navigating to the Sample Files folder on the CD using Windows Explorer, right-clicking...
  13. AccessJunkie

    Book, MS Access 2010

    Hi, I would be silly not to recommend my own book on Access 2010, but the best book for you really depends on what you want to learn about and the type of writing style you like to read. There is a lot of material that can be covered in the Access 2010 product. When you add a completely new...
  14. AccessJunkie

    How to display message if macros are disabled?

    You're welcome, glad to help. Good luck with your project. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside Out Access 2007/2010 Info...
  15. AccessJunkie

    access 2010 navigation form

    I believe I've already helped you on UtterAccess where you posted the same question: http://www.utteraccess.com/forum/Access-2010-Navigation-Fo-t1959532.html -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft...
  16. AccessJunkie

    How to display message if macros are disabled?

    In Access 2007 and Access 2010 you can check the status of CurrentProject.IsTrusted using an AutoExec macro (or perhaps in the Load/Open of a startup form). If it's not trusted, then display a message or perhaps a macro-only simple form explaining what the user must do. For a working example...
  17. AccessJunkie

    Password

    You're very welcome. I'm pleased to hear you found my book useful. Good luck with your continued Access studies. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft...
  18. AccessJunkie

    Password

    No worries Bob, glad to assist. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside Out Access 2007/2010 Info: http://www.AccessJunkie.com...
  19. AccessJunkie

    Password

    To expand on Bob's reply for clarification, compiling your database into a MDE or ACCDE won't protect you from people changing *standalone* macro objects - macros that appear in the Navigation Pane. With MDEs and ACCDEs, users can still open macro objects in Design View, make changes, and then...
  20. AccessJunkie

    Why this simple DATA MACRO is not working?

    Hi Pantera, I'm glad to hear my information was helpful to you. Who would write 1800 pages on Access 2010?? Oh wait.....never mind.... :) There are several good books out there covering Access 2010. Each has their own strengths and weaknesses. It really all depends on what subject matter...
Back
Top Bottom