Search results

  1. J

    How to give the parameter value Yes or No?

    Thank you so much. It worked
  2. J

    How to give the parameter value Yes or No?

    Thank you so much It worked perfectly
  3. J

    How to give the parameter value Yes or No?

    Yes it is Unbound and the RowSource is Yes;No
  4. J

    How to give the parameter value Yes or No?

    Hello, I was trying to create a query based on the parameters a user enter. I have created a user form and when user select "Yes" I want to display all the records which are completed. The field Completed is a Check Box. In the Query design view when I enter Yes (without double quotes) query...
  5. J

    Solved Create Access Table Data Backup in Excel

    Thanks a lot it Worked
  6. J

    Solved Create Access Table Data Backup in Excel

    Hello, I have created a spreadsheet and now all my data from 5 main tables are saving in it. My Backup of database are saving like this on a button click: Is there any way I could apply this same method for Excel? What I mean to say is, when a user click on a command button, I want to...
  7. J

    Solved Create Access Table Data Backup in Excel

    Sorry. This is what happened when I blindly copy paste the code without knowing what does it means Changed my code DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tblMaster Table", "\\ABC\shared\ABCD\ABCDE\ABCDEF\Database Backup\Test.xlsx", True and it worked Thank you so much
  8. J

    Solved Create Access Table Data Backup in Excel

    Thank you so much. But I am getting This is my code DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "[tblMaster Table]", "\\ABC\shared\ABCD\ABCDE\ABCDEF\Database Backup\Test.xlsx", True Thanks
  9. J

    Solved Create Access Table Data Backup in Excel

    No I will try. Let me google or if you have any links that would be highly appreciate We have 5 main tables and what I want is while taking the Backup daily (I am taking daily Backup in a button click event) I want the data of these 5 tables to paste in to an Excel sheet with 5 different Tabs...
  10. J

    Solved Create Access Table Data Backup in Excel

    Yes. Because just in case if Access is not working and we are not able to access any of the data in the tables, we must have a Backup in Excel. Currently I am taking daily Backup of my Access database. But if Access is not working we would not able to get any of the data in the Access database...
  11. J

    Solved Create Access Table Data Backup in Excel

    Hello, Can we create backup of Access Tables data in to an Excel file by using VBA code? Thanks
  12. J

    Solved DCount and Like

    I tried it worked Thank You
  13. J

    Solved DCount and Like

    Hi, This is my code to find the total number of Denials in an Application and I want to use Like =DCount("[strID]","[tblMaster Table]","[datDate Application Received] between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date())+0,3,31) And [strStatus of Application] like "*" & 'Denied'...
  14. J

    Create Automated Backup of Database By Month

    Thank You so much
  15. J

    Create Automated Backup of Database By Month

    Hello, Is there any way to create a folder by current month and take Backup of the Database on that folder? In a button click I want to create a folder for example 2022 Feb and then create a Backup of my Database in that folder like from 01-Feb-2022 to 28-Feb-2022. On next month I want to...
  16. J

    Database only 1 user can open from the Network Drive

    Thank you so much for your reply. Do I have to install this in all the user's system? Thanks
  17. J

    Database only 1 user can open from the Network Drive

    Hi, My database is in a Network folder and it was working fine and multi users can open the database. But since 2022 when another user try to open the database we are getting the message like: and now only one user can able to open the database at a time. Could you please let me know how to...
  18. J

    Solved How to Add a Group Heading?

    Thank you so much. I got this What I did is, I have added a text box in the StartDate Header Section then bound that text box with StartDate field and then change the Format of that text box to mmmm Now it's working the way I want. Thank you so much for your effort and time.
Top Bottom