Recent content by SBBmaster09

  1. S

    Delete Table Contents in Access and Upload New Data

    I have a button for replace means when clicked, it will delete the current data of the table and upload a new file. it will upload via an excel file.
  2. S

    No Microsoft Office XX.0 Object Library in Access 2016

    Hi, I am currently developing in Access 2016. My Microsoft is Office 365. I need to input FileDialog to be able to upload an excel file to a table. Mostly it says add that Microsoft Office xx.0 Object library. But I can't find it in Access 2016 References. I tried to check in Excel Reference...
  3. S

    Extract Form

    Can you fix my db, im getting confused on my codes.. :(
  4. S

    Extract Form

    So it is not possible to display the data that is not from another table? As i need to display all the options needed.
  5. S

    Extract Form

    Sample of Extracting when I test: When I select Profile, Completed, it will get Completed tags only, (this is working) and when selected Incomplete, will pull all all tag as incomplete (this item is not working) So how can I assure that it should be pulling correct data.
  6. S

    Extract Form

    I am using the same format, what is missing? I cant extract the data I need, I am using MS Access 2013.
  7. S

    Extract Form

    Hi, I'm trying to use your code, it seems that my data is not pulling any data. How can i extract it in an excel.
  8. S

    Extract Form

    It seems I alaready run it putting a code in the Query Table: [Forms]![frm_Extract]![ComboBoxes] Or [Forms]![frm_Extract]![ComboBoxes] is Null
  9. S

    Extract Form

    i am trying to understand what you want me to do, but here is what I have done, I created a query named Master, I have an existing Extract form with 4 combo boxes. under each criteria of the column I need to filter is i input the following code: iif(Trim([Forms]![frm_Extract]![ComboboxName] &...
  10. S

    Extract Form

    i dont get it sir, I already have a query but how will I use the code you gave above
  11. S

    2nd row in continuous form doesn't update

    I dont need to display the count, I need to record each lines. :(
  12. S

    Table width is not updating

    Already solved! :) strEMailMsg = "<Font face = Calibri>" & "Hi," & "<BR>" _ & "<BR>" & "This serves as notification that the following employee will be rolling off the account:" & "<BR><BR>" _ & "<html> <head> <style> table {border-collapse: collapse;} table, th, td...
  13. S

    Table width is not updating

    Hi, i am getting this (See attached file). I want the length to be atleast 2-3 inches in the email. I dont know whats wrong.
  14. S

    Table width is not updating

    I have this code for an email template, I am wondering why the width for the 2nd table is not working, but for the first table it does, is there something wrong in my code: strEMailMsg = "<Font face = Calibri>" & "Hi," & "<BR>" _ & "<BR>" & "This serves as notification that the...
  15. S

    Extract Form

    where should i put that line, should it be in a Queries table?
See more
Top Bottom