473,320 Members | 2,048 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.

Need to Set up Search Button on Form

hi,

iam using access for the first time and need help setting up search button on the form.i have employer and employee tables.so the employer table will be have many different groups of employees...each belonging to a different group..
i have the relationships between the 2 tables.
so when i search on the employer group name then i should be able to get all the data...
please give me a detailed explanation....i am new to coding....
please help....

Thanks
jason.
Sep 28 '07 #1
7 2435
nico5038
3,080 Expert 2GB
Hmm, not really clear how you want to search.

Searching just employees will be simple when defining a search combobox using the wizard (just use the "last" option on the first wizard form).

When you want to see the groups the employee belongs to, then just use the subform wizard on the employee form to add a groups subform and accept the proposed linking field. Access will thus sync the groups for you.

Getting the idea ?

Nic;o)
Sep 28 '07 #3
lee123
556 512MB
oops try this one i think:

http://www.thescripts.com/forum/thre...le+search.html
Sep 28 '07 #4
look at this:

/www.thescripts.com/forum/thread703207-simple+search.html
hi,

i tried working with the code u gave i modified it ...but not clear whats going on....

My tables have colums like

Employer --- EmployerNum,EmployerName,EmployerAddress,EmployerC ity,EmployerState,EmployerZipCode....

Members----

MemberNum,MemberName,MemberStartDate,MemberEndDate

So i designed seperate forms for them...

But i want to view all these details on one single form with a seperate search button ..

Say the search button on EmployerNum field then i should be able to see all the results from both tables.....

Can u please help....

Thank you in Advance.....
Sep 29 '07 #5
Hmm, not really clear how you want to search.

Searching just employees will be simple when defining a search combobox using the wizard (just use the "last" option on the first wizard form).

When you want to see the groups the employee belongs to, then just use the subform wizard on the employee form to add a groups subform and accept the proposed linking field. Access will thus sync the groups for you.

Getting the idea ?

Nic;o)
hi,

i tried working with the code u gave i modified it ...but not clear whats going on....As i dont have that good coding knowledge and iam new in this field .....

My tables have colums like

Employer --- EmployerNum,EmployerName,EmployerAddress,EmployerC ity,EmployerState,EmployerZipCode....

Members----

MemberNum,MemberName,MemberStartDate,MemberEndDate

So i designed seperate forms for them...

But i want to view all these details on one single form with a seperate search button ..

Say the search button on EmployerNum field then i should be able to see all the results from both tables.....

Can u please help....

Thank you in Advance.....
Sep 29 '07 #6
oops try this one i think:

http://www.thescripts.com/forum/thre...le+search.html
There can be thousand members under each employer.......
Sep 29 '07 #7
nico5038
3,080 Expert 2GB
You'll need to have an employerID in the personel table to be able to link them.

When searching for just employees you can create an employee table and add a searchbutton with the button wizard.

When an employee can serve for multiple employers, then a relation table with employerID and EmployeeID (MemberID?) is needed.

When an employer and an employee need to be searched, then you'll have to use VBA or create a UNION query to hold the ID and namefield(s) you want to search for.

Best to specify explicitly what your needs are, to make it clearer how we can help.

Nic;o)
Sep 29 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: bdawg | last post by:
what i want to do is create several radio buttons and a textbox for searching purposes. the search will perform a search depending on which button the user selects. here is what i have now: ...
9
by: Christopher Koh | last post by:
I will make a form which will search the database (just like google interface) that will look/match for the exact name in the records of a given fieldname. Any suggestions on how to make the code?
2
by: Uninvisible | last post by:
I have put together a db for a law firm to keep track of counterfeit activities. There are four parent tables: tblContact tblTransaction tblAction tblFile I have created a form,...
2
by: Rik Brooks | last post by:
My boss has put a couple of restraints on me that has me tearing out my hair. Here is my problem. On a particular asp page I need to use server side controls so that I do some fairly complex...
1
by: ratnakarp | last post by:
Hi, I have a search text box. The user enters the value in the text box and click on enter button. In code behind on button click i'm writing the code to get the values from the database and...
2
by: rufpirat | last post by:
Hello I'm in the middle of trying to build an "AD phone book", and this being my first try at asp.net, I have a few questions that I hope some of you might be able to help with: 1. Is it...
9
by: AMBLY | last post by:
Hello ! Hope someone might be able to help me with this one. I run Access2000 on XP. I have a form : frmONE- which contains a txt field: ctrCTN from my table/database. The values in ctrCTN are...
1
by: ebernedo | last post by:
Hey guys, I have two main questions First off (pictures are kind of blurry) I have this table http://i197.photobucket.com/albums/aa109/ebernedo/DiscTable.jpg And thats my database I use my...
5
by: Fran Jakers | last post by:
Hello all, I'm new to all this and I could really use some help. I've searched the web but cannot find an answer. I have an HTML form with 3 radio buttons and a search field that calls a...
6
by: Mark B | last post by:
I have a function that looks up a SQL table to see if a search term matches. It works fine but so far there are two things yet to work: 1) After entering a search term and pressing Enter, nothing...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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.