Results 1 to 3 of 3
  1. #1
    klingoncowboy4 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011

    need to use vba to change a property to table data


    I am currently working a a Junior IT and am new to Access and databases in general. I have been tasked at finding a way to integrate an activex object into our database.

    What I am trying to do is have it so that when we load a report the object is autmatically populated with the relevant data from a table. Unforunetly this particular control does not have a "Control Source" property, otherwise I would just modify that. I have successfully made it so that I can change the property of the object in question using vba. What I would like to know is if there is any way I can have vba insert table data, much like I would do using "control source" (if it were available).

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    What activex object is involved? Regardless, I doubt this can be done.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    klingoncowboy4 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    it is a custom built controller for doing QR Code generation. I have already contacted the developer too see if we can get the controller improved. Google has not been much help, there are hundreds of examples for using VBA to copy into a table but not from.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-29-2011, 09:30 AM
  2. change data type in make table query
    By jgelpi16 in forum Queries
    Replies: 2
    Last Post: 01-26-2011, 09:37 AM
  3. Replies: 11
    Last Post: 12-04-2010, 10:20 AM
  4. Change form property with VBA
    By jmk909er in forum Forms
    Replies: 1
    Last Post: 10-20-2010, 08:57 AM
  5. Replies: 1
    Last Post: 08-10-2008, 01:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums