Question Data Search counting

[ash1123]

Dear,
My problem might be easy for some one, but feeling quite helpless.
I have a ""search Form"" where i can find the record just typing a 'key word" in an outbound text box. "on Exit" event execute a requery of subform where showed the ""keywords" related all data.
What I am looking for:
I want to see how many times records where searched, it will store the ""Counting""

Is it clear to you!! pls help

 

[JANR]

You can run an Append query and insert a record in your Counting table in the same event as you do the requery

the question is what do you intend to do with the data in the counting table?

JR

 

[ash1123]

Dear,
Sorry for replying delay, as i was out of the town.
i am attaching my sample. as being a beginner something i tried to solved in my way.. might be it could be done in different way.. but i tried.
What you will find....
list of books, a search form.
what i am looking for is, when i search, the data (now) is showing a query based subform,
but i want store the result. an additional columns will be added next to the numInshelf, is "found", where the searched counting will store. hope could make it clear.
thanks in advance

 

[JANR]

Not 100% sure what you want, but something like this, see attached.

JR

 

[ash1123]

It's a great step for me..... will do bit changes on trigger timing... but thanks JANR, was a window to a dark room

 

[JANR]

No problem

JR

 

[ash1123]

Dear JR,

I need your help again after long 3 month as i thought i could manage your solution. Problem is, it was just fine, but lately i'm facing problem cause my Data is getting larger. so what problem i'm facing is...

I can't find out which "search" number is getting higher than the "SHELF" value.
like when i start counting it showing all data.

but is it possible it will show only those data which i'm counting & an error msg claiming that "this is not in shelf" or "it counted twice"

I tried to put ">0" to "search" but the query stop its working !!!

need help

 

[JANR]

I tried to put ">0" to "search" but the query stop its working !!!

I don't follow, which query? Post the query you are using

JR

 

[ash1123]

"addsearch" query that you helped me with database combo-search database..

let me describe in deatail (hope it will not make you confuse)

1. if i search with "world history" , data will retrieve in the below table in ROW1 showing "Search" field as 1

2. if i search with "Dhaka city" , it will retrieve in the below row of previou, i.e ROW2, search field value will 1

3. some how if i again search with "world history", same row "Search" field value will be 2, and will prompt "quantity" is higher than "SHELF", but data will be accepted if i press "OK"

4. if i search with "World history", it may prompt "Not available", SEARCH field will carry the value 1, if i press "OK"

am i ok with detail?
regards

 

[ash1123]

Dear JR
I'm talking about "addsearch" query and "search" field.

I'm trying to describe in more details, hope will not make u confuse.

1. not all data will be showed up, cause i'm unable to find which one i'm tracking.

2. If i put keyword "World history" it will showed up in the subform and search counter will be 1 in ROW 1

3. if i put keyword "World history" again, then the search counter will be 2 but will prompt me a message "It's more than shelf", but it will keep the record.

4. if I put keyword "dhaka city" it will show up on ROW 2, (Row 1 will be still there)

hope i can explain tht. Need help

 

[JANR]

I see, I think we need to re-design a bit. Instead of storing the number of searches in the table we need to Add records to a junction table to keep history of searches. We can then join this table in a query to our main table to get a complete picture.

Let me think and I get back

JR

 

[ash1123]

Thanks for your hopeful reply and will wait for your return. note that, i think i can do next part but if possible you help me with this
when i put 2nd key word it will come to next row of previous search. it means in the second row.
Thanks in advance.

 

[JANR]

Does this satisfy your request? I went for a code solution and a temp table, look at the codemodule of your search form

JR

 

[ash1123]

Does this satisfy your request? I went for a code solution and a temp table, look at the codemodule of your search form

JR

Almost there .. just need to see the SEARCH counting like before. trying based on your. let me try .. want to learn