472,965 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 1507
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

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

Similar topics

by: Don Leverton | last post by:
Hi Folks, I have been given a CD with approx 130 .xls files (bean-counters!) that I would like to import and merge to ONE table (tblTradeshow). The XL files are *similarly*, but not...
by: Don Leverton | last post by:
Hi Folks, I have been given a CD with approx 130 .xls files (bean-counters!) that I would like to import and merge to ONE table (tblTradeshow). The XL files are *similarly*, but not...
by: Tim923 | last post by:
There seem to be 4 steps to rename the form Form1 to MyForm: Rename the CS file from Form1 to MyForm. (I think this step could be ommitted, but they might deduct points.) Click on the form...
by: Rob | last post by:
When renaming a form... looks like you should probably rename it in 2 places... the logical (Name) property of the form as well as the physical file name... (this could become confusing ). Is...
by: BillCo | last post by:
I'm updating a legacy app with table naming that makes baby jesus cry. It's a bit of a spider web though... no telling when and where the tables will be called by name. So I wrote this for renaming...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.