Page 3 of 3 FirstFirst 123
Results 31 to 37 of 37
  1. #31
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    You have the table built? Now building form? Yes, need textbox and Image controls on form. Bind the form and bind the controls. That means set RecordSource and ControlSource properties.



    Have you not yet ever built forms in Access database? Creating a bound form is very basic Access functionality. Once the form RecordSource is set can drag fields from the field list to create the bound controls.
    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.

  2. #32
    linda12 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    18
    Ok. I built the form , inserted the code and everything. Now when I type a letter , I get some error like attached .

    It tells either Access doesn't support my image file type or it is too large. My image file type is .jpg and the picture I have inserted is not too large. What could be the possible mistake??
    Attached Thumbnails Attached Thumbnails Screencapture1.jpg  

  3. #33
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Don't know, would have to review the db with your efforts if you want to provide. Follow instructions at bottom of my post.

    How bad do you want to figure this out? Amrut has given you a working solution.
    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.

  4. #34
    linda12 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    18
    Yes I know about that .
    But I am not able to do on my own

  5. #35
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    All you really have to do with Amrut's solution is create the images, name them as suggested, and save them all into the same folder. No table and no embedded images. I simply download and extracted the files and it ran without error.

    However, if you want us to debug your effort with the table approach, provide the db.
    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.

  6. #36
    linda12 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    18
    Sorry for the late reply.

    Yes, I have been using Amrut's solution . It s really helpful. Thanks a lot.

    But I am not able to do that on my own . I tried atttaching the database I have done , but the file size is large .

  7. #37
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I presume db has images in table. Did you run Compact & Repair? Zip the file? Alternative is upload to fileshare site such as Box.com and post link to the file.
    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.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Alphabet autoincrement
    By KWHAT in forum Access
    Replies: 16
    Last Post: 05-23-2012, 08:29 AM
  2. Replies: 2
    Last Post: 02-25-2012, 10:17 AM
  3. Replies: 5
    Last Post: 02-02-2012, 06:42 PM
  4. Cleaning up the alphabet
    By ducecoop in forum Access
    Replies: 4
    Last Post: 10-28-2010, 08:33 AM
  5. Alphabet break in report
    By amccook in forum Reports
    Replies: 8
    Last Post: 08-27-2010, 03:13 PM

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