Search results

  1. speakers_86

    Obsolete objects in database

    I think it's best to just leave it alone. If you really want it gone, make a backup first, then delete the items. Do plenty of testing afterwards, too. Probably a good idea to decompact and compile afterwards, too.
  2. speakers_86

    Relationship not working

    I don't even like using the relationships. I think it just gets in the way.
  3. speakers_86

    Strange problem with MS Access 2010 Date Picker

    Thanks to this post I got a work around: https://bytes.com/topic/access/answers/942767-calendar-not-working After the offending code runs, I am setting the focus to the control with the date picker. That's it! I guess it's just some weird glitch in the picker itself. Hopefully this helps the op.
  4. speakers_86

    Solved Access 2010 Object Navigation Pane size stuck very narrow - won't resize

    I have a form that can replace the navigation pane. It is posted in the sample databases.
  5. speakers_86

    Strange problem with MS Access 2010 Date Picker

    So I narrowed it down. I commented all of the form's code and the issue disappeared. I narrowed it further to my resize event. There is a block that sets the column order of all the controls that is causing it. I can't tell why, maybe just corruption.
  6. speakers_86

    Strange problem with MS Access 2010 Date Picker

    I'm seeing this issue too. There is no after update event nor a mask.
  7. speakers_86

    Unactivated Office Breaks Ribbon

    Does anyone know why an unvalidated Office installation would not invalidate the ribbon? I'm working on getting Office validated, so this issue will get fixed, but I'm curious why I'm having a bunch of bugs in the ribbon only when Office is not validated. It seems like the invalidate command...
  8. speakers_86

    Slow report creating after x reports

    That sounds like a temporary solution. I think you should keep investigating this.
  9. speakers_86

    Test Write Access to Backend Path

    This will test all backend path locations for write access. If write access is denied or the medium is unplugged, there will be an error. It does not in any way relink tables. This is intended to be done before checking the table links, just to make sure the permissions are correct. If the...
  10. speakers_86

    Slow report creating after x reports

    Why are you declaring all of these as functions? A function should return an answer, and I don't see these returning anything. Try changing them to sub. I doubt that is your issue, but it isn't great practice, especially since the missing result is a variant since you didn't declare the data...
  11. speakers_86

    Slow report creating after x reports

    I suggest commenting out some of the code to narrow down the issue.
  12. speakers_86

    Navigation Form

    This is a duplication of the old database window. Just import it into your project and enjoy. Use the keyboard for quick navigation and the find button to locate the selected object in the navigation pane.
  13. speakers_86

    Generate pdf and save it to the database

    I don't think attachments increase the size of the backend, though I couldn't explain how that is possible. I did some testing on this sometime ago, and it seemed like that was what I saw.
  14. speakers_86

    Generate pdf and save it to the database

    There is no need to store it in the database. Just create a folder in the same place as the backend and store it there. It's super easy and IMO, more transparent. You can get the backend path easily by querying a system table, I think it is the MSysObjects table.
  15. speakers_86

    Are you an atheist?

    What is your point Access Blaster? Because we can't explain it the bible is right? I'm content not knowing everything, but I will strive for it anyway.
  16. speakers_86

    Are you an atheist?

    There is nothing wrong with proving a theory wrong, that is what makes the science so great, is that it is self-correcting. Over time, it becomes closer and closer to being correct. I believe that we cannot know everything there is to know. I once read that there is a theory that we cannot...
  17. speakers_86

    Access Application Icon in the Windows 10 taskbar

    Actually for my laptop I do have to do this, but on PCs where the app is actually in use, I do not have to do this. I'm not sure what is different.
  18. speakers_86

    Access Application Icon in the Windows 10 taskbar

    This is post number 9 from here. However, for me the path to Access was different.
  19. speakers_86

    VBA form that relinks tables

    http://lmgtfy.com/?q=JStreetRelinker
  20. speakers_86

    VBA form that relinks tables

    http://www.jstreettech.com/downloads.aspx
Back
Top Bottom