Search results

  1. N

    Link Tables issues

    Hey all, Im having some link table issues that Im hoping you folks can help me with. I have a client who has users in different locations. I have database A that houses some tables that are linked into database B which are located on drive X:\ The issue is since there are different locations...
  2. N

    After Update Event run two functions

    Hey all, I need to run two functions during an After update event on a form. The two functions will operate individually but how to I write it to run one function after the other?
  3. N

    Query results as an excel workbook with formatting.

    I currently have a function that generates an email outlook with a table from a query in my db. I need to add an excel attachment of the same query results with filtering of the column headings. Can I use the export to excel functionality that is in Access and if so how do I add the filtering...
  4. N

    Nested iif in query

    Im working on an hourly report that shows summarized sales data. In my example Im capturing the sales at site A,B and C every hour. I also need to show the total sales of the entire group. In the report I need to show the total for each site and a separate total for all sites for the previous...
  5. N

    Autosize columns in Outlook table

    First off I apologize if this is in the wrong section. Im running this in a module so I though this was a fitting place to post the question. I have automated emails in a module that creates a table in an Outlook email. One of my columns can have a large amount of text and the column in the...
  6. N

    Adding a number to the first two characters of a string

    I have a function that puts the first 2 characters of a string into a textbox. What Im attempting to do is add a "1" to those first two characters when an after update event occurs. How would incorporate the "1" into the left(string,2) code to make it work? Any help would be greatly appreciated.
  7. N

    Creating multiple html tables in Outlook email

    Good Evening everyone! Im trying to create an html formatted table in Outlook that displays the results of a designated query. Ive been successful in creating the table for one of my queries but when attempting to create an additional table based on another query, Im only getting first to be...
  8. N

    Determine results based on form entries

    Hey there! First post looking for some assistance. Here's my situation. I have a form where users answer a series of questions through combo and check boxes that grade their experience. When they have made all of their selections and submit, I need to provide a result based on their answers...
  9. N

    Hey There!

    Greetings everyone! New to the forum as a member but I have frequented this site for help on a lot of my projects. I've had a decent amount of experience with programming but my new position requires more of an advanced application! Look forward to learning a lot from everyone!
Back
Top Bottom