Lost my "add new record" icon in navigation bar

[larocqgi]

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".

[Rabbit]

You probably set the subform to not allow additions.

[larocqgi]

That is not the problem. Remember, I cannot add items to my main form, not the subform.

Thanks anyway.

[Rabbit]

Then you probably set the main form to not allow additions. Or you're using a non-updateable query as your record source.

[larocqgi]

My main form allows edits/additions. I do not use queries in this database. My record sources are tables. It's very frustrating.

[Rabbit]

What's the file size of the database?

[larocqgi]

4.6 MB. I just started it. Don't want to add more to it until it works.

[Rabbit]

Zip and attach your database so we can take a look at it.

[larocqgi]

Cannot send you db because it contains confidential information. Sorry.

[NeoPa]

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).

[larocqgi]

I tried putting in dummy data yesterday and this morning. It did not work out. So, I guess that's it. Thank you.

[Rabbit]

Then just delete all the data and attach that.

[larocqgi]

I have removed data and put in some dummy ones. How do I attach to this post??

[Rabbit]

The instructions are in the link that NeoPa posted.

[larocqgi]

I did see the instructions, but there is no link or option for attaching files.

[NeoPa]

Larocqgi:
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.

[larocqgi]

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

[Seth Schrock]

Click on the Advanced button next to Post Reply. From there you can click on the Manage Attachments button.

[NeoPa]

I'll update the linked article as that's not clear (and it really should be).

PS. Done.

[larocqgi]

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.

[NeoPa]

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.

[larocqgi]

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.

[Seth Schrock]

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.

[larocqgi]

How could I have locked my database? I'm lost.

[Seth Schrock]

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.

[Rabbit]

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.

SELECT Product.*, Product_List.[Product List]
FROM Product_List
INNER JOIN Product
ON Product_List.[Product List] = Product.Product;

[larocqgi]

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.

[Rabbit]

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.

[Seth Schrock]

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.

[NeoPa]

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 :-)