A Form That Can Be Used As A Search Facility

Jun 21, 2006

please excuse the ignorance, im am i novice in the process on learning this.

i have a project that requires to create a customer service log of all the queries that come in.

i would like to create a form that would enable me to search for the following

query number
date
account name
account reference

then i would like it to list all the return so you can select the entry to open it or either go to that record.

any help is greatly greatly appriciated.

thank you for your time

View Replies


ADVERTISEMENT

Partial Text Search Facility

Feb 28, 2008

I’m trying to provide the users of my database with a text search facility.

The database deals with documents, and I’d like the user to be able to search by title of document, with partial text matches. E.g. a title might be ‘Health and safety at work act’ - so searching by Health and/or safety gives this document as a result.

The table is called ‘tblDocTitle’ with the field ‘Title’ containing just that.

Ideally the search facility would be some sort of text box in which the text, and then a button to initiate that search.

Hope you can help

View 4 Replies View Related

Another DMax Question (yes I've Used Your Search Facility)

May 14, 2006

Hello,

I have inherited a database that already has heaps of records in it. One of the forms which is used constantly, has a "BookNumber field" (taken from an underlying table called "Participants". At the moment, this number is entered by hand, but it really could be done automatically increasing by 1 each time a new record is created.

My questions are these:

1. If the BookNumber field in the Participants table is a text field, can I use DMax on it, or does it need to be a number field?

2. If it does need to be a number field, will it cause problems to the existing records if I change the text field to a number field in the table design?

3. Where do I put the DMax statement - in the table or in the form? I am assuming that I put it in the form, but point it to the table is that right?

I know you have answered heaps of questions about DMax before (I think I have read just about every one), but I'm still having trouble figuring this out. I tried putting a text box in the form that had an expression that read: =DMax("BookNumber", "Participants")+1 as it's data, but it just came back with an error message.

Please help...

Thanks,
QuietAchiever

View 3 Replies View Related

Queries :: Calculate Ratio And Then Arrange Result Based On Facility Types

Mar 20, 2013

I have a simple query like below.

Code:
SELECT [score_admit] / SELECT [score_discharge] AS Ratio, facility_type
FROM tbl_test
group by facility_type;

It's really just based on one table, but what I'm trying to do is to calculate the ratio for the scores, then arrange the result based on facility types.

The error I get is a syntax error the SELECT statements.

View 3 Replies View Related

Forms :: Database For Medical Facility - Admit And Discharge Radio Buttons

Apr 18, 2015

I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.

When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.

I realize the I will need some scripting here.

As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.

View 3 Replies View Related

Queries :: Search Form That Uses A Query To Show Results Of A Search

Aug 5, 2014

I have a search form that uses a query to show results of a search, but everytime I press search everything comes up even though I have entered search parameters, even though my search requeries every time and the search used to work before I added new records today. Also when I press the query alone on the navigation pane it asks me for the parameters and then it actually works but it won't when I use my form.

View 2 Replies View Related

How To Create Search Button Using Access 2007 That Can Search From Form

Jul 10, 2012

i need to create a system that can search data using keyword.so i want to create search button that i will create it at form. currently i have 1 table and in that table i have 10 fields which are project_name, doc_ref_no, doc_title, volume, book_no, author, doc_status, box_barcode, filling_location, doc_availability.

i have create 2 forms, one form for user to add new record and another one is to search record. the user can search by enter project name, doc title, volume and box barcode. for project name and volume, i use combo box and for doc title and box barcode i'm using text box.

i want to create search function that can detect from user keyword and even user did not fill in all the form, the system still can search the record.

View 5 Replies View Related

Forms :: Search Combo Box To Search For A Field On Form

May 7, 2013

I have a search combo box to search for a field on my form. But it just goes to that particular record. The combo box is for client id and it has more than one record. How can I have it return just the records pertaining to the client id choosen in the combo box.

View 5 Replies View Related

Search Form With "or" Input Search Posibility?

Jan 31, 2006

HI!

I'm trying to figure out, how to make seach form with one text field, that will accept OR statements. I have one table with fields name, category, and description.
Is there any chance to make search like this:
User will put "part of the string" OR "part of the string2".
Result will be the list of the records that include these parts of the strings in any of the given above fields (name,category,description)
I hope i'm clear enough

Thank You in Advance
for any Advice

View 2 Replies View Related

General :: Bound Form With Search Box - Select Record In Dataset And Display In Form

Aug 19, 2014

I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?

View 1 Replies View Related

Forms :: Create Search Form That Returns Subset Of Other Form Pages?

Sep 25, 2013

I've built a PostgreSQL database for some ecology data and am trying to use MS Access 2010 to make a front-end for it.

I've created a form to display site data; it includes such fields as site ID, site name, county, state, landscape, etc. (There are more, but if I can get the idea down with a couple of these, I should be good to handle the rest). One can click through the form and see 14 pages of site details, which is fine because there are 14 sites.

What I want to do now is make a search form in which one can enter values for site ID, site name, county, etc, and somehow get the pages of the display form that match those values. It's not terribly important to me how that output looks - whether it's a list of matches that allows for clicking on a match and showing just one page of the display form, or whether it's a filtered subset of the display form pages that one still clicks through to view them all.

if there is code to write, where do I type it? Do I start my search form by making a form with the search fields as values, or is there some other way? How do I make those search fields into search boxes rather than display boxes?

View 14 Replies View Related

Forms :: Search Form That Fills Separate Textboxes In Another Form

Aug 15, 2013

I have a form with two textboxes called: txtAptDep, txtAptArr.

On their right side there are two buttons (btn1, btn2) to open a form called frmAirportSearch. It allows to choose (from a listbox) the airport to be filled in those two textboxes.

Now, if I search for an airport pressing btn1, I want the airport to be returned into txtAptDep, while if I open the form by btn2, the airport choosen must be returned in the second textbox.

View 7 Replies View Related

Creating Search Form And Show Results Inside The Form?

Jul 27, 2015

creating a searching form and to show the results inside the form! It's like a Library type searching. u want to search for some type of monument or so and it shows the results, all the info, photos and that!

View 6 Replies View Related

How To Search Sub Form Records From Main Form?

Nov 12, 2006

The situation is like this:

I am designing a db for a dental clinic. I created 3 tables as follows:

1.T_Patients (P_Code(PK) and other fields)
2.T_Diagnosis (P_Code(Fk), ToothRecId (PK) and 32 text fields for 32 tooth named (UR1 to UR8, UL1- UL8 for Upper left / right Arch and LR1 to LR8, LL1 to LL8 for Lower left / right Arch)
3.T_Pmts (P_Code (FK), PmtRecId(PK) and other fields

I created one main form based on T_Patients tbl and similarly another 2 forms from other 2 tables. In the main form I placed 1 sub-form and 2nd sub-form. Bothe the sub-forms are Master / Child relationship on form over P_Code field in the main form.

Single character length has used for all the 32 text fields in table T_Diagnosis. So only one single B, C, D, F, M could be entered.

Normally we search patient’s profile by patient’s code or by name that displays in the main form. But the client needs to search patient’s record by tooth criteria.

There may many tooth fields in the first sub-form that are null and only some of them with any one of the B, C, D, F, M character. Bcz there is very rare chances of damaging all 32 tooth of the patient.

Now my clients want to search based on the data which are B, C, D, F, M characters. Means once he types C (stands for Cavity) in a search text box then it should bring all the sub-form records that hold value C in any of the 32 fields.

1.How can I do this when the search based on SUB-FORM and not over the main form?
2.The entered criteria value might by in other field also. Like say if entered C then this value may be in any of the 32 fields. So how it would bring all records?

I am confused how to do it. I attached a pic of my form for your ready ref. :confused:

I would really appreciate if somebody could help me.

With kind regards,
Ashfaque

View 3 Replies View Related

Search Code Work On One Form But Not The Other Form?

Jul 18, 2015

* This code works to search frmMember for criteria found in tblMember:

Private Sub cmdSearch_Click()
If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then
MsgBox "You must select a field to search."
ElseIf Len(txtSearchString) = 0 Or IsNull(txtSearchString) = True Then
MsgBox "You must enter a search string."

[Code] ....

* But this next code which I have copied and Pasted to frmEventInput, then renamed the frm and tbl, retrieves the same criteria as the above (tblMember) instead of the tblEventInfo...

Private Sub cmdSearch_Click()
If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then
MsgBox "You must select a field to search."
ElseIf Len(txtSearchString) = 0 Or IsNull(txtSearchString) = True Then
MsgBox "You must enter a search string."

[code]...

What am I missing?

View 3 Replies View Related

Form Search!

Oct 11, 2006

Hi
Can anyone can help me with a search algorithm?....
I have a form with multiple controls (textboxes and comboboxes). In one combobox i have 3 values: legal entity, employee and and individual. Basing this values another subform appear for the search: for the person a search can be by its name or ss#; for the employee the search can be for by its contract number and name, etc.
I have a button "search". I need a search algorithm based on the values entered in text or comboboxes. The result of the searc will be displayed in another form containing as list with 6 columns containing data about files e.g a file for a employee can have: name,number,data,status,etc and this values are displayed basing on the values entered in those controls.

View 2 Replies View Related

Search In The Form

Jun 23, 2007

hey

i have a main form ( there is link to my forms and my reports).

in one of my forms , i have a id field.

i want to do a macro or something like these that will do this things :

1-go to the form

2-go to the id field

3-push ctrl+f (search in a specific field - the id field)



how can i do this ?

View 4 Replies View Related

QBF Form And Search

Feb 28, 2006

Hello all:

I have a form that is attached to a query.

In my query, I have the following criteria:

[Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null

But it only allows me to search that particular field either when I put in a blank or when I put in something like: cad*

I want to be able to also search like this:
*cad*
not cad*
cad* or pdf*
*cad* or *pdf*

Is this possible?

Thanks for your help!

View 4 Replies View Related

Need Search Form Help?????

Mar 23, 2005

Hi All!!

I am very new to this access coding stuff, please bare with me. I am looking for someone to help me with a small project I am working on. I have the tables and forms already laid out. I need help with the coding part of it. Basically, the header part is where I would enter a search criteria to look up a street address. I have four text boxes and a search button to the right. and hit the search button and it would search and put the results in the "detail" text boxes.

In the Detail part of my form I have several more text boxes I am using for the search results. If anyone has the time to look at it and can give me some feedback on it I would appreciate it. I have attached the file, it is access 2002. Again anyone that can help with this, I would be deeply thankful.

View 2 Replies View Related

Search Form

Apr 12, 2005

Hi Everyone!

My question is: how can I automatically switch to filter design mode on a form using vba? I'm designing a form which will be used initially for searching, and I don't want my users to have to click on the "filter by form" button. Is it possible to automate this? Can the apply filter be automated as well?

Thank you for your help

Simon

View 6 Replies View Related

Search Form

Apr 28, 2005

OK so ive got my search form working. But I need to refine my querry, at present it reads

Like "*" & [Forms]![Search]![Box No] & "*"

So if I put in E1 it will return E1, E11, E12, E13 i.e anything with E and 1 in it.

Can it be refined to only give what I ask i.e if I ask for E1 then all I get is E1. I'm sure this is really simple, but!

View 1 Replies View Related

Search Form

May 17, 2005

Could some kind sole please take a look at my DB and tell me why the search engine only searches by date. I'm at the end of my patiance with it and I know it's going to be something simple!

View 2 Replies View Related

Search Form Help

Jun 8, 2005

I have a search form based on a query. the form works. i would like the form to be empty when i open it, how can this be done?

Thanks in advance!
Tim

View 3 Replies View Related

Search Form Help

Jan 7, 2006

hi,

i need help with a search form i am trying to make.

i've looked at the sample search db on this site and i want to achieve something very similar to that..but i don't know how to do it :confused:

i have 2 tables:
employee
department

i want to be able to search a field(employeename) using a textbox - then when i click search button, the names that i have searched should appear in a listbox and all other info related to that name should appear in a query...

its very similar to the sample search db but i dont know how to relate the textfield to the list :p

any advice is appreciated, thanks.:)

View 1 Replies View Related

Search Form

May 9, 2006

I'm making a form for searching which opened from a main form, displays results in a listbox and repositions the record of the main form accordingly.

I have the listbox displaying all the results and everything, but I've run into a problem repositioning the main forms record. The results consist of an ID which is the primary key of the main forms datasource.

Is there a way to return a value from a form?

I'm opening the form with the docmd.openform method.

View 2 Replies View Related

Search Form

May 18, 2006

Hi I tried to adapt an example of a search form and Im getting a Syntax error. Ive attached the file so that hopefully someone can point me in the right direction. To get to the error open the file select 'SEARCH' write any letter in the 'EXERCISE NAME' field. then press search then it gives a Syntax error. All help gratfully received. I realise I need to set it up to search all the other criteria but I was trying to get one working first. Thanks!

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved