Search results

  1. speakers_86

    Access data in Acrobat Form

    I see two options. One is to find a way to convert the pdf to a jpg, create a report in Access, and use the picture property to reference the jpg. Then just align the controls so they 'fill in' the pdf. The other way is to have Access create an xfdf to fill the fields. I was messing...
  2. speakers_86

    Installer

    This is a stand alone utility that will -relink the shared front end to the back end -copy the shared front end to the local hard drive -create a shortcut to the local front end on the desktop -create a shortcut in the start menu to the local front end Tested in x86 and x64. Not overly...
  3. speakers_86

    Anyone using Microsoft Edge?

    Windows 10 is okay, 7 might still be better. The most recent version of Explorer isn't terrible, but I'm still a Chrome fanboy. Firefox was only ever good because it was better than the old Explorer and Chrome wasn't out yet. I have no intentions of considering Edge.
  4. speakers_86

    Locked Down Database

    You might like the startup form I posted in the samples. It gives you a GUI for database properties you can get too easily.
  5. speakers_86

    Detect broken backend connection at startup

    When I do this, I also try to write to a text file on the shared drive to test for read/write access before even connecting to the backend. If that routine fails, I give the user the option to relink to a new backend (which triggers the test again) or quit entirely.
  6. speakers_86

    Auto resize the datasheet form

    There is a value you set the width to which tells Access to automatically size it based on the data. I believe the value is -1 or -2. I don't remember.
  7. speakers_86

    How to reference control on Main form from query

    Try this: forms!fStartForm.[fAll Valid Workorders Owing Money].form.WorkOrderID The fAll Valid... form exists as a child of the parent form, not as an object in the forms collection.
  8. speakers_86

    Spit Form Datasheet Font Size Not Changing

    I've got a sample here that duplicates the split form while only using a subform. I'll be posting an update soon to fix a couple things.
  9. speakers_86

    Reuse code?

    I mostly have two modules, one called 's' and one called 'g'. The s is for specific, and only contains code that is just for that database. The g is for generic, and can be safely used in all of my databases. I also have a module called 'backend' which contains all of the functions I could...
  10. speakers_86

    References for VBA Project across Office versions

    Late binding is always a good idea. Early binding may not work across different computers. It's unfortunate, but that's the way it is.
  11. speakers_86

    Users in DB?

    I've seen a sample that is able to read the backend's record locking file and tell who is using it. Would it help if I linked to it? I'm not sure if this is okay to do though...
  12. speakers_86

    Dispaly Calendar

    I don't recommend activex controls unless this project is just for you. Other computers that control might not be available or in the same place.
  13. speakers_86

    Getting file sharing lock count exceeded error

    I think I missed something, I thought you all determined this was being caused by the records being released asynchronously. Is that not the verdict anymore? I was just about to go and add a timer to allow records to get released, but now I'm not sure.
  14. speakers_86

    Getting file sharing lock count exceeded error

    Thanks for this. I have this issue too, but never got around to troubleshooting it.
  15. speakers_86

    Aligning the tick boxes in a report

    Once you do that you will probably want to use align left or align top to get them aligned perfect.
  16. speakers_86

    Pre-FE db delivery Checklist

    Perhaps this will help you. It brings all of the properties front and center and gives you a hotkey to get back to it.
  17. speakers_86

    2010 db won't run on 64 bit installation

    Don't use call. Just do: Scroll Me, Count Me is the form, you are passing the form itself to the scroll sub routine. Count is the argument provided in the mousewheel event. Also, if you are making mde, you will need to create the mde twice, once using 32 bit office, and once using 64 bit...
  18. speakers_86

    Question related to speed of light.

    That's what is great about theoretical physics. Nothing is really set in stone! There is a theory called the variable speed of light (VSL) that says the speed of light varies over great periods of time (too large to really measure directly). It doesn't have much support, but if correct, it...
  19. speakers_86

    Embedded Bitmap Images

    Don't embedded images cause the database to grow over time though? I thought there was some quirk to access caused the database to inflate for no good reason.
  20. speakers_86

    Embedded Bitmap Images

    Even for the bitmap images? I feel like since they are baked into the program it shouldn't matter if I embed them. I'm talking about the Picture property for command buttons. They have those tiny images of arrows, record navigation, and so on.
Top Bottom