473,761 Members | 9,864 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error 2105 from "Add New" Command Button

rsmccli
52 New Member
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 3628
rsmccli
52 New Member
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 New Member
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
Ademola Adebayo
1 New Member
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
7192
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) how to use the selection "All" as criteria for a field in a query, which is used to generate data for a report.
1
2414
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, it appears to add a record (the record count goes up) but unlike single table dataforms, the form does not automatically move to the new record. In fact, though the record count increases by one (and you even get an error saying the primary key...
5
1478
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 the details of a selected record.
1
1343
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 the following SQL code in the SQL expression editor: SELECT JobNam, JobFailInstrTxt FROM SchedUNIXJob, ApplicationCdeVal WHERE ApplicationCdeVal.ApplicationTxt = "dailyops"
2
1531
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 ? i would like the insert command to start as soon as i validate the textbox : textchanged event ? what's the code to put in this event to start the Insert command ??? Thanks for helping me fast..
1
3146
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 side-by-side to the gridview and then I can click on "new" and isert a new subcategory or edit and update the sub-category. My problem is that when a category doesn't have any sub-categories then the Gridview is not displayed therefore there's no way I can...
2
1900
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 than just one form) ... I need in the textbox for the new edit form to have the user type in a item# then the form populates. I'm having tremedous trouble with the logic of this. Thanks!!! Dav
2
7717
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 submit button to submit a form that contains one or two Mileposts: 1) If a Milepost range larger than 5 miles is entered, I would like to pop up a confirmation box to confirm the range.
3
3518
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 textboxes where I could fill up the contents I want to add in my database. When I click the button, this second form should disappear while the main form should still display all contents of the database including the new entry I've added. Now the...
0
9957
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9905
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9775
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7332
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6609
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5229
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5373
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3881
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3456
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.