473,320 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Database Selection

WEG
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
Jul 1 '07 #1
3 1699
"WEG" <we******@verizon.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
Jul 2 '07 #2
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...@verizon.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

Jul 2 '07 #3
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...@verizon.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

Jul 2 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
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...
9
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,...
5
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...
0
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...
0
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...
1
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...
1
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...
1
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...
4
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...
1
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.