Results 1 to 8 of 8
  1. #1
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48

    update / load a form / subform / or another object, similar to the code "requery", does anyone know?

    Hello, very use the function "requery" to update data from a form / subform, or other object, the problem is that this function shakes the form,
    there is another better, similar function?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I don't understand your post. How about describing your set up? What are to trying to do? What is the issue? Do you get an error number and description?

  3. #3
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48
    I need a function, such as the "requery", which updates the data in a subform, like the "requery". The "requery" shakes other objects.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Requery is a method that can be used with form or listbox or combobox.

    The syntax depends on where the method is called from. You will have to provide more information about the form/subform setup and what is happening that you think requires Requery method.
    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. #5
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48
    thaks, but there is another code similar to "requery"? No other way to upload (update) data from a "subform"?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What in the world do you mean by 'upload' from a subform? How can we offer suggestions if we don't know what you are doing? You will have to give explicit details.
    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. #7
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48
    ok, two users registering for the network at the same table, then to instantly load the data to a user, use the "requery", and I wonder if there is another way to load this data, because the "requery" lock (moves very) much the form (subform or other control). I want to know if you have another way to load the data instantly, without being by the "requery"

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Appears to be a thick language barrier here. I can't make much sense of your statements.

    I still don't know what you mean by 'load' nor why requery is needed. Do you want another form to open?

    What does 'registering for the network' have to do with opening a form and showing data?

    Is this a split design 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.

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

Similar Threads

  1. Error: "Cannot update. Databse or Object is read-only" Issue
    By excellenthelp in forum Programming
    Replies: 6
    Last Post: 05-10-2022, 04:20 AM
  2. Replies: 2
    Last Post: 09-09-2014, 12:50 PM
  3. Need VBA code/"Class Object" for a bound form
    By kewelch in forum Programming
    Replies: 6
    Last Post: 06-27-2013, 09:26 AM
  4. Writing Code for "After Update" Table Events
    By dipique in forum Programming
    Replies: 10
    Last Post: 07-09-2012, 08:11 AM
  5. Replies: 0
    Last Post: 01-11-2012, 12:34 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