ACCESS FEED: RE: [MS_AccessPros] Re: Open form using combo box and command button

Rabu, 01 Juni 2011

RE: [MS_AccessPros] Re: Open form using combo box and command button

Kat-

You have this code in the FIND CONTRACT form:

Private Sub Form_Current()

Me.VENDOR_ID.SetFocus

End Sub

Private Sub Form_Load()
If Not Me.NewRecord Then
DoCmd.RunCommand acCmdRecordsGoToNew
End If
End Sub

Neither of those make sense because the form is unbound. NewRecord is failing
because there are NO records!

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
Sent: Wednesday, June 01, 2011 5:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Open form using combo box and command button

John -

Ok...I think I got it this time! I didn't import any of the modules.

Thanks!

Kat

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Kat-
>
> Nope, try again. That database still has Module1 in it and references to the
> GroupWise libraries. You need to create a new clean database and import only
> the relevant tables, queries, forms, and macros, then post that.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
> Sent: Wednesday, June 01, 2011 5:01 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Open form using combo box and command button
>
> John -
>
> I've uploaded a database with just the relevant forms and tables....sorry!!!
> hope this helps!
>
> Thanks for all your help!
>
> Kat
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Kat-
> >
> > It's almost impossible to work with your database because you have a bunch
of
> > GroupWise library definitions that I don't have. It takes forever to open
> your
> > database because I get a ba-zillion error messages from Access. Can you
dump
> > the relevant tables, queries, and forms into another database and just
upload
> > that?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
> > Sent: Wednesday, June 01, 2011 3:27 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Open form using combo box and command button
> >
> > John,
> >
> > Thanks!!!!!!! That worked great!! However, I have an error popping up that
> says
> > that the newrecords isn't working properly..... i didn't do anything with it
> not
> > sure why its not working....this is on the find contract form. I've
uploaded
> an
> > updated database...
> >
> > Thanks!!
> >
> > Kat
> >