Search results

Hey y'all, I have a table with three fields |KEY|KEY_Tbl1|KEY_Tbl2| The fields KEY_Tbl1 and KEY_Tbl2 each have numbers in them (1,2,3 for field KEY_Tbl1 and 10,11,12 for field KEY_Tbl2). I can count how many 1,2,3,10,11,12 there are in each tables but my real problem is: How can I count, using...

hello, I have a table of results which is like that: ID/ KEYWORD1/ ID-tbl1/ ID-tbl2 This table is the result of a data treatment which takes a KEYWORD from tbl1 and searches this same KEYWORD through tbl2. If a same KEYWORD is found in the two tables, this table of results is incremented with...

hello, I have a table of results which is like that: ID/ KEYWORD1/ ID-tbl1/ ID-tbl2 This table is the result of a data treatment which takes a KEYWORD from tbl1 and searches this same KEYWORD through tbl2. If a same KEYWORD is found in the two tables, this table of results is incremented with...

Yep that's right I have been working on the problem for quite a long time and I have had other problems aside due to data formating. It's actually related to your question!! I neede to have each keyword in a separate field. now that its done there are still some compound words like...

Hello, I have two distinct tables, from these tables I want to compare two fields containing text values (keywords) whose data type is memo. they look like this: RecID Value 1 tree 1 mountains 2 orange ... 1003 pluto 1003 saturn 1003 mercury 1003 earth but, being a noobie to access programming...

wow fizzio that was more than enough man!!!! actually I need this as a VBA function that I will use with a query on a specific field. That's why I want to integrate the functionnality of finding the keywords between the values "keywords:" and "Partners already aquired" within a field and...

>>>Fizzio I am using access 2002, but I really want to insert an IF LOOP in my theKeywords function. I want to do that because after parametering all my queries and functions, I want to automate this task. Doing the full parsing task (e.g. search "keywords:"; return the keywords if "keywords:"...

It's a nice try there but it won't work. As I say in the message I have a parsing problem in an earlier step of my project. This problem results in the fact that I can't view the data before importing it into access. Therefore, the sentence "Partners alreday aquired" appears without warning...

hey! Up to now this function helps me to find within a field the words situated after the word "Keywords:". This is, to talk in a visual manner, the left limit of my parsing area. function: Public Function TheKeyWords(longText As String) As String Dim varPos As Variant varPos = InStr(1...

hey!!! glad to see I am not the only one to go through this problem!!! but ron you are a lucky man I just solved it!! I am not sure whether you want to keep all your separated fields on a single entry or if you want each field associated with a single entry. Go to this thread, it discusses and...

hello, I have a query based on a module which parses a memo field and which searches through this field for the word "Keywords:". The module code goes like this: Public Function TheKeyWords(longText As String) As String TheKeyWords = Mid$(longText, InStr(1, longText, "Keywords:") + 9) End...

hey pooka!! you are the man!!!!! The function works perfectly!!! thx again for the great work!! I f you are ever to be in paris email me, I'll buy you dinner!! nico

well I have a problem there the function's error routine shows up when I try to run it... I named my two tables same way as you except for the s at the end and my table fields are named correctly.... I dont get it... I can't attach the mdb cuz its too big, PM me your email so that I can send it...

hey pooka!! thx for all of this, that's more than enough, you are the king. I think I'll get through this problem with everything you explain here. That will make a classic case for people who encounter the same problem!! thx again!

hey pooka, thx for your answer!! but when I debug the code I have small declaration problem though: -Dim dbCurrent As Database: Database is not recognised as a valid type Do I have to create the tblKeywords before running the query based on the parsefield function? Its quite late here so I'll...

well pookatech, this code is only gonna parse one word and put it in the field the function is used in. For example I can't use this function on a single field, and put as an argument multiple rows.... It only works for one row doesn't it?

Hello, I have a database with a field containing mutliple words separated by comas . ID Keywords 1 steack, meat, tomato 2 car, porsche, ford 3 food, egg, cow I want to parse this keywords field and to transform this database into another database with a single entry for each keyword...

I am sorry but I did'nt understand your reply!!! what function should I use to do that? I guess that first, I should use a function which puts all the key words in a single field for both tables and then compare the two fields of the two tables... but I don't know the funcitons being a noob!!!!

I am not sure whether I understand your question or not... i want this query to work in loops because the databes are updated every week with new keywords. Because of this and of the number of key words (10000 in one table a lot less in the other), I cant type in the search myself, and I want...

hey! thanks for your answer!!! you are in the right direction, but the number of keywords and the number of entries is variable!!! When I meant four loops, I meant: for i=1 to i=m (table1) { for j=1 to j=n (table1) { read keyword[j] for k=1 to k=p (table2) { for...