[AccessD] Requery on setting row source or record source

Rocky ... spell out how you did that.  Never occurred to me to do but a
great idea.  There seem to be too many CHM files to copy over.

Stephen Bond
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Thursday, 13 December 2007 7:15 p.m.
To: Stephen
Subject: Re: [AccessD] Requery on setting row source or record source

I actually loaded 97 Help along side later versions of Access, because
it
was so much better than the subsequent help files.   

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Wednesday, December 12, 2007 2:11 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Requery on setting row source or record source

Quite so. But I'm damned if I could find that in the XP help. Access 97
help was much more helpful! :-)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Wednesday, December 12, 2007 4:25 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Requery on setting row source or record source


acDataErrAdded Doesn't display a message to the user but enables you to
add the entry to the combo box list in the NotInList event procedure.
After the entry is added, Microsoft Access updates the list by
requerying the combo box. 

Microsoft Access then rechecks the string against the combo box list,
and saves the value in the NewData argument in the field the combo box
is bound to. If the string is not in the list, then Microsoft Access
displays an error message. 

Private Sub Colors_NotInList(NewData As String, _
        Response As Integer)
    Dim ctl As Control
    
    ' Return Control object that points to combo box.
    Set ctl = Me!Colors
    ' Prompt user to verify they wish to add new value.
    If MsgBox("Value is not in list. Add it?", _
         vbOKCancel) = vbOK Then
        ' Set Response argument to indicate that data
        ' is being added.
        Response = acDataErrAdded
        ' Add string in NewData argument to row source.
        ctl.RowSource = ctl.RowSource & ";" & NewData
    Else
    ' If user chooses Cancel, suppress error message
    ' and undo changes.
        Response = acDataErrContinue
        ctl.Undo
    End If
End Sub
    

Regards
Max
(From the help page 'NOTINLIST')

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Wednesday, December 12, 2007 9:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Requery on setting row source or record source

Just remember, if you are using a NotInList routine to add items to the
Combobox rowsource, you will need to requery. 

Charlotte

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Wednesday, December 12, 2007 11:39 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Requery on setting row source or record source

Thanks Charlotte.  Commenting out all them extraneous requeries now.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Wednesday, December 12, 2007 10:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Requery on setting row source or record source

If you set the source through code, you shouldn't need to requery.  You
need to requery when the values in the current list change.

Charlotte Foust 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.17.1/1181 - Release Date:
12/11/2007
5:05 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com