Hi everyone,
Is there a way to search from a form for a record in one database, then if
it is not found in the first database, the search continues in another
database until the record is found?
Any help is appreciated.
Thanks
3  1717 
"WEG" <we******@veriz on.netwrote
Is there a way to search from a form for
a record in one database, then if it is not
found in the first database, the search
continues in another database until the
record is found?
Yes, you can link the Tables in the different Databases, but the details
will depend on how you are planning to "search". If you are searching a
particular Field for a particular value, it shouldn't be too difficult.
But, just a caution, often people post here asking about "records in
databases" using terminology from other database software, when they really
mean "records in tables" in Access terms. That, too, would significantly
affect the details of the search (and possibly would indicate some design
issues with your database, too)
If you'd care to clarify, it's possible that someone could offer a useful
suggestion.
Larry Linson
Microsoft Access MVP
Hi,
If both tables are identical and you don't care from which table it
finds the match from then you could create a 'union' query and use it
as the recordsource of the form.
but, I do agree with the others, having two tables, one for active and
one for inactive, is not good and it will continue to bite you over
and over.
bobh.
On Jul 1, 5:11 pm, "WEG" <wegra...@veriz on.netwrote:
Hi everyone,
Is there a way to search from a form for a record in one database, then if
it is not found in the first database, the search continues in another
database until the record is found?
Any help is appreciated.
Thanks
Hi,
If both tables are identical and you don't care from which table it
finds the match from then you could create a 'union' query and use it
as the recordsource of the form.
but, I do agree with the others, having two tables, one for active and
one for inactive, is not good and it will continue to bite you over
and over.
bobh.
On Jul 1, 5:11 pm, "WEG" <wegra...@veriz on.netwrote:
Hi everyone,
Is there a way to search from a form for a record in one database, then if
it is not found in the first database, the search continues in another
database until the record is found?
Any help is appreciated.
Thanks
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Simon |
last post by:
Hi,
I am having a little problem with my PHP - MySQl code, I have two tables
(shown below) and I am trying populate a template page with data from both.
<disclaimer>Now I would like to say my skills, especially with MySQL are
rudimentary</disclaimer> However my code (link below) fails, the nested
database call does not return any data and this has me stumped. Any help
will be much appreciated.
Many thanks in advance
|
by: Ruby Tuesday |
last post by:
Which one is better to do dynamic websites using MySQL? Thanks
a.. ADODB, http://php.weblogs.com/ADOdb/
b.. Metabase, http://www.phpclasses.org/browse.html/package/20.html
c.. PEAR::DB, http://pear.php.net/manual/en/core.db.php
d.. PHPLib database wrappers, http://sourceforge.net/projects/phplib
|
by: Jim Cobban |
last post by:
I am trying to create a web page in which the contents of one selection list
depends upon which element in another selection list is chosen, but where
the information to populate the first selection list comves from an SQL
database on the web server.
There are a couple of these situations in my application but, for example,
the first list might be a list of counties, and the second list a list of
states/provinces. Obviously the names of...
|
by: ImraneA |
last post by:
Hi there
Many thanks to those people who contributed to this group, helped me
greatly.
Enclose, my code, hope it helps others :-
Public Function Export_Excel_9(tbx1 As Variant, tbx2 As Variant, tbx3
As Variant, tbx4 As Variant, tbx5 As Variant, tbx6 As Variant, tbx7 As
|
by: Tamer Higazi |
last post by:
Hi!
I am trying to insert with PDO-Sqlite rows through a form. I can do
whatever I want, I don't find the sollution where I made the error.
Perhaps somebody of you could help me?!
However, the database is created with sqlite, and the entries should be
done with PDO_SQLITE. However, no entries are done anyways and I am one
step going nuts, specially because I don't receive no warning or
errormessage on the screen.
| | |
by: BeanCounterCPA |
last post by:
OK, I'm sure there is an easy way to do this, but I am just a novice at
Access and can not find a solution. I have a database that I used to
pull a confirmation sample from by using dollar unit sampling. The
selection works just fine, however, when I finish doing the selection I
want to resort the database in account number sequence and then assign
a confirmation number to each item selected in the database. How do I
set an index in VBA...
|
by: Leanne |
last post by:
I created customized application to Microsoft POS system. I am now
working on the installation package. Any one knows how to get the local
sql database settings, and get user select database, so I can make
necessary changes to the database ( create new tables, update some
records etc.) to make my application work properly.
Thanks
Leanne
|
by: imwhiteandnerdy |
last post by:
i'm hoping I can get some help with adding my combo box selection to my access database.Any Help would be appreciated.
I've been told I need complex binding Basically I just want to add the selection to the database field
DATABASE =cc TABLE =customer FIELD IN DATABASE= custCity
COMBO BOX =cboCity
My combo box name is cboCity
Has the following collection of items linked
|
by: sialater |
last post by:
Hello,
I realise there are a lot of topics related to this problem but many of what I have found has run cold or unresolved. What I have is an addressbook clone where there are groups which have members. I have this formatted in a way where the groups are in a drop down box. Once a group is selected, the two selection boxes below are refreshed with those who are members or non members of the selected group. The user has the ability to...
|
by: Tony Johansson |
last post by:
Hello!
I use VS 2005.
A Datasource can be a Database, Web Service or an Object.
So I select Data->Add New Data Source in the menu. In the dialog data Source
Configuration Wizard I choose Database.
When being asked about Choose Your Data Connection I click New Connection.
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: 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...
| |
