Recent content by adidashawn6

  1. A

    Splitting Text

    I have a question about the data from a linked table from a SharePoint page. One of the fields in SharePoint is a "Choice" field where employees can place a check mark next to all options that apply. When i view this data in Access, when there are multiple selections made, it is put into this...
  2. A

    Saving data to table from form w/ Multi-Select Listbox

    Thank you SO much Paul!! That fixed the issue. :)
  3. A

    Saving data to table from form w/ Multi-Select Listbox

    Yes, it is bound to the [Journal Data] table
  4. A

    Saving data to table from form w/ Multi-Select Listbox

    I am working with a database that records "Journal Entries" that supervisors create for their direct report employees. I have just created a new Entry form that allows the supervisor to select multiple employees through the use of a multi-select listbox. I have code that will enter the "Journal...
  5. A

    Email Query Results

    I figured it out. Here is the code that I am using incase anyone else ever has the same issue. Private Sub Submit_Click() Dim email As String Dim email2 As String Dim email3 As String Dim emp As String Dim except As String Dim exceptdate As String Dim exceptSDStime As String Dim...
  6. A

    Email Query Results

    OK, so I changed my approach and now I have the email being generated with the below code. The last thing I need to figure out is how to make this and If statement. I know I will have to modify the code for each of the instances that require an email, that shouldn’t be a problem. I am just...
  7. A

    Email Query Results

    ok, i have made a few more mods to the code, but i am still getting "run time error 3061 too few parameters expected 11". It is highlighting the line "Set rst = dbs.OpenRecordset(strSQL)" Here is my modified code. Can anyone help with this error i am receiving? Private Sub Command65_Click()...
  8. A

    Email Query Results

    I am currently working with a database that I inherited. I have a ComboBox for the "Reason" an employee would call out. The ComboBox has a total of 12 different options that could be selected. Of these 12, there are 3 reasons that will require an email to be sent. The information entered into...
Back
Top Bottom