Search results

  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?
  16. S

    Extract Form

    I have an extract form where there are 4 combo boxes. Each combo box when selected will set as filter for the query to be extracted. If the combo box is empty it just means that there is no filter, how can I do this to be able to extract the data depending on the combo boxes. I am figuring it...
  17. S

    2nd row in continuous form doesn't update

    Hi Moke123, still nothing change,
  18. S

    2nd row in continuous form doesn't update

    I am getting an error with the code below: Error: "You cant go to the specified record." What can be an error? Set dbforms = CurrentDb strSQL = "SELECT * FROM MainData WHERE [Enterprise ID] = '" & Me.txtAttUser.Value & "'" Set rstforms = dbforms.OpenRecordset(strSQL...
  19. S

    2nd row in continuous form doesn't update

    I have been reading about recordsetclone and bookmark, is this something which can help me, i dont know how to use that thing,
  20. S

    2nd row in continuous form doesn't update

    No, because it uses the where clause to find the txtAttUser on updating which record.
Top Bottom