Search results

  1. W

    saving BLOBs/files in sql backend via pass through in vba

    THanks a lot, thats what my gutt feeling told me, too, but its a relief to hear that from an expert. Cheers
  2. W

    saving BLOBs/files in sql backend via pass through in vba

    Hi, I would like to store a field/image etc in a back end sql server via pass-through. The problem: as I understand pass through, I have to format everything into string or at least parts of strings. How can I just concentrate on bytes and have that sent over to the sql server? I understand...
  3. W

    linked Excel Chart distorted in Acc07

    Done that, doesnt change a thing :( I used zoom, stretch, clip ... you name it. but thanks :)
  4. W

    linked Excel Chart distorted in Acc07

    Hi, I have an excel 07 chart dynamically linked to an form-OLE field. This used to work smoothly in earlier access vesions. Now, the chart shows somehow distorted, as if it has been stretched. I do use SizeMode = acOLESizeClip If you compare the original excel chart with thelinked one, the...
  5. W

    some hyperlinks dont work

    The property .HyperlinkAddress is set to a valid url, which upon click normally opens the preferred browser of the PC with the correct page. Just for these two PCs, the message appears. BTW, this seems to happen for every URL in this access application at these PCs.
  6. W

    some hyperlinks dont work

    Hi, I have a form with hyperlinks that are inserted into a transparent button via code. The application is distriubted with a run time version of Acc97 This seems to work fine on several installed PC (application running on about 60 PCs now), but on 2 PCs it does not work. I get the message...
  7. W

    assigning user-structured types as a whole

    Yea, makes sense. I am happy if the assigning of structure types is not crating havoc, to thats fine with me. Thanks for the detailed information :)
  8. W

    assigning user-structured types as a whole

    Well, it got me concerned that I cannot pass a structure like by val. For the above example: sub dosmethingweird(byval a as structtype) wont compile. This indicates for me that there is something iffy about assignin user defined types. In reality this byVAl would not be anything else the a =...
  9. W

    assigning user-structured types as a whole

    Hi, I have missing knowledge/a problem Can I assign one variable of a user defined type to another of the same type? Passing by value in a procedure does not compilet, but if I do this: public type structtype a as integer b as integer c() as string cCount as long end type dim a as...
  10. W

    Pixel value of image in Access form imagebox, GDI32

    Hi, I try to read out pixel values (rgb) from a pciture box in an access form. I have found that there is a picture box in plain vb, but this seems not to translate to the picture in an access form. I did try with Declare Function GetDC Lib "user32" (ByVal hWnd As Long) As Long Declare Function...
Top Bottom