Still having trouble with new record

[boblarson]

Is the ALLOW ADDITIONS property of the form set to Yes?

Yes, I can see it on the screenshot that the Additions is enabled.

So, how big is your database file? Did you run Compact and Repair first and then ZIP it? If you have WinXP or above you can just right click on the file and select SEND TO > COMPRESSED FOLDER which will zip it. Once you have compacted and then zipped is it still above 2Mb?

 

[Demetious]

Yes, I can see it on the screenshot that the Additions is enabled.

So, how big is your database file? Did you run Compact and Repair first and then ZIP it? If you have WinXP or above you can just right click on the file and select SEND TO > COMPRESSED FOLDER which will zip it. Once you have compacted and then zipped is it still above 2Mb?

Wow,
I was getting so flustered with this, I didn't even Zip it. Here you go.

 

[vbaInet]

It works on mine. Maybe the compact & repair thing did it or it's a Security issue. Bob has some links about this.

 

[Petros]

A question: Does the "protocol" allow anyone to take part of the attached example?

Thanks!

 

[vbaInet]

A question: Does the "protocol" allow anyone to take part of the attached example?

Thanks!

Apparently it's a Sample database in Access probably called Inventory Management so if you have Access 2007 you can get it there. The OP has made some changes to this one so you're better off getting a fresh copy (if you really need it).

 

[Petros]

I understand, no i do not need this particular example. I will look into the sample databases in my Access..Good idea. Sorry to disturb. Thanks!

 

[boblarson]

It works on mine. Maybe the compact & repair thing did it or it's a Security issue. Bob has some links about this.

It works on mine too. I think you haven't enabled code or set the database to be in a trusted location. Put a breakpoint on the code and see if it hits it. I don't think it's even getting there.

 

[Demetious]

It works on mine too. I think you haven't enabled code or set the database to be in a trusted location. Put a breakpoint on the code and see if it hits it. I don't think it's even getting there.

Vba and Bob,
You both have been most helpful. I wasn't getting any popups, as they were disabled, so I had no clue. This did the trick. Again, thank you both.

 

[boblarson]

Whew! Glad that's sorted.

 

[vbaInet]

I wasn't getting any popups, as they were disabled, so I had no clue.

I'm not 100% sure why but it may well be the registry settings.

But glad that's sorted

 

[boblarson]

I'm not 100% sure why but it may well be the registry settings.

But glad that's sorted

Probably has the wrong options set in one, or both, places here:

 

[vbaInet]

Oh yes, that's right. I'm now remembering setting that option when I first started using 2007.