Search results

  1. J

    return a part of the long text field

    I'm unfamiliar with Regular Expressions.
  2. J

    return a part of the long text field

    I have a query that is used for a report. I want to have a field that pulls information from a long text field. The information that I need will always start with the word "Need", "Missing", or "Ready" and will be on its own line, normally the first line of the long text field. If this info...
  3. J

    Dynamic search of Many-to-Many Relationship with List that aggregates data

    I actually don't want the data on this form to be updatable.
  4. J

    Dynamic search of Many-to-Many Relationship with List that aggregates data

    I apologize if I'm not explaining this clearly. What I am looking to accomplish is a form (currently my DealList_frmMain form) that lists all the deals in the database and can be filtered from a universal dynamic filter field, which I currently have. I also want the form via the query to...
  5. J

    Dynamic search of Many-to-Many Relationship with List that aggregates data

    The result of the query is correct but the search/filter field I created on the DealList_frmMain form doesn't work once I connect the query as the source and correct the formatting errors (since the columns in your queries are different then mine. Maybe what I want cant be done, I don't know. I...
  6. J

    Dynamic search of Many-to-Many Relationship with List that aggregates data

    I would expect the following results on the Client List page, but the filter bar to include any deals that have been aggregated below. For example if I type Jason into the search/filter field, then I would want to see Loan No 33333333 show up as Jason is associated with that deal. Name...
  7. J

    Dynamic search of Many-to-Many Relationship with List that aggregates data

    Here is a striped down version of my database. One additional issue I have is that there are situations where I have a deal and a property but not a client attached to the deal yet (or a deal and a client, but no property). Right now the deal would not show up unless all 3 are present, but I...
  8. J

    Dynamic search of Many-to-Many Relationship with List that aggregates data

    I'll preface this by saying Im a novice at access. I have a query with 5 tables: Deal Table Property Table Client Table Junction Table between Deals and Property Junction Table between Deals and Clients I want to present a list of all deals on a form. Some deals will include multiple...
  9. J

    Allowing user to set default value

    No, the default value is the same for all users, but just needs to be changed from time to time.
  10. J

    Allowing user to set default value

    Newbie here. I want to create a settings form that allows the user to set the default value of a field on a different form for new records. How would I go about doing that? Appreciate the help.
  11. J

    Copy query results into email w/ bullet points

    Thanks very much for the help. Code works perfectly and is so much simpler. Instead of joining a sequence table I created a sort column in the existing query, mostly because I had already done it, but in the future it sounds like the sequence table may be the better the option and I'll certainly...
  12. J

    Copy query results into email w/ bullet points

    I'm not sure I understood the directions above but I did my best. This is what I have. Its an quite the mess. I'm sure there is a much simpler and better way to do what I have tried to do. It seemed to work in my test database, but when I put it in action it no longer worked and would only...
  13. J

    Copy query results into email w/ bullet points

    The bones for my code are below. Of course I'm missing just about everything needed for it to work. Some of the info I am using in the email (address & name) are in the main form (which is also in a navigation form), where as the info that I need to put in the category sections and bullet points...
  14. J

    Copy query results into email w/ bullet points

    I’m not sure I fully understand your question. I’m sending it using outlook via VBA from access. I basically just want to push a button in access and an email is generated without having to make any additions or changes. Please excuse my ignorance. I’m still really new at this.
  15. J

    Copy query results into email w/ bullet points

    Needs to be in the body of the email, not an attachment.
  16. J

    Copy query results into email w/ bullet points

    Novice here. Via VBA I am trying to copy the results of a query into an email, with each result it’s one bullet point, broken down into catagories. I basically have 2 relevant fields in the query. A category field and a notes field. The email should look like this: Category 1: Note 1 Note 2...
  17. J

    Passing a variable to a query

    How would I do that? I don’t actually want to filter the results but actually use the variable in an append query. This is all still pretty new to me.
  18. J

    Passing a variable to a query

    I’m trying to pass a variable in VBA to a query in order to create a temporary table. How do I reference the variable in the query?
  19. J

    Formatting certain records on opening report

    That did the trick.
  20. J

    Formatting certain records on opening report

    Access novice here. I’m trying to make a simple format change to the font color of a field for certain records upon opening a report. All I’ve been able to do so far is make the change across all records. I have a report that shows the priority, stage, and task fields for each record. If a...
Top Bottom