hello everyone, i am new in access and i need your help.
I have a db with 20 tables and for each table i have create a form.
In every table i have 2 same fields , lnumber and st.date.
The search form i want to create must have these 2 fields for search and when i complete those i want to return me the forms with those parametres.
There can be 2 a111 lnumbers but they have different st.date.
For example , i open a search form , i type in the first box a111 and in the second one i want a drop down menu with the st.dates that a111 has.
Then i choose a date .
After i press search and i want to show me all 20 forms with lnumber a111 and st.date the one i choose .
Then i press the form i want and watch and have the option to go back and choose a different one.
sorry for my english , for any specification ask me.
Thank you
10  1367 
What is the difference between all 20 tables? They sound very denormalized. If I'm right, then you would greatly benefit from normalizing your tables. See Database Normalization for more information on that.
Otherwise, you would have to join all the tables together using a UNION query. This would not be a good idea.
the tables represent documents and i formed them like the original documents.
every document has lnumber , st.date , and other varius informetions.
i dont know if that helped because i couldnt understand very well your link about my db but its very helpfull cause i just started to use access ty
Okay, it is as I guessed. What you should have it one table that has three fields: lnumber, stdate, and Document. The Document field would be the divider between the documents instead of having separate tables. Then your problem becomes very simple to solve.
can u help me with that ?
i can create a example of my db to upload , with 4-5 tables-formes to show u how i have done it
zmbd 5,501
Recognized Expert Moderator Expert
sailock
Hello there... although we'll really walk thru the fire to lend a helping hand there is a certain level of foundational understanding that you require in order to get the most out of our help.
To that end, and the request of Seth, I've sent you a copy of my "boiler-plate" providing a set of links to not only the basic tutorials you need now, but also to a series of tools that will make your life easier in the future.
Please work thru the tutorials.
If you are still having issues after you master them, please come back here and we'll get out the big hammer and smash the problem to bits
BOL
Z (^_^)
this is a fast example about my db.
ty very much , i will read them i have plans about access, but i need ur help because i have a deadline .
zmbd 5,501
Recognized Expert Moderator Expert
1) We can help you with specific question, we cannot build your project
2) You really need to have the basics as I've sent you. You simply will "get nothing out of"/understand our help because you will not have the knowledge base to understand nor implement the advice.
3) Please understand, many of us cannot or will not d/l un-requested attachments. This has absolutely nothing to do with who you are... In my case, such d/l are prohibited by my ITSec staff. For many others, it is part of "safe computing/best practices" not to d/l such files. A practical example as to why can be found here http://bytes.com/topic/access/answer...l-ms-products. this unfortunate Member opened a file from a trusted source and is now having all sorts of issues!
can u explain abou the document field u said earlier .
all i want is some help to create serch form with 2 criteria which returns some forms .
is there any example ?
zmbd 5,501
Recognized Expert Moderator Expert sailock<> is there any example ?
Work thru the tutorial I sent you (check your bytes.com inbox). There is an example to what you need to do therein.
We simply do not have the resources to teach you the fundamentals you appear to need…
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: screenwriter776 |
last post by:
Hi, folks -
Perhaps you could help me with a search form I am building. I have a
table with a field in it.
I want to return dates inside two parameters the user enters into a
search form: >!. and
<!.
BUT - I would like the user to be able to SKIP either field, so that a
|
by: misschristalee |
last post by:
I'm having a brain blockage day....
Scenario:
Search Form with 6 text boxes
Query has same six fields
Each has this IIF: IIf(IsNull(!!),"",!!)
with each dictating the correct text box of course.
SQL dictates... If text box 1 isNull do nothing or do this OR if text
|
by: Eddie Holder |
last post by:
Hi Guys, I hope that someone will be able to help
I have a table containing data, lets say products.
I have a form with a text box which serves as the criteria for a query
to search the product name
I would like the form and the query to work as follows
If a leave the field blank on the form, it should return all the data
from the table
|
by: DWolff |
last post by:
I'm somewhat new to Access, and have no VB experience at all (except for modifying existing code where obvious).
I built a data entry form that works fine. Typically, a client will call in and the user has to find his record to add or modify existing data. Originally, I built the form based on a query with an input criteria for the last name and first name. The Last_Name critera is Like &"*" so that partial names will work. The...
|
by: lightning |
last post by:
Hi all,
I'm not very conversant with the vocabulary of Access, so please ask for clarification if necessary...
I am trying to build a search form that allows combinations of search terms. For example, let's say I have three controls on my form; year, keyword, location. Entering a valid value for all three gives expected results from the dataset. However, I'd like to interpret a blank field in the search form as ignoring that constraint....
| | |
by: BD |
last post by:
I am in the process of developing new front end program for SQL
database to replace MS Access front end. I have been unable to
convert the following lines of VBA to C# to find a record in the
workorder dataset from a seperate form based on query presented in
datagridview. I open the workorder form, then click on search form,
then double click the line in datagridview to focus back on workorder
to the selected record by workorderID.
If...
|
by: Mark |
last post by:
Hi All,
I am creating a music database for a friend and have run into a problem.
Within the ALBUM table, I wanted to store the ARTIST_ID rather than the
ARTIST_NAME. To do this, I intended to have have a command button on the
album form which would open a search form (based on the artist table). This
works as I wanted and allows me to get to one record. I then planned to have
a button on the search form which when clicked, would updated...
|
by: Twisted01 |
last post by:
Hello, I am new here and I hope I have the correct forum to answer my question.
I am creating a website for a friend and they need a "Search Form" so that visitors can search for items on the website rather than searching the entire website to find what they are looking for.
I know about my HTML/XHTML and CSS coding and the basic coding for a Search Form. What I need is help with any other files needed to make my Form a workable Search Form so...
|
by: munkee |
last post by:
Hi everyone,
I am using the following code adapted from Allen Browne:
'Purpose: This module illustrates how to create a search form, _
where the user can enter as many or few criteria as they wish, _
and results are shown one per line.
'Note: Only records matching ALL of the criteria are returned.
'Author: Allen Browne (allen@allenbrowne.com), June 2006.
Option Compare Database
|
by: jamesmoore |
last post by:
Hi there,
My code works fine and retrieves information from my database BUT when the search form is empty and I click submit all the information from my database appears.
How can I have it so when submit is clicked nothing happens or a message appears like "Nothing entered"
Thanks a lot!
James
|
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: 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: 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: 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.
| |
