Search results

  1. O

    Search in recordset

    Hi, I have written this code for a search in inventory using recordset. It does work but it got bug and sometimes return the wrong lines Set RstInv = CurrentDb.OpenRecordset("Inventory") With RstInv .GetRows ([StrBarcode]) .MovePrevious .Edit .Fields("Job_No").Value = StrJob_No...
  2. O

    PLS HELP: Searching for Null in Recordset with do loop

    Hi, I want to find empty field (Null/ "") but did'nt work. When I tried this code with for example "t", and put "t" in the field, the code does work. Here's the code, Set RstInv = dbInv.OpenRecordset("DateRecord") Counter = 4 With RstInv .GetRows ([StrBarcode]) .MovePrevious...
  3. O

    PLS HELP: Change the value of table using DoCmd

    Hi, Private Sub Toggle21_Click() Dim StrBarcode As String Dim StrJob_No As String StrBarcode = Forms!Outgoing.oBarcode '=9 (for example) StrJob_No = Forms!Outgoing.oJob_No '=Test (for example) 'Open Marketing Form DoCmd.OpenTable "Inventory" 'Add new record OK up to here DoCmd.GoToRecord...
  4. O

    PLS HELP: Query tied with form Access 2007

    Hi, I put this code in Query under criteria Like [Form]![SearchForm].[qBarcode] & "*" In the SearchForm I put this code in BtnRunSearch Private Sub BtnRunSearch_Click() DoCmd.OpenQuery "Query2", acViewNormal End Sub However the problem is When I hit BtnRunSearch (Button), Query2 act like...
  5. O

    Take value from combo box do search and change value in table

    Hi, I really am new to access and VBA :confused: I am using access 2007 I have a table "Inventory" consist of Name, Serial_No, Job_No I have ff form on that Table and have combo box lookup to Serial_No of Inventory table and another combo box lookup to Job_No. I have another table consist of...
Back
Top Bottom