Search results

  1. D

    Database Properties: Statistics

    What's up with the Statistics Tab under Database Properties? 1. Why does "last saved by" and "revision" show up blank? Is there any way to make use of these? 2. Is any of the info on this tab available from VB? Even just read only? I'd love to have the "modified" field show up on a form...
  2. D

    Closing one instance of a form

    Sorry, my mistake. RemoveInstance is basically the code shown in the form close event. Yes, I realized that about Form_Close about 5 minutes after I posted... duh! Anyway, just having my button call the Form_Close event seems to work fine.
  3. D

    Closing one instance of a form

    I am using Allen Browne's code http://allenbrowne.com/ser-35.html to open multiple instances of a form. I have a button on the form which does: And in the on-close event I have: (see the link to see what RemoveInstance does) However, when I use the button to close a form instance, the...
  4. D

    Calling a form from a referenced db

    Hi, I have a form, frmHidden, a copy of which currently resides in the frontend of each database I manage. The autoexec of each database opens this form in Hidden mode. The form contains a timer event that does various things, such as check for inactivity. (I've been using this for years with no...
  5. D

    Can't link to .jpg

    I am trying to link to a .jpg file using This works fine if mypath is a pdf or a bmp. A few days ago it also worked fine if mypath was a jpg, but now suddenly for jpg files, I get "a problem occurred while accessing the ole object". What could have changed? Mycontrol is an unbound object...
  6. D

    Multiple instances of a form

    Thanks, I think the select case method will work OK for me, although I would rather not have to update the select case every time I add a new form. I am not sure I understand the other method but will give it a closer look. Should it allow me to set things up so that the name of the form is a...
  7. D

    Multiple instances of a form

    I need to open multiple instances of the same form, and am using Allen Brown's method from http://allenbrowne.com/ser-35.html However, I want to feed a variable into the New Form line. For example, his code looks like this: But I want my code to be something like: I thought I could just dim...
  8. D

    Export OLE pictures to .jpg files

    I have no way of knowing for sure. I assume probably just using the Access method of right-clicking on the field in the table, and following the Access instructions.
  9. D

    Export OLE pictures to .jpg files

    Okay, I have found a semi- useful article at "support.microsoft.com/kb/103257" This shows how to copy a file into the ole field, and then re-export that same file. That workrs fine. However, when I use this to export the existing files in the table, they are all unreadable. I've tried...
  10. D

    Export OLE pictures to .jpg files

    In datasheet mode the entries are: microsoft photo editor 3.0 photo or ms_clipart_gallery.2 I am trying to make my way through the BLOB search stuff. Any additional info would be great. I am really trying to figure out what is the best way to handle image data. I have forms that contain work...
  11. D

    Export OLE pictures to .jpg files

    Hi, I have inherited a table with an OLE field that stores pictures. The entries in the field look like this: microsoft photo editor 3.0 photo or ms_clipart_gallery.2 I want to export these pictures to .jpg files. How do I do this? Thanks for any help you can supply!
  12. D

    Autoactivate an unbound object on a form

    Oh, I just figured it out. For some reason, the bound object default setting is enabled=no, locked=yes. ONce I changed this it works fine.
  13. D

    Autoactivate an unbound object on a form

    I have a form with an unbound object frame that contains a link to a jpg file. The object's properties are set to: source doc= {the jpg file} ole type=linked display type=icon auto activate=double click So, i thought that when I double-clicked on the icon in the form, the jpg file would open...
  14. D

    Using PrinterCapabilities Class from litwin-getz-gunderloy

    i want to reiterate that this is not actually a ms access issue but an excel issue. i have figured out how to control the trays in access: from the info that frmdevcaps supplies, you use the tray ID # rather than the names. but i cannot find any way to get to the tray settings through excel vba...
  15. D

    Combo Box auto-fill too soon!

    I am using Access 2003, SP3. I stress that this is intermittent behavior. Had this problem this morning. Now it's gone.
  16. D

    Combo Box auto-fill too soon!

    No, it doesn't go to Alice. It fills in "Alan". I have had this happen intermittently. I have changed nothing in the design. It's maddening!
  17. D

    Combo Box auto-fill too soon!

    The combo boxes on my form intermittently start auto-filling to soon. For example, I have the following in the list for the row source: Alan Alexis Alice But as soon as I type "AL", it fills in with "Alan". And the only way I can get to "Alice" is to scroll down the drop down list and choose...
Back
Top Bottom