Prev: How do I save data on a form to my database?
Next: Missing reference when updating from Access 2003 to Access 2007
From: Jack Leach dymondjack at hot mail dot on 19 Mar 2010 05:01
Sorry I haven't gotten back, been a hectic few days, didn't mean to leave you
hanging. Send an email of the file if you like, stripped down with only the
objects required to demonstrate the problem and a handful of records.
Version 2003 or before, I don't run 2007

dymondjack at hot mail com
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"Cpthooker" wrote:

> You mean the button to open the form?
>
> Private Sub Command129_Click()
> On Error GoTo Err_Command129_Click
>
> DoCmd.OpenForm "LeafletDetail", , , , , CStr(Me![LeafletID])
>
> Exit_Command129_Click:
> Exit Sub
>
> Err_Command129_Click:
> MsgBox Err.Description
> Resume Exit_Command129_Click
>
> End Sub
>
> On Mar 17, 3:44 pm, Jack Leach <dymondjack at hot mail dot com> wrote:
> > This means that the OpenArgs are not being sent correctly... did you supply
> > an argument for OpenArgs in the DoCmd.OpenForm line? Can you post that like
> > of the code please...
> >
> > --
> > Jack Leachwww.tristatemachine.com
> >
> > "I haven''t failed, I''ve found ten thousand ways that don''t work."
> > -Thomas Edison (1847-1931)
> >
> >
> >
> > "Cpthooker" wrote:
> > > On Mar 17, 12:48 pm, Jack Leach <dymondjack at hot mail dot com>
> > > wrote:
> > > > Can you tell me what line in particular the error is happening at? When you
> > > > get the message press Ctrl+Break and the code window should come up with the
> > > > line highlighted.
> >
> > > > It sounds as though you may be trying to do this with an empty record (no
> > > > value for the main LeafletID
> >
> > > > --
> > > > Jack Leachwww.tristatemachine.com
> >
> > > > "I haven''t failed, I''ve found ten thousand ways that don''t work."
> > > > -Thomas Edison (1847-1931)
> >
> > > lID = CLng(Me.OpenArgs)
> > > .- Hide quoted text -
> >
> > - Show quoted text -
>
> .
>
From: Cpthooker on 19 Mar 2010 06:13
Sent the file, thanks for your help
First  |  Prev  | 
Pages: 1 2 3
Prev: How do I save data on a form to my database?
Next: Missing reference when updating from Access 2003 to Access 2007