Search results

  1. C

    VBA Need Advise/Direction

    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...
  2. C

    VBA Need Advise/Direction

    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.
  3. C

    Hi I'm Chuck

    Thank you
  4. C

    Hi I'm Chuck

    Thank you!
  5. C

    Hi I'm Chuck

    Thank you!
  6. C

    VBA Need Advise/Direction

    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...
  7. C

    Solved Looking for Better Way Using VBA

    Thanks Pat I'll check into that.
  8. C

    Solved Looking for Better Way Using VBA

    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.
  9. C

    Solved Looking for Better Way Using VBA

    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
  10. C

    Solved Looking for Better Way Using VBA

    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?
  11. C

    Solved Looking for Better Way Using VBA

  12. C

    Solved Looking for Better Way Using VBA

    The JobsType table is wat I had created as a lookup table
  13. C

    Solved Looking for Better Way Using VBA

    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?
  14. C

    Solved Looking for Better Way Using VBA

    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...
  15. C

    Hi I'm Chuck

    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)
Top Bottom