A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Importing" new forms and just buttons to old forms to a new global front end?



 
 
Thread Tools Display Modes
  #1  
Old June 10th, 2005, 06:13 PM
StargateFanFromWork
external usenet poster
 
Posts: n/a
Default "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  
Old June 10th, 2005, 07:13 PM
Albert D.Kallal
external usenet poster
 
Posts: n/a
Default

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  
Old June 10th, 2005, 09:03 PM
StargateFanFromWork
external usenet poster
 
Posts: n/a
Default

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  
Old June 10th, 2005, 11:10 PM
Albert D.Kallal
external usenet poster
 
Posts: n/a
Default

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  
Old June 14th, 2005, 03:05 PM
StargateFanFromWork
external usenet poster
 
Posts: n/a
Default

"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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.