Search results

  1. B

    Navigation form -> call VBA module

    Hello, lets say I have three forms - Form1,Form2 and Form3 linked to a navigation form with Navigation buttons. I have separate VBA codes under each Before update event of these forms, Form1,Form2 and Form3 to call a VBA module to track the changes performed by the users(Like an Audit Trail) in...
  2. B

    Check mulitple fields and return one value

    Hello, lets say I have a table with five tasks for five employees and each employee's data type is with 'Yes or No'. I need to have a desired result to check 1.if all the employees have completed that particular task then the result should be 'YES' 2.if anyone employee has not completed that...
  3. B

    Run-Time error '2450':

    Hello, could anyone pls help me on this? I am trying to create a login form and end up with this error below, I am just a beginner and I used this code which was already available in the internet. Run-Time error '2450': Microsoft Access cannot find the referenced 'frmlogin'. the code...
  4. B

    Button to export a form and view it in excel

    Hi, is there an option to add a button on a form so that if i click the button all the values displaying on the form will be exported and viewed/edited in excel.I don't want to export the file to my drive also. i knew the "Tools -> Office Links -> Analyze it with Excel" option. The problem is...
  5. B

    Attach an exported excel and send mail to a person

    Hi, I already created a Macros to run a query and export the query in an excel format to a specified location in my local drive but now i want also the same file to be sent as an attachment to a person's mail id,when the macros is run on autoexec. can anyone help me pls?
Back
Top Bottom