472,328 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Lost my "add new record" icon in navigation bar

In my form, which contains a subform, I have lost the "add new record" icon for my master form (way at the bottom). I have tried adding a "add new record" command button to fix the situation, but when I try to use this command button, I get the following message: "You can't go to the specified record".
Dec 20 '11 #1
29 4116
12,516 Expert Mod 8TB
You probably set the subform to not allow additions.
Dec 20 '11 #2
That is not the problem. Remember, I cannot add items to my main form, not the subform.

Thanks anyway.
Dec 21 '11 #3
12,516 Expert Mod 8TB
Then you probably set the main form to not allow additions. Or you're using a non-updateable query as your record source.
Dec 21 '11 #4
My main form allows edits/additions. I do not use queries in this database. My record sources are tables. It's very frustrating.
Dec 21 '11 #5
12,516 Expert Mod 8TB
What's the file size of the database?
Dec 21 '11 #6
4.6 MB. I just started it. Don't want to add more to it until it works.
Dec 21 '11 #7
12,516 Expert Mod 8TB
Zip and attach your database so we can take a look at it.
Dec 21 '11 #8
Cannot send you db because it contains confidential information. Sorry.
Dec 22 '11 #9
32,511 Expert Mod 16PB
It's up to you of course. If you need the help then you will do the work to strip out the sensitive data and replace it with meaningful, but dummy, data. Full instructions can be found at Attach Database (or other work).
Dec 22 '11 #10
I tried putting in dummy data yesterday and this morning. It did not work out. So, I guess that's it. Thank you.
Dec 22 '11 #11
12,516 Expert Mod 8TB
Then just delete all the data and attach that.
Dec 22 '11 #12
I have removed data and put in some dummy ones. How do I attach to this post??
Dec 22 '11 #13
12,516 Expert Mod 8TB
The instructions are in the link that NeoPa posted.
Dec 22 '11 #14
I did see the instructions, but there is no link or option for attaching files.
Dec 22 '11 #15
32,511 Expert Mod 16PB
I did see the instructions, but there is no link or option for attaching files.
What did you find when you tried to follow instruction #9 in the list? Many others have managed to follow those instructions and not found a problem.
Dec 22 '11 #16
When I post a reply and scroll down to the bottom, I see the following:

Didn't find the answer to your question? Post your Microsoft Access / VBA question on Bytes

You can also browse similar questions: Microsoft Access / VBA None
( Edit Tags )

Copyright 1995-2010 BYTES. All rights Reserved. Formerly "TheScripts.com" from 2005-2008
About Bytes | Advertise on Bytes | Help
Latest Expert Topics
Sitemap | Microsoft Access / VBA Answers Sitemap | Microsoft Access / VBA Insights Sitemap
Dec 22 '11 #17
Seth Schrock
2,965 Expert 2GB
Click on the Advanced button next to Post Reply. From there you can click on the Manage Attachments button.
Dec 22 '11 #18
32,511 Expert Mod 16PB
I'll update the linked article as that's not clear (and it really should be).

PS. Done.
Dec 22 '11 #19
Here is my problematic database. I cannot see the "add new record" button for the master form. I will take some time off from this after the end of the day today. Will be back on Jan 2.

Thanks your your help.
Attached Files
File Type: zip Problematic Database.zip (262.8 KB, 118 views)
Dec 23 '11 #20
32,511 Expert Mod 16PB
You haven't followed the instructions correctly and I can't look at your database as it's not in a format I can open. I don't know what else I can say at this point. The instructions are all there. If you follow them all will work. If you don't then it won't.
Dec 23 '11 #21
I cannot follow the instructions as they do not work. I cannot debug and compile since I don't have that option. I'm using MS Access 2007. So, I surrender; I give up. Merry Xmas and all the best for 2012.
Dec 23 '11 #22
Seth Schrock
2,965 Expert 2GB
I tried to save it in .mdb format, but there are features that require the latest version.

@larocqgi In design view of the Product form, I don't see a Add New Record button. This could be part of why you don't see it in form view.

Also, It seems that the database is locked. When I try to get into the vba code, it says that the project is locked and unviewable. I have never seen this before so I don't know how to fix it, but I do think that it could be part of the reason that you can't add new records.
Dec 23 '11 #23
How could I have locked my database? I'm lost.
Dec 23 '11 #24
Seth Schrock
2,965 Expert 2GB
I'm not sure. Like I said, I've never seen this before. Later today, I'll check into some more and see what I can find and maybe unlock it.
Dec 23 '11 #25
12,516 Expert Mod 8TB
When I said you probably used an unupdateable query as your record source, and you replied with you don't use queries, your record sources are tables, did you double check your record sources?

I'm going to take a shot in the dark and say no, you did not. Because you're using an unupdatable query as your record source. This query is not updateable. And it's the record source of your form.
Expand|Select|Wrap|Line Numbers
  1. SELECT Product.*, Product_List.[Product List]
  2. FROM Product_List
  3. INNER JOIN Product
  4. ON Product_List.[Product List] = Product.Product;
Dec 23 '11 #26
I have difficulty following you Rabbit. I have not created queries. I have only tables. So, I don't understand why my record source would be a query.
Dec 23 '11 #27
12,516 Expert Mod 8TB
You don't have to create a query object to use a query as a record source. If you look at the record source property of your form, there is a query definition / SQL string in there.
Dec 23 '11 #28
Seth Schrock
2,965 Expert 2GB
That row source is a query. Even though you didn't actually create a query that is listed in the Access Objects, that is SQL code for the query. It is just another way of utilizing a query.
Dec 23 '11 #29
32,511 Expert Mod 16PB
Here's a couple of points that might help :
  1. The MS Access term for a saved query in a database is a QueryDef. Many people think of them as queries, but the technical term is a QueryDef. A Query, on the other hand, is any query, which includes QueryDefs, but also SQL strings which resolve to queries when passed to the SQL engine (Jet). It makes communication awkward and easy to misunderstand, but if you realise that it can help you to deal with such questions more clearly. It seems your form is built using a Query, but not a QueryDef one.
  2. Reasons for a Query to be Non-Updatable is worth checking for any query that a form is built on and where you want to update the underlying data.

PS. If you say when you try to follow instructions that you were unable to follow one of them, and give a reason, then we can deal with that better than if you don't explain this. Dealing with someone who has found a problem is so much easier than dealing with someone who cannot, or will not, follow simple instructions. If we know (as in this case) that you are of the former group then we can make progress. For those in the latter group there is very little we can do.

PPS. Thanks again to Seth for taking the trouble to attempt to do the conversion himself and explaining the problem he encountered. Your efforts are appreciated :-)
Dec 24 '11 #30

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

Similar topics

by: Yi | last post by:
Hi, I am a scientist and new to .NET programming. On my PC, I am using Windows 2000 professional with IIS, SQL Server 2000 (standard, personal),...
by: William Wisnieski | last post by:
Hello Everyone: I'm having a very strange problem occurring with my Access 2000 database. I call it the "mystery record." Here's the story: ...
by: Tim | last post by:
I have used a graphic 'next record' button on a form. How can I stop it from going past the last existing record? In other words, I don't want it...
by: msnews.microsoft.com | last post by:
Hi, How do I add a reference in VC++.NET? In VB.NET and VC#.NET, there's an option in "Project" menu called "Add Reference". This will add a...
by: Samuel R. Neff | last post by:
I just started having a problem with the Add Reference dialog not displaying in VS.NET 2003. Whenever I click Add Reference the dialog doesn't...
by: PJSimon | last post by:
In regards to this MSDN article: http://support.microsoft.com/default.aspx?scid=kb;en-us;306149 .... how do I add the registry key? I got...
by: Maxwell2006 | last post by:
Hi, I am using Visual Studio 2005. I have added a DLL into GAC. I can confirm that by going to C:\WINDOWS\assembly and see the...
by: rsmccli | last post by:
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...
by: MLH | last post by:
I have an A97 form with Allow Edits, Allow Deletions and Allow Additions properties set. Scrolling through records will eventually take me to the...
by: sueb | last post by:
I want to have a separate form for adding records to my database (so that I can lock the main ID field and prevent users' accidentally changing it). ...
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

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.