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

    need to use vba to change a property to table data

    Hi,



    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
    Location
    The Great Land
    Posts
    52,815
    What activex object is involved? Regardless, I doubt this can be done.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 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
    Posts
    2
    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