Search results

  1. S

    Solved VBA sendkeys BACKSPACE

    Please help me if I run the VBA below with form_load on the Listproduct form it works fine but if I run it from frmNav on Load_form Listproduct form it doesn't work Private Sub Form_Load() ' Select the text in the textbox Me.txtSearch.SetFocus Me.txtSearch.SelStart = 0...
  2. S

    Search while typing Multi Field Search Form in Ms Access

    Hello With the VBA below I can only search for data in Search1 [ItemDescription] and Search2 [PPU]. What I want is that I can search for data in Search1 [ItemCode] , [ItemDescription] , [PPU], [City] in search2 also what I want is to be able to search for data [ItemCode] , [ItemDescription] ...
  3. S

    Solved MS Access Navigationform moveable

    Hello Could you please help how to make Navgationform moveable I Try below VBA : is not working Thank Option Compare Database Option Explicit #If Win64 Then Private Declare PtrSafe Function ReleaseCapture Lib "user32" () As Long #Else Private Declare Function ReleaseCapture Lib "user32" () As...
  4. S

    Solved Export from Ms Access form in to Excel

    Hello, Could you please help how to exporting search results in to xlsx file, with below vba i get empty result on excel see attachement Private Sub Command91_Click() DoCmd.OutputTo acOutputForm, "Listproduct", acFormatXLSX, "C:\Data\export.xlsx", True End Sub Private Sub...
  5. S

    Send Object As

    Hello, Could you please If I use ms access 2021 send object As appears if I using ms access 365 does not appear see photo Please help how to resolve this issue Thank you
  6. S

    Xlookup

    Dear all, I'm looking for an example of a multi-creteria lookup formula
  7. S

    VBA How to copy ONLY non blank cells

    I cant seem to find a solution for my worksheet after endless searching. Is there a way copy a range of cells sheets "Copy From"( Empty and name ) and then paste into sheets "Copy To" ONLY the Name without the empty cells ) are being copied to ( See foto) I have tried many alternatives bu no...
  8. S

    VBA save as pdf with path and name on range.

    Hello Could you please help how to fix this problem: 1. I am trying to write a VBA code to save a selected range to save as PDF and use a cell as the path and name for the file with below VBA, the data will be saved on the same path =C:\Data\PDF Export\ Name = Student Result - 1002.pdf ( this...
  9. S

    Solved Vba backcolor

    Hello, Could you please help with VBA If value on Text box, the Box1 backcolor must be Red ( see picture) If value on combobox the Box2 backcolor must be Red ( see picture) Thank you
Top Bottom