Search results

The best and easiest reply I can give you is for you to look for specials on Udemy.. If you register on Udemy the will notify you when they have specials available for SQL classes. The great thing is that you can get classes to learn SQL from A-Z. Additionally if you need training to be able to...

Okay thank you for the info and yes I actually did create a table (company_positons) which has to columns (positions & result) SQL solution would be the ideal since eventually the plan is to move all this in to SQL & create a web app. You see I use to do all this but suffered a TBI accident...

So Pat, please forgive my ignorance, but can you explain how this would look for every word in that column (col 1) until the word is found & then return the result from column 2. the word has to have the wildcard in front and end cause it is buried in content… Thanks really appreciate it.

Thank you

Thank you!

Thank you!

Hi Everyone, First thank you to all for the guidance I was given on my “ Looking for Better Way Using VBA” post. Now that I understand how the VBA is works, I am now looking to use a another table that will be a list of positions that I will I will be searching for just like Pung showed me how...

Thanks Pat I'll check into that.

Plog, Thank you for all the help and for taking a newby by the hand. I really appreciate it. My next step is going to be to have it reference the table called JobTypes using maybe a DLookup. Again, thanks for the help Very much appreciate it.

Thanks Galaxiom, I understand what you are saying I do have a table that contains all the jobs - so I do believe that is what you are talking about

Hi, First off thank you very much for helping such a novice. Here is what I've done Created a Module: Next I have entered the SQL code as instructed: When I try to Run it I get: Funny thing is that I can open any query that does not have SQL associated to it. - any ideas?

The JobsType table is wat I had created as a lookup table

Hey Thanks Plog, I think that this is what I was looking for. Now being new to access and VBA, I have to ask - so this code will work for every record (Row) in the table - right?

Morning, Looking for a little advise and help. I have created a Access Db that contains 3 tables and one query. The 3 tables are: Job Types Sent items Remote Jobs The fields I am concerned with are Sent.Subject I am searching in the content of the field to see if it has a keywork or list...

Hey Good Morning, Have joined Access World to see if I interact with those that either may be as curious as I or just enjoy Access. Experience: 0 (Total Novice)