Recent content by speakers_86

  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.
Top Bottom