If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Importing" new forms and just buttons to old forms to a new global front end?
My colleague created a db for the office and I will be fine-tuning the
forms. However, she is still making modifications/additions and she will then inform us when we can update all our front ends. My question is this - since I've already done enough fine-tuning of my own front end re the forms and buttons because I find it easier to work with the data that way, is there a way to "import" my own forms and those buttons I've added to hers to the new front end? She's made/making changes so I can't just go back and give her my front end as it's no longer current. Also, except for the new forms I've done, my changes on some are just superficial, i.e., adding buttons to make them user-friendly. Pls advise and thanks. D |
#2
|
|||
|
|||
Well, if no changes are being made to the particular form, then you could
just delete the form when you get the new db, and then import yours. however, if both of you are going to be modifying the same form,then you got a problem, and there really is no way to resolve that. I suppose I would just import your form into the new front end when the developer is done. You then bring up both forms in design mode, and then cut and past the buttons etc so they look the same. I guess you would also have to go dig up the code for those buttons also. You could also get the developer to coordinate this with you. Have them send the latest update, and then agree that no changes will be made to that particular form (and if changes do need to be made, then you send the developer that form, and wait until they are done with that form). -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#3
|
|||
|
|||
Thanks so much for the info. No, it won't be as bad as that. We both are
the developers, my colleague and I and there are only 2 scenarios: I added buttons to her forms and created whole new forms myself. So in one case it's to add the buttons and in the other case it's to import whole new forms. But that where I was getting stumped. In the FILE pulldown, I can only find export. But since you tell me it can be done, I went and looked at the help again. Would this importing of forms function be through the FILE GET EXTERNAL DATA IMPORT? Also, I figured out today how the code works. There doesn't seem to be modules as in Excel but fortunately, the code was easy enough to find in the forms. I just copy/pasted while in the vb editor. Very kewl! Thanks much! D "Albert D.Kallal" wrote in message ... Well, if no changes are being made to the particular form, then you could just delete the form when you get the new db, and then import yours. however, if both of you are going to be modifying the same form,then you got a problem, and there really is no way to resolve that. I suppose I would just import your form into the new front end when the developer is done. You then bring up both forms in design mode, and then cut and past the buttons etc so they look the same. I guess you would also have to go dig up the code for those buttons also. You could also get the developer to coordinate this with you. Have them send the latest update, and then agree that no changes will be made to that particular form (and if changes do need to be made, then you send the developer that form, and wait until they are done with that form). -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#4
|
|||
|
|||
Would this importing of forms function be through the
FILE GET EXTERNAL DATA IMPORT? yes, that is exactly how you do this. And, this form will also bring in all the code that belongs to that form also. However, you are right on the money by "looking" in the code module, and cutting/pasting that code to the new form from the old.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#5
|
|||
|
|||
"Albert D.Kallal" wrote in message
... Would this importing of forms function be through the FILE GET EXTERNAL DATA IMPORT? yes, that is exactly how you do this. And, this form will also bring in all the code that belongs to that form also. However, you are right on the money by "looking" in the code module, and cutting/pasting that code to the new form from the old.... Thanks. Appreciate it. We'll hopefully do that this week. Cheers. D -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
Thread Tools | |
Display Modes | |
|
|