Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
Hello everyone. I want to be able to copy information on a form onto a new one and change a couple of fields can you help me with this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
duplicating entires
- Thread starter Dundee Lad
- Start date
Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
Re: duplicating entries
can anyone help me with this it is driving me crazy
can anyone help me with this it is driving me crazy
Upvote
0
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
This needs to be handled in code. Go to http://www.helenfeddema.com and look in the Access Archon section, down towards the last 20 or so entries. Plenty of juicy tidbits in there -- I used one for just what you are after.
Denis
Denis
Upvote
0
Yes, it's a code thing but you've given an extremely limited explanation of what you're looking to do.
What do you mean by copying information on a form to a new one?
Simply making a new form and then changing some of the labels, for example? Or perhaps which fields are shown or how they appear?
If you mean you want a user to input information and then you want that same information to appear in another form, that's code.
A simple approach might be:
During the event that opens this second form (such as clicking a button)
you would need to copy the current values of the fields you wish to transfer into an array -- finish opening the form, and then set the fields on the new form equal to the values of the array.
If the original input needs to be retained/aka - permanent data:
The form needs to be linked to a table. This may or may not be the 'permanent' home of the information. It could be a 'working' table that only holds values that are later transferred to the main database. You would then build another form also linked to the same table.
You would need to be careful, though, with moving back and forth between forms. A good method here is to hide (Visible=False) the first form or close it if you will not need to open it again.
Mostly I'm putting this out as an idea of how to approach this problem. By no means is this a complete checklist of everything you would need to do or validate.
Mike
What do you mean by copying information on a form to a new one?
Simply making a new form and then changing some of the labels, for example? Or perhaps which fields are shown or how they appear?
If you mean you want a user to input information and then you want that same information to appear in another form, that's code.
A simple approach might be:
During the event that opens this second form (such as clicking a button)
you would need to copy the current values of the fields you wish to transfer into an array -- finish opening the form, and then set the fields on the new form equal to the values of the array.
If the original input needs to be retained/aka - permanent data:
The form needs to be linked to a table. This may or may not be the 'permanent' home of the information. It could be a 'working' table that only holds values that are later transferred to the main database. You would then build another form also linked to the same table.
You would need to be careful, though, with moving back and forth between forms. A good method here is to hide (Visible=False) the first form or close it if you will not need to open it again.
Mostly I'm putting this out as an idea of how to approach this problem. By no means is this a complete checklist of everything you would need to do or validate.
Mike
Upvote
0
Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
thanks everyone for your help. I have managed to solve this, I will make sure my explanations are much clearer next time! thanks again
Upvote
0
Similar threads
- Solved
