Search:

Type: Posts; User: rhaas128; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    299

    Query Relationship help

    So I've got 4 tables:

    Servers
    Approvers
    Reviewers
    Groups

    I have laid samples out of each table below. What I am trying to achieve is to look at a list of all the servers, and if they have an...
  2. Re: UDF to lookup and return multiple values concatenated into one cell without duplicates

    So far so good, and much appreciated it. On some results I am getting a 0 instead of errors or #n/a. Any thoughts how to fix? I assume a nested IF, but not sure. I know that the entries exist, just...
  3. Re: UDF to lookup and return multiple values concatenated into one cell without duplicates

    I know this thread is considered resolved, but I have an additional question. The sheet I have been running this code in has grown to a couple thousand rows. With this code, I am experiencing a...
  4. Re: UDF to lookup and return multiple values concatenated into one cell without duplicates

    Perfect. Thanks a bunch!
  5. Re: UDF to lookup and return multiple values concatenated into one cell without duplicates

    Hrmm.. it is on the other sheet, but the case does not match. I thought vbtextcompare didn't care about case. Am I missing something? If I match the case, results return just fine. I also made sure I...
  6. Re: UDF to lookup and return multiple values concatenated into one cell without duplicates

    I'm getting a #VALUE ! error. Any thoughts on why without seeing the sheet?

    Some server names in the list contain a .domainname.com. And most owners have spaces in the names. Could that be...
  7. UDF to lookup and return multiple values concatenated into one cell without duplicates

    I am looking at a few thousand rows and need to locate the matches, remove duplicates for each, and concatenate the remaining values into a single cell with a delimiter. Example:


    The server list...
  8. Return dates from a list based on Month and Year cells

    I have a workbook that has a defined list of months and years, along with a 2 different date columns that are not currently named. I need to be able to put a month/year on sheet1 from dropdown lists,...
  9. Re: How can I pull text from comma separated memo or text field?

    Ok, well here is a fresh start. Below is the sql I have, but after creating a new workbook with fewer values, it does not appear the Like "*" piece is working as I only get 3 results.


    SELECT [AP...
  10. Re: How can I pull text from comma separated memo or text field?

    Well I said disregard but my new attempt didn't work.
  11. Re: How can I pull text from comma separated memo or text field?

    In addtion to this, if a user id is not found, it just does not display in the query output. I would like to create a new query that only shows users the do not exist in the other table. I tried...
  12. Re: How can I pull text from comma separated memo or text field?

    Oh duh!.. Thank you so much!
  13. How can I pull text from comma separated memo or text field?

    I am trying to find all records in a table that contain a specific user id from another table. I have roughly 900 entries in the table. So I have a query with both tables.

    Table1
    Identity

    ...
  14. Replies
    14
    Views
    431

    Re: Need help parsing text from a cell please

    This works perfect. Thanks again!
  15. Replies
    14
    Views
    431

    Re: Need help parsing text from a cell please

    Question on this one, let's say the Access Name is actually (with the following quotes and period) "Pharmacy Tech". Right now I have managed to ignore the first " by splitting after it. However,...
  16. Replies
    14
    Views
    431

    Re: Need help parsing text from a cell please

    You are correct sir! I completely overlooked it. Thanks to all 3 of you :)
  17. Re: Convert If InStr Excel VBA to Access Expression?

    This worked perfectly. It wasn't too much different and I understand all of the logic and code you have. Thanks for your help! Really appreciate it. :)
  18. Re: Convert If InStr Excel VBA to Access Expression?

    Not that I know of. We have some as short as 4 characters and others upwards of 30. I don't mind the questions and greatly appreciate the help!
  19. Re: Convert If InStr Excel VBA to Access Expression?

    Not always. It may have other lines as well.
  20. Re: Convert If InStr Excel VBA to Access Expression?

    It is a memo. The actual data looks like this. There are 6 spaces between each new line or what a new line would be in excel.
    <tbody>

    <tbody>
    Request: NeededAccess Access Number : 01 ...
  21. Re: Convert If InStr Excel VBA to Access Expression?

    <tbody>
    Description
    Expected Output


    Request: NeededAccess
    Access Number : 01
    Access Profile Name : ANAME
  22. Convert If InStr Excel VBA to Access Expression?

    I have the below code in Excel VBA. I was wanting to try and put this into Access as an expression perhaps? The goal is to look at each record in the table and parse out the Access Profile Name....
  23. Find multiple entries during VBA search and display them?

    My VBA code below is searching for any value from A2:A within column B on Sheet 2. Right now, it will post the first result. I need to find all instances the value is found and display them. Would...
  24. Replies
    3
    Views
    177

    Re: Convert Formula Array To VBA?

    I got rid of the 400 error, but now the issue I have is that the search value of A2 (currently $A2) doesn't update per each row. So I get the same value on each cell. How can I change that to go with...
  25. Replies
    3
    Views
    177

    Re: Convert Formula Array To VBA?

    I'm getting an error 400. Any thoughts? I've been googling it and trying to fix but no resolve.
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4