Friends, I have created a form named FRMNEWCLIENTS whose record source
is a table named NEWCLIENTS. This table has a field named FILENUMBER.
I have added on the form a combobox using the third option "find a
record based on my form based on the value I selected in my combobox".
This is great since it allows me to open the form and use the combo to
move to a selected records. My form has also two other fields named
FNAME and LNAME.
My database has also another table, named OLDCLIENTS which has also
fields named, FILE NUMBER, FNAME and LNAME.
It may happen sometimes that I will need to copy some record from the
table OLDCLIENTS to the table NEWCLIENTS and was now wondering if it
is possible to add another combobox to my FRMNEWCLIENTS with a record
source to TBLOLDCLIENTS (which will display the three fields
FILENUMBER, FNAME and LNAME) and that on the onChange Event will copy
the selected record to the three fields (FILENUMBER, FNAME and LNAME)
on my FRMNEWCLIENTS.
Thanks. 2 4626
Paolo,
You would be better off with just one table and a field to identify
whether this is a new or old client. I use a checkbox ticked if old
or unticked if new. Your forms based on new clients would have query
as your recordsource where FIELDOLDNEW has "No" as its criteria. In
other words only the new clients would be available to view etc.
Conversely you could have another form for old clients with the query
based on criteria "Yes" for FIELDOLDNEW. You should have the field
available on both forms so you can mark a client according to whether
they are new or old.
David Mitchell jp***@tin.it (Paolo) wrote in message news:<9f******* *************** ****@posting.go ogle.com>... Friends, I have created a form named FRMNEWCLIENTS whose record source is a table named NEWCLIENTS. This table has a field named FILENUMBER. I have added on the form a combobox using the third option "find a record based on my form based on the value I selected in my combobox". This is great since it allows me to open the form and use the combo to move to a selected records. My form has also two other fields named FNAME and LNAME.
My database has also another table, named OLDCLIENTS which has also fields named, FILE NUMBER, FNAME and LNAME.
It may happen sometimes that I will need to copy some record from the table OLDCLIENTS to the table NEWCLIENTS and was now wondering if it is possible to add another combobox to my FRMNEWCLIENTS with a record source to TBLOLDCLIENTS (which will display the three fields FILENUMBER, FNAME and LNAME) and that on the onChange Event will copy the selected record to the three fields (FILENUMBER, FNAME and LNAME) on my FRMNEWCLIENTS.
Thanks. jp***@tin.it (Paolo) wrote in message news:<9f******* *************** ****@posting.go ogle.com>... Friends, I have created a form named FRMNEWCLIENTS whose record source is a table named NEWCLIENTS. This table has a field named FILENUMBER. I have added on the form a combobox using the third option "find a record based on my form based on the value I selected in my combobox". This is great since it allows me to open the form and use the combo to move to a selected records. My form has also two other fields named FNAME and LNAME.
My database has also another table, named OLDCLIENTS which has also fields named, FILE NUMBER, FNAME and LNAME.
It may happen sometimes that I will need to copy some record from the table OLDCLIENTS to the table NEWCLIENTS and was now wondering if it is possible to add another combobox to my FRMNEWCLIENTS with a record source to TBLOLDCLIENTS (which will display the three fields FILENUMBER, FNAME and LNAME) and that on the onChange Event will copy the selected record to the three fields (FILENUMBER, FNAME and LNAME) on my FRMNEWCLIENTS.
Thanks.
Just add a Yes/No field to your table and then you can show/hide
enable/disable it whenever you want... and keep the data all in the
same table. Otherwise you will have to do ugly stuff to get it back
together... well,
SELECT Field1, Field2,...
FROM TableA
UNION ALL
SELECT Field1, Field2,...
FROM TableB
ORDER BY Field1, Field2,...
possible, but not always ideal. If you add filters to your form, you
can hide any records you want... or just change the rowsource...
(sorry for the typos... typing with my eyes closed...) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ron |
last post by:
Hi all
Just wondered if there's a list somewhere that explains when the events on
forms, reports, etc fire. I'm looking for the order of things. Like, the
first event to fire when a new form is opened is 'a'. Then, 'b' is
activated. So I'd have a=>b, etc. And when does the actual data pop into
the form from the underlying table. That kinda thing.
Also, need the same thing for when things happen for a control on a form,
etc.
|
by: Lee-Anne Waters via AccessMonster.com |
last post by:
Hi,
would someone please help me with this problem.
i have a list box that displays a persons various sub records. what i want to do is to be able to double click a list box record and have it deleted.
i'm just not sure on what code i need to do this
many thanks
|
by: Susan.Adkins |
last post by:
Alright, I must say that the problem my teacher has given us to do has
royally annoyed me.
We are to take a letter *txt file* and then read in the words.
Make 2 seperate lists *even and odd* for the number of occurances...
so the first time a word is entered its going to have an occurance of
one and be in the odd list then it is going to go to the next word see
if its in the odd list. If its not its going to check the even list. if...
|
by: Joshua.Buss |
last post by:
I am trying to move a record from one linked table to another within
access, but I'm a complete beginner to VBA and don't know exactly where
to begin.
I have an access file that has the two linked tables, which each link
to separate SQL databases using separate ODBC connections.
I have a form that has a view of table1 and a set of buttons for
manipulating the data in database1.
|
by: grgimpy |
last post by:
This is MS Access: Is it possible to move the RecordSelectors in a subform from the main form's coding? I want to use a RecordSelectors.MoveLast type code that will move to the last record in a subform, which is based on a query, from the main form's coding.
Thanks
| |
by: subashini Thiyagarajan |
last post by:
hi,
i want to delete a record.hope it is very easy.but same time i want to move the deleted record in to new table for report generation in future.
i succeeded in deleting the record along with timely inputs and saved in a different table.
but now i want to save the deleted record with extra coulms and delete it i mean removing from display.
Any one help me.
|
by: mattmao |
last post by:
Okay, this is just my exercise in order to prepare for the coming assignment regarding the damned Linked List issue...
The task is simple and I am about to finish it. However, I couldn't go around one last bit: how to print out the elements?
Here is so far what I've got:
#include <stdio.h>
#include <stdlib.h>
struct intRecord
|
by: Henry Stockbridge |
last post by:
Hi,
I have a main form (bio info) with a tab control containing three
pages (employment, financial and dependent, respectively.) When I
move record to record on the main form, the correct information is
displayed on the tabbed subform. However, when I go to, say, the
fourth record on the main form, and click a different page on the tab
control, the main form record reverts back to the first record.
Any help you can lend would be...
|
by: Juha Nieminen |
last post by:
Assume we have this:
std::list<Typelist1(10, 1), list2(20, 2);
std::list<Type>::iterator iter = list1.end();
list1.swap(list2);
What happens here, according to the standard?
1) 'iter' still points to list1::end().
2) 'iter' now points to list2::end().
|
by: mukeshrasm |
last post by:
Hi
I wanted to move record up or down or top or bottom if user selects up or down or top or bottom from select box. records are coming from database.
while saving record I am assigning no. to every record like 1,2,3,...45,etc. It is not the case that every record will get increamented no. It may some record can be stored with same value like 35 some like 17 and so on.
and records are retrieved based on this no. means in ascending...
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |