Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 31
  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    No. Subform/subreport container control is component on a form or report. Like a textbox or combobox you create one by selecting the tool from the ribbon Design tab and click on form to create control. Select the subform/subreport tool and click/drag to create a box on the main form. This creates the container. Now set the ObjectSource property of the container to the object you want it to hold (table, query, form, report). Just as demonstrated in the video. You must understand that a subform is constructed with a container control that holds an object. I have already described and the video demonstrates how to select a container control already on a form. I suggest you review the video again and other tutorials if needed and reread earlier posts. I cannot help you any further until you understand how a subform is built.



    The code you show in first post is setting form recordsource to display records that meet filter criteria. If only one record meets the criteria then that is all that will show on the form.
    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. #17
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Hi June7. Sorry for my stupidity. Hmm. BTW. I already change the Subform Container Name as you said on post #8 and I also did the code that you putted on it. But still it shows me the same result?

  3. #18
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Let me show you sir.

    • Here's the code.

    Figure 1
    Click image for larger version. 

Name:	code.JPG 
Views:	6 
Size:	71.8 KB 
ID:	6814

    • In access which I think I rename the container name.
    Figure 2
    Click image for larger version. 

Name:	db.JPG 
Views:	6 
Size:	174.4 KB 
ID:	6815

    • When I click Form View. All records will appear which is Okay.
    Figure 3
    Click image for larger version. 

Name:	run.JPG 
Views:	5 
Size:	157.2 KB 
ID:	6816

    • When I search without inputting a value. This is what happen which is wrong because in my first project with the same use/function like this. It will show me all the records when I don't put any value in the textbox. (FIGURE 3)
    Figure 4
    Click image for larger version. 

Name:	searchNULL.JPG 
Views:	6 
Size:	116.1 KB 
ID:	6817

    • When I put a value on the textbox this is what happen which is also wrong. I input a Card Number which is not a Card Number of Jingu Anita(who's always appearing when I search NULL value) and this is the result.

    Click image for larger version. 

Name:	searchcardnumbernotsamewithjingunita.JPG 
Views:	3 
Size:	109.9 KB 
ID:	6818

    what I think on what's happening is that Jingu Anita is the only one that my system can identify. hmm can I ask again what's wrong? Sorry for being a noob sir. Please be more patient. Thanks

  4. #19
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Okay, looks like you got all the edits I described. Something must be happening in the BuildFilter function. Step debug, follow the code as it executes one line at a time. Check the value of variables, like the reference to Text16. Find where behavior deviates from expectations, fix, run, debug, repeat.
    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.

  5. #20
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Okay sir. I'll do what you said. But I would like to ask some question. On the database that you edited, does it RUN like that? or different? Thanks!

  6. #21
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    The edits I suggested work fine for me. Here is the file. See if you can figure out why yours is working wrong.

    EDIT: Purpose served, file removed.
    Last edited by June7; 03-22-2012 at 04:31 PM.
    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.

  7. #22
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Thank you. Still figuring out, but I can't see what's wrong. Line by line I've checked it.

  8. #23
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    You could now send me yours and I will try to find the difference. The one I sent is working for you?
    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.

  9. #24
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Yes, the one that you send to me is working and great!
    https://www.cx.com/mycx/files/my-files/InstantCard2.zip

    here's the link bro.

  10. #25
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48

  11. #26
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Neither of those links will work for me. Box.com has never given me any problems.
    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.

  12. #27
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    oh I see. I'll get back into this sir June when I got home.

  13. #28
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    Hi June7 I just noticed this query table on the navigation pane on the one you've worked. Please see and I would like to ask if what is the use of this query? Thanks!

    Click image for larger version. 

Name:	eeeeeeeeeeee.JPG 
Views:	6 
Size:	175.2 KB 
ID:	6919

  14. #29
    spideynok is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    48
    BTW I'll provide the database as soon as I got home and uploaded it to box.com.

  15. #30
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I don't know why it's there. Don't remember creating it. I opened it and there are no tables/queries in the SQL. Don't know how could have been saved. Searched VBA and no reference to it.
    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 2 of 3 FirstFirst 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search Button in a Form
    By spideynok in forum Forms
    Replies: 14
    Last Post: 03-18-2012, 10:08 PM
  2. Button to search table with any field in form
    By sephiroth2906 in forum Forms
    Replies: 3
    Last Post: 04-19-2011, 11:17 AM
  3. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  4. search button on Form
    By josejuancruz in forum Access
    Replies: 1
    Last Post: 12-23-2010, 07:21 PM
  5. Replies: 3
    Last Post: 01-14-2010, 08:32 AM

Tags for this Thread

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