I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table using a form for easy access to a particular patient so that I can update fills?
Thanks for those who help!
I am new to access and am trying to setup a small database with names and phone number in it. I would like to be able to set up something to search the database for the names that I type in and display the records that have the same name. I have entered all the names in a table but cannot find any info on what I should do next. Thanks for any help you can offer.
View 5 Replies View RelatedSubject: Searching all fields in a table
Hi, All,
I have to send an Access table consisting entirely of Text fields to another company for automatic list cleansing. My table MUST NOT CONTAIN even a single comma, else the whole procedure will go Iraq-shaped.
Therefore before sending the table, I must apply FIND to each field (column) to search for that one comma that may have slipped in.
So far I know only how to search one column at a time. Is there a way of searching the whole table for commas within Access, rather than first exporting the table to Excel?
Thanks for your help.
Adrian
I am trying to do a query that is set up like this:
I have a table with several fields which represents company vehicles. In each field, a persons name is inputed, unless no one is using the vehicle, in which then the field is blank. Each record represents one day, so the date is the primary key.
I am trying to make a query look at each field, and pull out one persons name, and show which vehicles that person will use over a date range. I have a form setup where you put in the date and the name you want ([Forms]![staff printing]![staff name]), and I am trying to tell the query to look at the form field and bring back only the results with that persons name.
Here is an SQL portion:
((Vehicles.[901 Morning])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[901 Afternoon])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[961 Morning])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[961 Afternoon])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[979 Morning])=[Forms]![staff printing]![staff name]) AND ((Vehicles.[979 Afternoon])=[Forms]![staff printing]![staff name])...
The date portion is working fine, which is why you do not see it here... it is only the portion where I try to pull the name for each vehicle that I have a problem.
I tried putting an "OR" where all the "AND"s are, but no luck.
Any thoughts?
(And let me know if I was not clear)
Clint
How can I get a PK in another table, based on searching for it based on 2 values. By searching with 2 values you will always get only 1 record.
READ BELOW FOR SITUATION
My Problem on my form:
The user enters 2 values, after entering the 2nd value a Unbound combo box runs a query, which searches for these 2 values (unique), that appear in a separate table.
These 2 values are unique toegether, but records in this separate table have another field, its Primary Key (AutoNumber), used to identfy the pair.
So back to this Unbound Combo Box that searched for the primary key of the 2 values entered. Now Only the Primary key can be selected from the combo, the value that I'm after.
But since there will only be 1 option (being unique), how can I have the PK value aready stored in an Unbound text box, as opposed to having options in a Combo box?
Hi,
I have a form that runs a parameter query to search for university name and then displays 2 fields, university name and course name.
I am having difficulty with a search button that i have on the form called search_command; it is supposed to run the exact query as when you enter the form, it does this but displays the result in a dataheet, i want it to repopulate my 2 text label fields as mentioned above.
In addition i want then to be able to go to a specific record, select it and then press a button to append it to another table. i ahve not started this part yet
Can anyone please help ?
i am a beginner..
how i can write a code in a afunction that search
a record in a table according to some conditions
example:
i hv table employee that contains Title field which can have one of 3 values:Admin, Rep or Driver
i need to search the employee that has his type = admin
i can have one or more records that have this type...
so how to find first one, last one and all?
i have a form with a control for "repair type" and a subform that has a query that searches a table holding vehicle repair records. on the form the user can enter up to 5 repair types, [repair1], [repair2], etc.. Then the control on the form holds each type of repair to search by. Since the user could use one or all five repair fields and put repair types likes brakes in field one on one record and field 5 on another record, how do i search to just pull out those records that have the specified search criteria?
If i put in [form]![control] in each of the 5 criteria in the query it comes back with no records, because it it looking for that type in every repair field rather than once between the five fields?
I already have many table for each month , JanuaryT-DisemberT. I'm using simple form to key in data inside that table. Inside to that table (JanuaryT-DisemberT) have project number data i want to notice pop up when i try key in if that project number not valid..
example
JanuariT
Name -Project Cod- Validation
John -2012ABC - Not valid
Michel-2013WER-Valid
Mike-2014TERG-Valid
FebruariT
Name -Project Cod- Validation
Ann -2011AAA - Not valid
Sam-2012BCB-Valid
Tony-2013TEC-Valid
What i want to do is when i want to key in data in MacT using Form with ADD butoon, some notice will come out if .... for example : Daniel-2011AAA or Jony-2012ABC the notice will come out " THIS PROJECT COD NOT VALID, PLEASE CHOOSE ANOTHER COD". it something like notice to tell me that project cod already not valid yet. It look like "automatic searching" data for every table. It Is possible to do like this?
I have a database that I am creating for my work. I have a form that I am trying to get it to search the information from a table to pull the record on the form. I would like to search infomation such as employee id and wanting it to pull that information from the table.
View 7 Replies View Relatedhttp://lemmikki.uw.hu/promotion.JPG
Okay, this is how my form looks. I have thousands of records, but in a special way. I would like to make a search having the email, when and what together. The table is like this:
email1@xyz.com 20050712 E0001
email2@xyz.com 20050712 E0001
email3@xyz.com 20050712 E0001
email2@xyz.com 20050712 E0002
email3@xyz.com 20050712 E0002
email1@xyz.com 20050720 E0003
email2@xyz.com 20050720 E0003
email3@xyz.com 20050720 E0003
email4@xyz.com 20050720 E0003
email1@xyz.com 20050720 E0004
email4@xyz.com 20050720 E0004
Okay, there's a key for finding the records, but searching by it is quite difficult. Searching by these 3 data would make it easier. But it's quite difficult for me. I would like to have 3 lists (on the picture I have 2 so far) and a button that I can press and the record would come out...
Can someone help me?
Hi,
On my form i have a text box (txt_search) and a search button (cmd_search). Now when the button is pressed i want it to go to another form (that bit is done) and display the search results (the bit that is hard).
How can i get it so that when i click the button. It searches some predefined fields with the text in the txt_search once the button is clicked.
Thanks
k0r54
I was looking for help to find out how i would put a search facility on a form
Ive written a query with a parameter where you input a persons name in order to find it in a table
the porblem is when i base a from on this query it brings up the parameter asking me to enter the name, the query works fine it does what i want it to do.
i want to be able to open the form and if i need the facility to enter a name an d bring the details up in a sub form
any ideas?
I have used one of the members' code which was posted in a tread before to create a search box in a form. This code works perfectly when the form itself is open. Otherwise, when I put this searching form along with other forms in one navigation form, I get the following error: "Enter Parameter Value: Forms!FRM_SearchMulti!SrchText"...The code that was used for the Search box is as following:
Private Sub SearchFor_Change()
'Create a string (text) variable
Dim vSearchString As String
'Populate the string variable with the text entered in the Text Box SearchFor
vSearchString = SearchFor.Text
[code]....
I have an access form and there is a textbox in which i enter a string and have a search button so I need the onclick event procedure to search a string from my table. so how do i do it in access 2010.
View 7 Replies View RelatedI'm trying to search for a variable (varCod) in a table(SerialNumberCustomer) but I want to only store the returned variable in an array if its shipDate is between 9/30/2001 and 10/1/2012
this is what my code looks like so far:
Set rst = CurrentDb.OpenRecordset( _
"Select * from SerialNumberCustomer WHERE SerialCardId = " & varCod & " AND (ShipDate BETWEEN #09/30/2001# AND #10/01/2012#) ")
The line of code works and it returns all of the values in SerialCardId where it's = to varCode but it doesn't go through with the shipDate requirement. It's instead returning all of the dates with the found value.
Hi all. This is one has been troubling me for quite a while and once more I seek for solution to the right (hope so) place.
I have imported from a Excel a table and based on that table I created a form. But when I try to add a combo box on the form header in order to search for a particular record to display on screen the error on the attachment occurs. I didn't add even a single character of code, and the error message seems weird.
I tried doing the same thing on another pc (an older one) and it is working fine...I've added search via combo boxes in the past without any problems but this time something isn't going right.
Any clues?
Hi,
Me and my friend are making a database for a DVD rentals business and we're having trouble with searching within a form. We want to be able to perform a search in a form by clicking on a button within the form rather than using a query or filter, and we want the results to be displayed within the form in the available fields.
Many thanks!
I have a form I am using to search for records based on any number of criteria. The one I am having a problem with is a model number search. I would like to search based on a from value and a to value.......for instance........let's say you had the following items:
bird
birth
bill
birdbath
bite
bitter
If I want to search for values from bir to birt, I would get bird, birdbath and birth. How can I code my query value to look for values between two text boxes in a form?
I have a table containing customer details and a form which allows you to view them like records.how i could make something that enables me to search their fullname that would take me straight to that record.
View 2 Replies View RelatedI have a form that assigns an Auto Reference Number to each record. Now the records are later edited. Is there a way that I can have the user enter the Reference number and come directly to that particular record that needs to be changed in the form. Like a dialog box that asks Enter Reference Number or something.
View 2 Replies View RelatedHello All
I've been looking and abusing the search function on this forum for this particular obstacle but no luck.
The client im building a database for wants a search form and everyone who used the old system are used by using *'s in their search criteria.
I know how I can use *'s in queries but its fixed (I think).
I want to let the end user use * when they want to pin down a particular product. So they just type in a part of a word and use a * at the end, middle or before.
Or should I just abandon the idea of using them in input form controls?
I know this works because I have seen it before, too bad I had no access to the source of it.
I hope someone comes up with some ideas, pointers or howto's
Thank you guys in advance
Hi everyone, i'm new from here!
i'm doing one of my school project, but i got a big problem with this.
from the photo, i've created a form like this. and i want to have a search system, searching data from table. so i've created 2 input box with 2 different searching methods.
both methods work the same. type in the Stuff ID and then click the search, datas will show like this.
but the problem is, i can't get the Search button working, whenever i press the search, it said that the Stuff ID can not be found. but i've that stuff id in my table!
Could anyone show me a solution of this. or is this method good? coz i'm not doing that with the VBA!
PS... sorry for chinese words. coz i'm from hong kong!
Hi,
I have a form that is based on a query with many fields. As an example there is a field called "Medium" which contains values such as "Oil on canvas", "Oil on wood" etc.
At the moment I have a filter which works fine but this doesn't allow me to search all records which have the word "Oil" as part of the Medium.
I would like to be able to search all fields on the form. I have looked at a few exmaples on the forums but could not find one that applies to my scenario.
Can anyone help?
Thanks in advance.
I have a query and need it to filter between to dates that are entered into a form.
The dates are long date fields (dd/dd/dd hh/mm/ss)
I've used the following search criteria
Between #" & [forms]![frmSearch]![txtTimefrom] & "# And #" & [forms]![frmSearch]![txtTimeTo] & "#
But clearly I am missing something because when I go and save the query it comes up with the following error "the expression you entered has an invalid date value".
Been trying loads of different expressions but nothing seem to work.
I would like to filter a table with 3 fields: Name, Surname, and Chart number.I would like to have the results in a subform designed in the same form.In fact every patient can have several admisions (1, 2 or more).I have arranged the main form named men with 3 text unbound box (name, surname, CCN) and 2 button clear and run the query.I have created a query .The problem is that when i push the button the SQL starts and a different window is opened. I would like that when you type the name for example in real time the subform should select the record with that criteria. Moreover I would like that when in the subform appears the records with the criteria the users could click on the selected record to open a different form.
View 3 Replies View Related