Results 1 to 3 of 3
  1. #1
    SolmarDiotozou is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2014
    Posts
    1

    About Dynamic TextBox

    Hi:


    This is my first posting on the forum. Please be patient with my grammar because it is not very good. I will try to explain my problem as best as possible.


    I'm not very good with Access and have never programmed in VB, but I program in ASP, PHP, JavaScript, so I have some judgment and intuition with programming languages​​.


    I have a form and I need to create text boxes dynamically. The amount will depend on the number of rows returned from the query made ​​previously. If the query result gives 10 records, then I need to create 10 text boxes, one for each record. I need this because I want allowed the data editing using the form I'm creating.


    The way I use it to run the code is when the focus of a particular text box is lost. I've managed to run some code when the focus is lost, so I just need to know how to create text boxes dynamically.

    Thanks for all. Sorry my grammar
    Regards from Lima, Perú

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    To view/edit 10 records would NOT require 10 textboxes on form, only one textbox. The textbox will replicate itself for however many records are retrieved by the query. Have a control for each field in the query, not each record.

    Building form is basic Access functionality. You might get an introductory tutorial book and go through it before continuing development.
    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
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    I understand that English is not your native tongue, but you need to explain this:

    I need this because I want allowed the data editing using the form I'm creating.
    Is this supposed to mean

    'I want to allow the data to be edited using the form'

    or

    'I won't (will not) allow the data to be edited using the form?'

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 2
    Last Post: 01-08-2014, 05:18 PM
  2. unbound textbox to bound textbox
    By thescottsman92 in forum Access
    Replies: 3
    Last Post: 08-29-2013, 02:02 AM
  3. Replies: 2
    Last Post: 04-20-2013, 03:37 AM
  4. Replies: 8
    Last Post: 04-12-2013, 08:59 PM
  5. Replies: 17
    Last Post: 02-08-2012, 10:06 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