Prev: I want to transfer data from a filtered datasheet to a spreadsheet.
Next: syntax help requested
From: Dennis on 5 Apr 2010 11:12
I have an Access 2003 application under development, with a SQL backend. I
have data reader and write permissions. I am able to open the linked table up
in Access and add a new record that way. However, when I click on Add New
Record (a button I cread that just does a "DoCmd.GotoRecord , ,acNewRec", I
get error 2499 "Can't go to the specified record". I cannot for the life of
me figure out WHY. Can anyone give some ideas or insights on this? I'd sure
appreciate it!

Dennis
From: Dorian on 5 Apr 2010 14:59
Does your form containing the button have property AllowAdditions set to true?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Dennis" wrote:

> I have an Access 2003 application under development, with a SQL backend. I
> have data reader and write permissions. I am able to open the linked table up
> in Access and add a new record that way. However, when I click on Add New
> Record (a button I cread that just does a "DoCmd.GotoRecord , ,acNewRec", I
> get error 2499 "Can't go to the specified record". I cannot for the life of
> me figure out WHY. Can anyone give some ideas or insights on this? I'd sure
> appreciate it!
>
> Dennis
From: Dennis on 5 Apr 2010 15:10
OMG! That was it! (I'd started with an unbound form, so I always set those to
OFF, since I only need Edit turned on.) Stupid me.

THANK YOU!!!

Dennis



"Dorian" wrote:

> Does your form containing the button have property AllowAdditions set to true?
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "Dennis" wrote:
>
> > I have an Access 2003 application under development, with a SQL backend. I
> > have data reader and write permissions. I am able to open the linked table up
> > in Access and add a new record that way. However, when I click on Add New
> > Record (a button I cread that just does a "DoCmd.GotoRecord , ,acNewRec", I
> > get error 2499 "Can't go to the specified record". I cannot for the life of
> > me figure out WHY. Can anyone give some ideas or insights on this? I'd sure
> > appreciate it!
> >
> > Dennis
 | 
Pages: 1
Prev: I want to transfer data from a filtered datasheet to a spreadsheet.
Next: syntax help requested