468,738 Members | 1,752 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,738 developers. It's quick & easy.

Renaming form mde file

Here is my "problem":
I have a form that is based on a lot of different querys,the result of the querys shown in the form are based one the input given on the form, this form is in two versions and I need the user to be able to change between this to versions.

I made a script that closed the form, renamed it to the same name as the second version, then renamed the second version to the same name as the first version.

This worked fine until I made the db a mde file. I then got the message cant chane name of form in a mde fil.
Ok so I am a new at this and makes a lot of beginner errors, but is there a easy way around this? The file must be a mde file.
Oct 30 '07 #1
2 1357
missinglinq
3,532 Expert 2GB
No, I don't think so! As Access has already told you, you can't make structural changes to objects from within an MDE file, and I'm pretty sure this includes object names! Sorry!

To be honest, I'm fuzzy as to exactly what you're trying to do with this switching of names! Maybe if you can explain this a little more clearly, we can help you with some other workaround.

Linq ;0)>
Oct 30 '07 #2
I will try to explain it a little better please have patience whith me my english is not that good, and I have just started to toy around whit access. :)

There are two forms doing the exact same thing with the exact same controls and fields. The differense between them are the layout.

Both forms are based on the same querys and there are some list boxes based on sql.

All together there are about 40 different querys.

By the push of a button the formes change from layout 1 to 2, and back again if you push the button. I did this by making script that did the foloving:

1. closed the layout1
2. renamed layout1 to layout_temp
3. renamed layout2 to layout1
4. renamed layout_temp to layout2
5. open layout1

Now the former layout1 is layout2 and former layout2 is layout1.

The reason for doing it this way was that the querys is getting their criteria from the layout1 form, and returns the response to layout1.

Does this help?
Oct 30 '07 #3

Post your reply

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

By using this site, you agree to our Privacy Policy and Terms of Use.