473,412 Members | 2,262 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,412 software developers and data experts.

Error 2105 from "Add New" Command Button

rsmccli
52
Using AC2002

Hello. I am working with an existing DB that has "Add New" command buttons on two forms.

When I, an Admin, click the buttons, they work properly, and a new, blank form is created, ready for data entry.

When one of my users from the "Update Data" workgroup clicks the button, they get an "Error 2105: You can't go to the specified record" error, and no new row is created. Each of these are just supposed to add a new row in their respective tables.

Could this just be a security issue; I'm assuming so because Admins can use the button. However, I changed the table permissions to allow Open/Run, Read, Update, Insert, and Delete on all tables and am still having issues. Here is the code behind one of the buttons without errorhandling
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdAddRec_Click()
  2. On Error GoTo ErrorHandler
  3.  
  4. ' add new record
  5.   Me.AllowAdditions = True
  6.   DoCmd.GoToRecord , , acNewRec
  7.  
  8. ' set focus to first data entry field
  9.   Me.Plant.SetFocus
  10.  
  11. End Sub

Any help is appreciated.
Feb 14 '08 #1
3 3607
rsmccli
52
Also notable is that it appears that the new record is being made, because the first time an "update user" clicks the button, there is no error, only the second and third, etc. button clicks produce the error. They are just not able to navigate to the new record using the navigation buttons, as "admins" can.

Thanks again for looking.
Feb 14 '08 #2
rsmccli
52
bump Update Data users can manually create a new field in the table... Allow Additions property is set to "yes" even though this is taken care of in code also...
Feb 14 '08 #3
How did you resolve this issue, because I am having the exact same problem
Sep 16 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: meganrobertson22 | last post by:
Hi Everyone- I have a question about how to add and then use the "All" selection in a combo box. I am trying to figure out how to: (1) add "All" as a selection to a combo box and then (2)...
1
by: msmcg | last post by:
I built a dataform using the VB.net wizard. I have two tables, with one relation, Parent to Child, linked on one common key. The dataform loads the data fine, and when I click on the Add button,...
5
by: HS1 | last post by:
Hello I have Win application used to add records into a table (called Clients) in an Access database. I use a DataGrid1 to present records in this table and use some TextBox(es) to display...
1
by: richardkreidl | last post by:
Two questions, first I'm using CR 10 and connecting to a Sybase database. I don't see a 'Add Command' button in the 'Database Expert' dialog. Second is how would I correctly code the syntax for...
2
by: moi | last post by:
Hello, I have a formview with a dropdownlist,a textbox and a button to add a new row with this fields. Everything works good (i have my new record) when i click on the button but how to be faster...
1
by: Giorgio | last post by:
Hi, I have a dropdown menu with categories and when a category is selected the Gridview is binded with sub-categories. Then when a sub-category is selected a detailsview is displayed...
2
by: Parasyke | last post by:
Please help.... I have a form that I successfully add records to that I want to copy and turn into a form for editing records from that same table (It is imperitive that it be done this way, rather...
2
by: bay_dar | last post by:
Hi, I have an internal ASP.NET application that I'm are using to send e-mails out based on a single milepost or milepost range entered. I'm trying to do two things when a user clicks on the...
3
by: panget | last post by:
I am supposed to create a form with a flexgrid that should display all contents of my database books.mdb. I also added a button called "Add" which when clicked should display another form with...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.