Search Result

Hi! I had a code that can search, just enter any keyword like. If I want to search "Access" I can put Acc only and then it will show me all record that has "Acc" on the database like Access, Accelerate, etc.

My question is. It is possible if I also do that in multiple search? Using comma as a separator?

For example : I will put [Acc, Ex] on my textbox. Is it possible for it to show me the record like....

I'm using Access 2002.

I have a query field set up that references a form, Policy_File_Inv entory, that has an unbound field, BarcodeNumber.

The form has several options related to the BarcodeNumber field. I am interested in what happens when the fourth option is selected. (The first and second selections work fine as is. The third option just displays all records.)

...

I need to know how to make a internal site search for my website

Hello from Asia Minor,
I am far away from home and my reference material is not with me.
Dilemma: I have been asked to create a program from scratch that will have a search engine built into it, searching for personal data at a sentry post, to make it easier than searching through tons of papers printed out which change daily, weekly and monthly. Drawing on what little programming language I know, I have composed something. However,...

I will appreciate some assistance with a project of mine. I am relatively new to access.
I have a form with unbound text boxes. I want to be able to search for member IDs with one of the unbound text boxes as the source of the search criteria and then the result should be displayed on the same form.
After this is done, i will like the record source to be changed to another table so i can add some data to the ones displayed by the search...

I am using a search engine www.sciencedirect.com in part of my code. I want to search for keywords and find how many results there are.

My code works fine, all I need is the URL to submit search queries, Initially I tested the code with the basic search function and got it to work, basically its just:

http://www.sciencedirect.com/science?[inputname]=[value]

I can't just use the URL of the results page, as you...

My program is designed to take input from a file containing a list of titles and authors. The file looks like so:

title
associated author
next title
associated author
etc.

The problem I'm having is with my showBooksByTitl e and showBooksByAuth or functions, I guess what I'm asking is how does one compare parts of strings so that if a user searched for Mal (and there was author D.S. Malik and...

Hello.
I am trying to make a search for for my database. I already have a form created for input of the data. I would like to copy that form and use it as a search form and feed the results of the search into a report that I have already created. It should return all values associated with that field if that particular text box is left blank.

Any and all help/advice would be appriciated!!!

wisni1rr

Hi guys,

I have a form that is checking staff names against staff numbers and I'm looking for the best way to return this data.

I have up to 20 text boxes where staff numbers are entered, and 20 text boxes next to those where I would like the staff names filled it.

I originally had some great advise on a Dlookup, which worked fine for one search at a time but looking for multiple staff numbers against...

Hello Everyone.
I have a question and i would appreciate if any one can help....
Attached is a user form with 3 Search critira. I would like it to seach the worksheet display result in text box and on update that filtered list add a number(From the userForm)into in a column that says ppo #. any guidance in this will help....

I know there is a way to create a temporary column as part of a basic Select Statement search that shows the result of mathematical calculations done in that search, but I can't remember the syntax and googling it has been a wash out.

I have a list of classes in a database. I need to list all classes with less than 12 students in them, that's fine. But I also need add a column that shows the number of students necessary to bring...

I have a table (TextTbl) containing several text fields, and a table containing a list of keywords (KeywordTbl), ordered by 'priority'. I would like to populate a TextTbl.Keyword field within each record to contain the highest-priority keyword found within its text fields.

I have written the following query:

...

Hi,

I have a form A that contains a subform B listing the names of potentially multiple people all associated with the 1 record displayed on form A. That part works just fine.

Now, I want to be able to create ONE line (NOT just a subreport listing all the names from the subform) in my associated report that basically loops through all the records, pulls out all the names associated with that one record, and lists...

Hi, I'm creating an online photo gallery. I would like to be able to browse photos and descriptions using ajax retrieving from a database to improve the user experience.

What do people do about SEO? Won't my descriptions be invisible to search engines?

Do i create a separate hard coded page for each photo that a search engine can read? or is there another method?

Thanks

Hi, I have data files that seem to have random data, but in fact have some structure in it.

The data could be alphanumeric or numeric, all 16bits and different length (could be way big > 2Gb!)

I’m use to program in compiler itself, C++ seem the next logical steps.

My question:
I need to find in those data files, any pattern of data.

Ex:
Data = “3A45g9doadgn-32639-58387yf32n02j34 8yb09nv0293jf9v 3Anv-425gn093mk2-0kf3”...