Search results

  1. J

    Opening/Saving Images To DB With VBA

    I want to be able to import images into my database. I have been successful in setting up an OLE box that allows me to copy&paste an image into the field. However, I have not been able to save that image to a database via ADO. I have been trying to save it like I would save text: Dim con as...
  2. J

    Me! or Me. ???

    Hello everyone, I had been using Me.[etc] for a long time before showing my code to another person who said I should begin using Me![etc] instead. I have changed over and began doing this, but I am unsure what benefit this has. The only thing I did notice was that the names don't autoexpand...
  3. J

    Saving Pictures To An OLE Field Via Code

    Hello, I have a form where all of the data is saved via VBA code. On that field is a place for a picture to be displayed. The picture is displayed by users copying a picture to the clipboard, and then clicking the "Paste Picture" button on the form. My problem is when I try and save the...
  4. J

    Preventing Pasting Into A Field Or Form

    (Sorry for posting this to both Forms and VBA. It's my first time using this website and I missed VBA.) Hello everyone, I am trying to figure out a way to PREVENT users from pasting information from the windows clipboard into a field, or into the form altogether--whichever is easier. I...
  5. J

    Preventing Changes To A Field Containing Information

    (Sorry for posting this in two places--Forms and VBA--it's my first time on this website and I missed the VBA function.) Hello, I am curious how to prevent changes to a field after that field has had data entered into it. I tried: Before Update If IsNull(Me!User) Then MsgBox "This is...
  6. J

    Preventing Changes To A Field Containing Information

    Hello, I am curious how to prevent changes to a field after that field has had data entered into it. I tried: Before Update If IsNull(Me!User) Then MsgBox "This is allowed" Else MsgBox "This is not allowed" Cancel = True End If I figured that until the User field had the value saved...
  7. J

    Preventing Pasting Into A Field Or Form

    Hello everyone, I am trying to figure out a way to PREVENT users from pasting information from the windows clipboard into a field, or into the form altogether--whichever is easier. I need both the Menu>Edit>Paste and Ctrl+V functions to be disabled. I have thought about comparing the...
Back
Top Bottom