WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Update or CancelUpdate Error

 
   Home -> Office other -> Getting Started RSS
Next:  Increment custom number format ie. 080100, 080101..  
Author Message
C. Sharp

External


Since: Feb 08, 2007
Posts: 7



(Msg. 1) Posted: Fri Aug 29, 2008 1:45 pm
Post subject: Update or CancelUpdate Error
Archived from groups: microsoft>public>access>gettingstarted (more info?)

I have a user who is getting the "Update or cancelUpdate without addNew or
edit." error message 3020 on a data entry form. This happens when the user
first Filters for an attendee type = XXX. Next, my colleague selects the
last name field and depresses CTRL+F to find a record by last name. BUT if
my user mispells the name twice in a row the error above pops up. Any idea
why this error would pop up? We have not VBA code on this very generic data
entry form. Thanks in advance for suggestions!
Back to top
Login to vote
Arvin Meyer [MVP]

External


Since: Feb 26, 2004
Posts: 4454



(Msg. 2) Posted: Sat Aug 30, 2008 8:21 am
Post subject: Re: Update or CancelUpdate Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The table is most likely assuming data input and is reacting to incorrect
operating or validation.

Use combo or list boxes for your variable data entry, with NotInList event
code to handle data which needs to be added. Form filtering is done to find
records, not enter them.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"C. Sharp" <CSharp DeleteThis @discussions.microsoft.com> wrote in message
news:1BF992B0-E21A-4DB6-909E-CE80A11539D3@microsoft.com...
>I have a user who is getting the "Update or cancelUpdate without addNew or
> edit." error message 3020 on a data entry form. This happens when the
> user
> first Filters for an attendee type = XXX. Next, my colleague selects the
> last name field and depresses CTRL+F to find a record by last name. BUT
> if
> my user mispells the name twice in a row the error above pops up. Any
> idea
> why this error would pop up? We have not VBA code on this very generic
> data
> entry form. Thanks in advance for suggestions!
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Getting Started All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET