Save Dynamically created forms

DaDeViL · August 16th, 2005, 09:10 AM

Hello, I need to save forms that have been created dynamically. To do this I used the following code

Code:

DoCmd.OpenForm a, acNormal, , , acFormEdit, acWindowNormal, searchQuery

DoCmd.Save acForm, a

DoCmd.Close acForm, a

But I get the error:

The Save action was cancelled.:(

Any ideas?

Thanks

ÃaÃeViÂ£

DaDeViL · August 17th, 2005, 07:24 AM

Does this issue have to do with permissions? I have been googling it and most relevant searches have something to do with a Front End/Back End system.

I split my database, and right now I have exclusive access, but it still does not work.

Thanks

ÃaÃeViÂ£

DaDeViL · August 17th, 2005, 08:29 AM

Ok yesterday I tried the following and it was still giving me the
'The Save action was cancelled.' error.

Code:

Dim a As String
a = SearchResultsForm.Name
DoCmd.OpenForm a, acNormal, , , acFormEdit, acWindowNormal, searchQuery

DoCmd.Save
DoCmd.Close acForm, a

Today when I came back and tested it, it saved the form perfectly.

This really worries me.

This tells me that it might be a permissions issue. The permissions were at a different state yesterday than they are today. I gave myself exclusive access and administrator privleges yesterday, and there were no permissions set before yesterday. Today I logged on, didnt change a thing, and those forms were automatically saved without the annoying error.

So maybe the new permissions rules only took effect after I logged back in today? There isnt enough proof to claim this is what the problem was, or that logging out and logging back in is any kind of solution.

Am I correct in my thinking? Hope I havent confused you.

Maybe what I am asking is how can I make sure this more stable when more users are using this at the same time? Or even one user?

Thanks

ÃaÃeViÂ£