Forms :: Checkbox / List Box And Unbound Keyword Search

Aug 7, 2013

I'm relatively new to Access 2010. I have an excel spreadsheet that I've converted into an access table for the purposes of creating a user friendly form for the end user to search for relevant criteria to retrieve a list of records that fit the requests. There are two main search functions: unbound keyword search (90+ keywords), and either a series of checkboxes or one list box that lists specific countries/regions matched in a column (columns, as I will get to shortly). The region selection is bound by a selection of 15 countries.

The key is each record can correspond to more than one country. This, one record can have "Belgium, Germany, brazil" and the next record can just have "brazil". Thus if someone selects brazil, the query must retrieve the Belgium Germany brazil record in addition to the record that covers just brazil. I've tried to do this with a concatenated column that list all countries and a text box search, I've tried to do this with individual checkbox columns for each country with checkboxes in the search form...and I can't get it to work. I don't fully understand the criteria to set for checkboxes or list boxes. What would be the best way to build this form, an how?

View Replies


ADVERTISEMENT

Queries :: Add A Box On Search Forms To Search 3 Cells Of Record For A Keyword

Jun 10, 2013

I currently have a database with a few search forms. I recently attempted to add a box on one of my search forms to search 3 cells of a record for a key word. What happens is when I go to search, say for P0442, it does not bring up all of the records that contain that keyword in the 3 cells I have outlined. If I step down the code in the OR boxes of the query, it seems to work better but then for some reason my other search criteria , (Tracking number etc) does not work. I will upload the database for reference. I am currently working on the Search(View Only) and that is where you will find the query to work on.

View 3 Replies View Related

Forms :: File Search By Keyword

May 24, 2013

I have search the web and came across something pretty similar to what am looking for (URL...), unfortunately this database sample does not work with my Access 03, so I cant really play with it.

What I want to do is have 3-4 Paths save on my form to folders on our office server, this is were we keep client files. I like to have the ability to search for individual folders by either client ID or name or even partial name if possible too, knowing that it may display more than one folder for the employee to pick and open.


I have included a picture of the form ...

View 2 Replies View Related

Forms :: DLookup For Unbound CheckBox

Jun 29, 2014

On my Login form I am trying to get the status of a user. Form and checkbox are unbound.

tblUserSecurity_Sec
userID is the UserName.
Field (Active) Data Type is Number, Field Size is Integer

CheckBox is (chkactive)

If DLookup("[Active]", "tblUserSecurity_Sec") = -1 And [userID] = (Me.txtUserID) Then
Me.chkactive = -1
End If

View 11 Replies View Related

Forms :: Update Table With Unbound Checkbox

Oct 17, 2014

How do you update table with unbound checkbox? I'd like to add basic yes/no, true/false on update. Currently I'm using a workaround like this

Code:
If Me.chkInkt = True Then
status = "true"
Else
status = "false"
End If

Which is ok if there's one of these, but sometimes I have more...

View 3 Replies View Related

Forms :: Add Additional Filter To Unbound Form - Checkbox?

May 27, 2015

I need to add an additional filter to my unbound form and can't seem to get the syntax right -

I have a text field in my form "[B Style]" that has either a "Y" or "N"

I want to add a checkbox on my main form where, if checkbox=True then [B Style]="Y"

Private Sub ckBStyle_Click()
Dim stFilter As String
Dim stDocName As String
stDocName = "Modify_OpenItems"
If Me.ckBStyle.Value = True Then
DoCmd.OpenForm stDocName, , , ("[B Style]" = "Y")
Else: DoCmd.OpenForm stDocName
End If
End Sub

stDocName is opening but is completely blank.

Incorrect syntax?

View 1 Replies View Related

Keyword Search

Jul 13, 2005

Hi all.

I want to set up a 'keyword search' facility on my dbase. I would like the user to enter a keyword in a dialog box and for this to then open my main FRMContractInfo form with a recordset that shows all the records where this word appears in any or each of four fields (Summary, Methodology, Lessons, Successes). I am a bit confused about how I should approach this, can someone offer me some advice?

Do I:

a) set up a Query that references the text box on the dialog box and code it as the open form's recordset
b) write the SQL for the form in the code?

Or are neither of these approaches correct? I've tried both and neither seem to work - but I think I've got my syntax all wrong because of trying to use Like and the wildcard (*) character...

View 1 Replies View Related

Keyword Search!

Oct 17, 2005

Im trying to add a keyword search to my page - I've added a button and it works fine in bringing up the "find" dialogue box.

However this defaults always to the "whole field" option, whereas what I want is it to default to "any part of field".

Can this be achieved, if not, is there another way of doing this?

Thanks
Gazz

View 6 Replies View Related

Keyword Search Query

Apr 21, 2006

Hi

I hope someone can help me. I am using Access 2003 to create a database to keep a track of projects in my craft magazines.

I have a table that gives the magazine name, issue no, project name, page no and keywords. When I enter my data I will use various keywords to describe the project. For example, for a football card for a teenage boy I would use keywords such as football, boy and teenager.

What I need to be able to do is have a query based on this table that if I search for "football" it will pull up all records where I have used football as one of the keywords.

In my current query I can do this providing "football" is the only keyword I have used, but if I have used more than 1 keyword in my table then my query will not show any results.

Is there any way I can do this?

Hope you can understand what I am asking, and if someone can help, I would appreciate simple instructions as I am not very experienced with access

Thanks

Kathie

View 2 Replies View Related

Query To Do A Keyword Search

Jul 6, 2006

How do I get a Query to do a keyword search in a Table? So far I get it to do a search but it has to match a specific Field in it's entirety.

View 8 Replies View Related

Multifield Keyword Search

Jul 7, 2006

HI, Im trying to create a keyword search based on the data in several fields. The below command works well for searching one field, but I want to search several at once. Any help would be great. Thanks!

What you need is a parameter query. In the criteria space in the desired field in your query, put the following: Like "*" & [Search by word:] & "*"

When you run the query, a message box will pop up that says "Search by word:", and then you could type in "mountain" or "goat" or even just type in one or two letters. To make it more/less specific, play around with those wildcards.

View 5 Replies View Related

Keyword Search Query

Nov 13, 2007

I would like to have a search box in which someone can type anything and it will search through a few tables to see if this word appears, and then return information from that record so I know who it belongs to. I have a query written that has all of the fields from all of the tables that I want the search to cover, but now I am having trouble connecting a button to the query so that it runs the query and puts the word as the "Like" criteria. I can make the button run the query, but I didn't know if I have to put Like * &[TextBoxName] & * in the criteria of each of the possible fields? I would appreciate your help with this. Thanks:)

View 1 Replies View Related

How Do I Search On A Keyword Within My Table??

Dec 22, 2007

Hello all, once again I would very much appreciate anyones help on what may be quite a simple issue,, my problem (or one of!!) is as follows:
I have a table that contains approx 3k records I wan to run a query that allows me to select a certain number of fields with a group. From this I mean, I have all records grouped by discipline, firstly its easy for me to determine the discipline I require (I do this in the design view by adding the discipline number in the criteria row.) next I want to find a certain number of the records that are within my chosen discipline,, the records I wan to see all contain the word ‘alignment’. I tried entering ‘alignment’ on the criteria row but that didn’t get me anything,, the field that contains the word alignment also has many other words listed…
Please help
Many thanks
Jon

View 3 Replies View Related

Keyword Search Problem

Jul 3, 2006

I am trying to do a keyword search. I got it working but I need it to look at more than just the first word in the table.....

View 4 Replies View Related

Keyword Search Query (example Attached)

Mar 18, 2008

Hi All,

As shown in the attached database, I have a multiple criteria query with a front end (see frmIssue). I am trying to add a keyword search on the field 'Issue' by having an unbound textbox in frmIssue and linking it with a 'Issue' field in the query 'MyQuery'.

An example search would be looking for an issue with the keyword 'misfiring' in project 'A'.

However, having tried the Like expression on the field 'Issue' a few times, I'm still having trouble making it work. Any suggestions would be greatly appreciated!

Thanks,
Stephen

View 2 Replies View Related

Forms :: Checkbox To Control List View Using VBA

Sep 21, 2014

I have a form (frmHourEnter) with a combo box (Staff_ID) that lists staff members from a table (tblStaff). The table form (frmStaff) has a checkbox (ckEmploy) which indicates if a staff member is still employed. If the checkbox is checked how do I exclude that staff member from the combo box Staff_ID in the form frmHourEnter?

View 8 Replies View Related

Modules & VBA :: Keyword Search In Table Of Data

Apr 29, 2014

I have a table of data lots of it (Table A)!!!

In another table I have a list of key words (Table B).

I need to somehow show all the records in Table A that contain (full words only (ie not part of a word) in Table B.

View 3 Replies View Related

Get A Multiple Keyword Search Query Working

Mar 4, 2013

I am trying to get a multiple keyword search query working.... the single search is working however when i use the Multiple Keyword search the data sheet does pop up but no matter what i put in i just get a blank table and under ID it says "NEW"

The Keywords Column has a bunch of keywords separated by commas on each row. Sometimes there will be the same keywords on different rows under the keyword column... and i want it to return any rows that have 1 or more of the keywords in it or if it is null just to return them all....... this is the statement I am trying...

SELECT Sea.ID, Sea.Category, Sea.Title, Sea.Author, Sea.Organisation, Sea.Date, Sea.Keywords, Sea.Reference
FROM Sea
WHERE (((InStr([Keywords separated by commas,Blank=All],[Keywords]))>0 Or (InStr([Keywords separated by commas,Blank=All],[Keywords])) Is Null));

View 3 Replies View Related

Forms :: Search Unbound Column In Form Combo Box

Jun 16, 2014

I have added a combobox to one of the forms in my customer database using the "find a record in my form based on a value in my combobox" section of the combobox wizard.I have a number of columns in the combobox (the primary key is the bound value, and I have unbound columns for first name, surname etc).

I sorted the records in the combobox by column 3 (surname) so I can scroll through the list and choose surname instead of having to memorise customer numbers. Now I have more than 1500 records (with more on the way), scrolling through takes ages, and I was wondering if there is a way to adapt the combobox so I can (for example) type the first letter of a surname into the box and be taken to surnames beginning with that letter, whilst retaining the primary key as my bound column?

My initial thought was to base the combobox values on a query, and make the query prompt for a starting letter (or string of letters) each time it runs, so it only displays the query results in the list, but I was wondering if there is a neater way to do it?

View 2 Replies View Related

Forms :: Open Attachment In Unbound List?

Jun 10, 2014

I have an unbound listbox in my details section of my form and it will display items from the database that I have selected. There are 19 in all. If I double click the row, the edit form pops up. If I right click I can sort the columns. I want to have a single click that allows the user to open the attachment in that list. I am not sure how to code this.

View 2 Replies View Related

Forms :: Set Up Navigation Form - Search Unbound Subform Records

May 16, 2014

have set up a navigation form which contains 5 unbound subforms that are made visible or not visible thru the on click event of command buttons on the main form, the subforms have a command button with an embedded macro that searches for a record based on what has been keyed to an unbound text box on the subform, this works fine when the sub forms are opened independently of the navigation form but when the search is done from within the main form, the error message is, "....cannot find the referenced from frmAQIFAList" subform, I tried referencing the main form name infront of the subform name but this also doesn't work, perhaps this would be better with code ? or is it because the subforms are unbound ?

View 4 Replies View Related

Queries :: Keyword Search - Find Field Names Of True Checkboxes

Jul 10, 2013

I've recently finished constructing a database that uses forms with checkboxes i.e. when a user opens a form there are several checkboxes associated with labels, but the table only stores the check-boxes and the form labels are the field (column) names on the table.

Now, what I'm trying to do is create a search feature whereby if a keyword search is conducted, a search through the column names from the table with checkboxes takes place and only lines (rows) with true (checked) checkboxes are returned.

View 12 Replies View Related

Forms :: How To Distinguish Text Displayed In Unbound List Box

Jul 24, 2015

i have a form contains unbound listbox , that accumulates values of a field in that form "SalName" , when i move between records of this form i want the value that is in the current record is distinguished in the Listbox ( only where the SalID=SalID).distinguish by A special colour ,Font,undeline.

View 12 Replies View Related

Forms :: Unbound Combobox - Sorting List Of Files

May 19, 2014

I have a BackUp and Restrore from BackUp procedure in my my database.

I can backup to a spreadsheet and the spreadsheets are renamed to include the date of the backup.

When I restore from the backup an unbound combo is populated

Code : Set SourceFolder = FSO.GetFolder("c:GPandDetectionDogTrainingLogBackUp")

This all works, the only issue being, is that I want the most recent backup to be at the top of the list, at the the moment its at the bottom.

is there a way of implementing a sort order, bearing in mind that its an unbound combobox.

View 5 Replies View Related

Forms :: Unbound Text Box Equals List Box Column

Mar 11, 2013

why =listboxname.column(0) in the control source of a textbox will give me the value "#name?" ? I've used it successfully on another form..but for some reason its not working for me.

View 6 Replies View Related

Forms :: Unbound Combo Box - Lookup List Of Numbers Through Query

Oct 2, 2013

I have an unbound combo box that looks up a list of numbers through a query but on the drop down list it does not go all the way down to the bottom of the numbers. For instance the combo box will only go down to the number 27453 but I know there are more numbers than that in the table. I can even type in a number and get the info but it still doesn't show up in the list...

View 1 Replies View Related







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