Search results

  1. B

    Question Forms - Update records from a new window

    Hi, I am trying to UPDATE records from the Master form by clicking a button to a new window - frmCustomerMaster (main form) - a button will trigger to UpdateCustomerMaster new window and pass all the data to the new window. UpdateCustomerMaster (New window Form) On Submit Update values...
  2. B

    Opening report using WHERE CLAUSE from a click of button

    Hi I am trying to pass value from a button to my report using Table Culum called FormID = 1 or 2 or 3. In the Report I used Recorsource SQL as below - SELECT tblHelp.FormID, tblHelp.HelpID, tblHelp.HelpCategory, tblHelp.HelpFormPageName, tblHelp.HelpQuestion, tblHelp.HelpAnswer...
  3. B

    Question Exporting a single record to PDF & Excel File

    Hi, I am trying to Export a single record from my customer table and using below codes - Private Sub lblPDF_Click() Me.Refresh Dim myPath As String Dim stDocName As String Dim theFileName As String stDocName = "rptCustomerMaster" (is my Report File name) >>>DoCmd.OpenReport stDocName...
  4. B

    Question Need help on Creating "HELP" table relate to every single form

    Hi, I am trying to learn how to dynamically pull the answers based on which form you are. Example, I have 5 sample form (Customer, Supplier, Products, Purchase Order, Sales Order etc)... When I am in Customer Form, I have a lblHelp button which will trigger to a new page and will pull the...
  5. B

    Question Run Time Error 94: Invalid use of Null

    Hi, I am new to MS Access, just started learning watching youtube videos. I have created a form for customer and where company logo I am using logo images using path in table and using vb in form, uptill its working fine. Private Sub Form_Current() logoImage.Picture = CompanyLogo End Sub...
Top Bottom