I was wondering if it were possible to do this.
I have a form that is used to input a ton of information and then I have a button on it it to export it into a word template to print out. Now I have another form that I want to start populating after the word export is done. So I was trying to think of a way to get the SOME of the same information I would have just input into that form copied over to another form which has a sub form as well.
I dont know if it is entirely possible to sort of a COPY PASTE function in the way of when I hit the copy button on the first form mentioned it copies a predefined set of fields (ie: name, fee, miles, milescharge, tax) and then can navigate to the record in the sub form and but my cursor in and hit a button labeled COPY on that form, thus populating that field in that sub form???
I hope explained this clearly. I have been searching on how to do this and also posted a similar question on here about a week ago. http://www.thescripts. com/forum/thread762003.ht ml
That worked for me but I couldnt control where the information was pushed and it just started a new record, but there will be times where it needs to go under an existing customers record, so it making a NEW record wouldn't work.
ANY help would be MORE than appreciated. Thanks a million!
5 9267
I was wondering if it were possible to do this.
I have a form that is used to input a ton of information and then I have a button on it it to export it into a word template to print out. Now I have another form that I want to start populating after the word export is done. So I was trying to think of a way to get the SOME of the same information I would have just input into that form copied over to another form which has a sub form as well.
I dont know if it is entirely possible to sort of a COPY PASTE function in the way of when I hit the copy button on the first form mentioned it copies a predefined set of fields (ie: name, fee, miles, milescharge, tax) and then can navigate to the record in the sub form and but my cursor in and hit a button labeled COPY on that form, thus populating that field in that sub form???
I hope explained this clearly. I have been searching on how to do this and also posted a similar question on here about a week ago. http://www.thescripts.com/forum/thread762003.html
That worked for me but I couldnt control where the information was pushed and it just started a new record, but there will be times where it needs to go under an existing customers record, so it making a NEW record wouldn't work.
ANY help would be MORE than appreciated. Thanks a million!
To be really elegant at this you are really talking about manipulating and controlling recordset behaviour. Sure you can automate a lot of things by direct commands such as DoCmd.GotoContr ol and then activating menubar commands such as the finding of a value based on the previous screen controls value and then pasting and so on but you do not have an extensive control 'with the data' so to speak.
Here you are talking about identifying specific set columns and rows within an existing recordset that possibly 'may' be filtered or restricted in some way at any one time, only grabbing certain specific values, navigating to a set row on another screen and moving cursors to set points referenced by controls on other forms in a controlled and meaningful way and then updating the underlying recordset and requerying the form that has the amended/updated data provided to it.
I'm not sure if I am explaining this sufficiently but it would be worth your time looking at the concepts of traversing recordset objects and related manipulation of those recordsets. Heres a couple of HOWTO links from this site to get you started. Access VBA DAO recordset loop using two recordsets Finding a Specific Record Programmaticall y
Regards
Jim :)
Okay, I read through your post and absorbed as much as I could. Read the links you gave me and I believe got lost even more! sorry!
I posted some pictures up on one of my domains to maybe illustrate things a bit better, as I was probably a bit confusing in my description.
The first one:
http://www.mykesdesign s.com/access/contactsform.jp g
Is the first form used in the database to export data into word. Then I was wanting to have a copy customer button at the bottom to take the fields
(Plaintiff, Date of creation, Service Charge, Mileage Charge, Sales Tax Charge, and Check Amount)
and then pump them into this form:
http://www.mykesdesign s.com/access/maincustomer.jp g
but the only problem is, is if this is "walter's" second record I cant figure out how to add a record to an existing customer (Plaintiff)
So I don't know if there is an alternative method to all of this, doesn't have to be a copy, paste method. At this point I am willing to try anything.
I hope the pictures helped explain what I am trying to do, and sorry if it was an exact repeat of the first post was, I just thought it may help.
And thank you so much for even considering helping me out with this, it really does mean a lot!
Okay, I read through your post and absorbed as much as I could. Read the links you gave me and I believe got lost even more! sorry!
I posted some pictures up on one of my domains to maybe illustrate things a bit better, as I was probably a bit confusing in my description.
The first one: http://www.mykesdesigns.com/access/contactsform.jpg
Is the first form used in the database to export data into word. Then I was wanting to have a copy customer button at the bottom to take the fields
(Plaintiff, Date of creation, Service Charge, Mileage Charge, Sales Tax Charge, and Check Amount)
and then pump them into this form: http://www.mykesdesigns.com/access/maincustomer.jpg
but the only problem is, is if this is "walter's" second record I cant figure out how to add a record to an existing customer (Plaintiff)
So I don't know if there is an alternative method to all of this, doesn't have to be a copy, paste method. At this point I am willing to try anything.
I hope the pictures helped explain what I am trying to do, and sorry if it was an exact repeat of the first post was, I just thought it may help.
And thank you so much for even considering helping me out with this, it really does mean a lot!
Hi,
Placing those images on your domain is visually very helpful and simplifies matters because it is not always easy guessing what you have based on a post but now I can see the direction you need to take.
On that contactsform.jp g you are simply typing that plaintiff/customers name. I suggest you revisit your design by placing a customerID field in the table and feeding the plaintiff/customer from a plaintiff/customer table. This will eradicate the need to deal with the transfer of any data at all in the manner you are speaking about or go down the route of recordsets that I spoke about earlier.
You could potentially have many records for each plaintiff so linking the plaintiff to the screenform shown by contactsform.jp g (that way round) will put you in a position of being able to track those records per plaintiff
A 'query' can retrieve any data you wish to see in the plaintiff/customer side (Maincustomer.j pg subform) this is called the ' Auto lookup' feature in access. Have a look at this concept in help and if you get stuck with it get back to me.
It may be that I 'could' take a quick look at the db for you if it is not too far down your development/design road as it is not always is it easy to articulate these things on here before the thread gets a horrible mishmash of misunderstandin gs :)
Regards
Jim :)
Hi,
Placing those images on your domain is visually very helpful and simplifies matters because it is not always easy guessing what you have based on a post but now I can see the direction you need to take.
On that contactsform.jp g you are simply typing that plaintiff/customers name. I suggest you revisit your design by placing a customerID field in the table and feeding the plaintiff/customer from a plaintiff/customer table. This will eradicate the need to deal with the transfer of any data at all in the manner you are speaking about or go down the route of recordsets that I spoke about earlier.
You could potentially have many records for each plaintiff so linking the plaintiff to the screenform shown by contactsform.jp g (that way round) will put you in a position of being able to track those records per plaintiff
A 'query' can retrieve any data you wish to see in the plaintiff/customer side (Maincustomer.j pg subform) this is called the ' Auto lookup' feature in access. Have a look at this concept in help and if you get stuck with it get back to me.
It may be that I 'could' take a quick look at the db for you if it is not too far down your development/design road as it is not always is it easy to articulate these things on here before the thread gets a horrible mishmash of misunderstandin gs :)
Regards
Jim :)
Thank you so much for the quick reply. I am, as we speak looking up the auto lookup query. I hope this will solve my problem. So if I understand correctly, when the first form is brought up to input all the data (contactsform) they will input the custID and the auto lookup query will take care of putting all the required fields in the sub form that I need it to. Granted the sub form is based off of that query?
I think that is how it will work? I will try accomplishing this today. and Jim, if I am totally stumped.. if you 'could' take a look at this I would be more than thankful. I will come back with updates soon!
Thank you so much for the quick reply. I am, as we speak looking up the auto lookup query. I hope this will solve my problem. So if I understand correctly, when the first form is brought up to input all the data (contactsform) they will input the custID and the auto lookup query will take care of putting all the required fields in the sub form that I need it to. Granted the sub form is based off of that query?
I think that is how it will work? I will try accomplishing this today. and Jim, if I am totally stumped.. if you 'could' take a look at this I would be more than thankful. I will come back with updates soon!
Hi Mike,
As you know I took a look at the db for you and I'm sure you now understand the concepts of using queries to draw together your table data together to present the information in a meaningful way rather than by typing data in many times over unnecessarily.
Best of luck
Jim :)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: The Flyer |
last post by:
Hi
Sorry for posting this message to so many groups, but I was not sure
which group the windows keyboard experts would be reading, so I
ventured to post it to all of them.
I want to map or create shortcut on the keyboard for Cut/Copy/Paste
functions. I can use the regular Control_X, C or V to do the same in
Windows XP, but I would rather press a single key just like in Sun
Solaris keyboards which have specific keys for these functions.
|
by: Faith |
last post by:
Hello.
I need to take a column from Excel(unknown amount of rows)
that will be selected by the user and copy those cells.
Then I will need to paste those cells into the first
column in a Data Grid (system.windows.forms).
Basically, the user receives a list of clientIDs from a
client as an email attachment in Excel listed like:
1234 ABC Company
234 DEF Company
348 GHI Company
|
by: Legendary Pansy |
last post by:
I was checking out the 101 C# Samples, specifically Windows Forms - Use the Clipboard. I took a look at the code for a while, and I understand what the program is doing with the cut, copy, pasting via the file menu events using the clipboard. However, what I don't get is how is the program able to produce a context menu in the textbox area. When right clicking, the context pops up and allows to cut/copy/paste/delete, etc..
But the thing is, I...
|
by: Rachel Suddeth |
last post by:
This may not be the right forum, but it's a problem I chiefly come across
when trying to post here.
When I do a copy/paste from VS, the text always looks really weird (and even
if I'm in an editor that's supposed to be doing plain text, it looks like
it's in a different font -- and of course you can't change the font in a
plain text editor.) Then when it gets converted to actual plain text, there
is a blank line stuck in between every...
|
by: lgbjr |
last post by:
Hello All,
I¡¯m using a context menu associated with some pictureboxes to provide
copy/paste functionality. Copying the image to the clipboard was easy. But
pasting an image from the clipboard is proving to be more difficult. These
pictureboxes are bound to an AccessDB. If the user wants to add an image,
they select an image using an OpenFileDialog:
Dim result As DialogResult = Pic_Sel.ShowDialog()
If (result = DialogResult.OK) Then
| |
by: NetronProject |
last post by:
My copy/paste operation results in a MemoryStream full of '\0'
characters on the Clipboard.
Maybe my approach to copy/paste is wrong when handling generic types.
All entries in the CollectionBase are, of course, ISerializable and the
binary serialization to file fully works.
<Thank you so much for you help>
|
by: squirrelonfire |
last post by:
Hi I run postgreSQL from a remote server like this
SSH -X cnguyen_db@okaram.spsu.edu
....enter the password
Then I run bluefish& and psql
The problem I'm having is that I can't copy and paste my code from bluefish to psql in the Xterm window.
When I click middle click, it didn't do anything, when do Ctrl V, it didn't do anything neither.
I am using MAC OS X and PSQL and bluefish is run entirely from my teacher's server. I also have...
|
by: al_johnson222 |
last post by:
>From any page, I want to be able to call a JS function that will do the
equivelant of select all, and copy. This data will then be posted to a
page that will log it.
This would be easy using copy/paste functionality but I don't want to
screw-up users copy/paste buffer. Anyone have an example of how to
retrieve all text with similar formatting of copying page to notepad
without using copy/paste functionality? Thanks in advance.
Al
|
by: jh |
last post by:
I'd like to copy/paste into a listbox during runtime. I can do this for a
textbox but can't figure out how to accomplish this for a listbox. Any
help? Thanks.
|
by: questionit |
last post by:
Some websites disable the Windows copy and paste feature to use on thier website. A text can not be copied and pasted either from using shortcuts : CTRL+C, CTRL+V or from using copy, paste option from the menu.
These website disable copy/paste probably for some safety reasons.
What gets changed in the Windows that disables copy/paste feature. Is there anything in Registry that gets changed or anything else or a website uses any ActiveX...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |