Search results for query: *

Ok, thanks a lot! I have just changed it, but I have to wait for the new data to arrive. But hopefully it will work just fine, as I have changed the import positions. Thanks again for your help!

This should be it: For Each itm In objInboxItems 'check the Inbox for mail with your keyword 'if subject is correct and is not marked for deletion let's work with this mail item ' mark the email message as read If (InStr(UCase(itm.Subject), "More Student Inquiries from...

Unfortunately, that did not help. The importing is still putting the values into Program. even though now the structure of the access table is this: Name Gender Gpa Date Call Program What could be the problem? Could it be caused by that the Call in the access table is a checkbox...

Hi, I have an access database and I import data to it automatically from a csv which comes to my email. However, the fields do not import to the ones they are supposed to and thats the problem which I have right now. The structure of the csv is this: Name Gender Gpa Date Call The...

It is just a column in the table. It should be correctly LastName_1 or something like that. They just called it like that(whoever created the database)

That worked pretty well. However, when I want to use the new created column FullName (I used the concatenation for creating new column) it gives me this error: Invalid column name 'KEY'. Invalid column name 'FullName'. This is my query: SELECT Title, [Last Name - 1], [First Name - 1], ([Last...

is there a way how I could join at first all the columns in one row into one long string, then perform the search on it and then return the table again in unchanged form? Example: Title Author ----- ------ sql mm and the search would be perfomed on the string "sqlmm" Thanks a lot!

In the keyword, the search should be lookng thorough all the fields in the database(title, authors name, call number,...). The results should be ordered by the number of words of the search phrase whithin the row in the table. So for example, when the user searches for "dan brown angels and...

Hi everybody, I am having a problem with figuring out how to best implement a keyword search in a database of books(I have to create a web interface for the search). I dont know how to create the search query, to get the most relevant results. For example if I would use WHERE CONTAINS and then...