Advertisement

05.01.2008 at 08:45AM PDT, ID: 23368979
[x]
Attachment Details

Trouble accessing bookmark array to get the recordset offset...

Asked by burtonrhodes in Access Coding/Macros

Tags: VBA, ACCESS, Wrong number of arguments or invalid property assignement.

I am trying to figure out how to gain access to the bookmark array with the code below.  It keeps giving me an error (Wrong number of arguments or invalid property assignement) and I know it is an array by looking at the variable in the "Add Watch" and Ubound function.  
Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:

' See if we can find in the current record source
    Dim rs As Recordset
    Set rs = Me.Recordset.Clone
    rs.FindFirst "TRANSACTION_ID=" & Me.cboFindOpenTransaction
    If Not rs.NoMatch Then
        MsgBox UBound(rs.Bookmark) '<---- This display '3'
        DoCmd.GoToRecord acDataForm, Me.NAME, acGoTo, rs.Bookmark(0) '<--------- This gives error
    End If
[+][-]05.01.2008 at 12:50PM PDT, ID: 21482032

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Access Coding/Macros
Tags: VBA, ACCESS, Wrong number of arguments or invalid property assignement.
Sign Up Now!
Solution Provided By: omgang
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.01.2008 at 12:55PM PDT, ID: 21482082

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.01.2008 at 02:26PM PDT, ID: 21482887

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.04.2008 at 09:32AM PDT, ID: 21496143

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 06:51PM PDT, ID: 21529926

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628