Search results

  1. S

    unable to auto show up the item while using lookup

    any idea y my access unable to auto show up the item while using lookup ? when a field using lookup it suppose to show the rest of the word , like i type "S" it should show Singapore , why my access cannot ?
  2. S

    Can i clone a record from a table ?

    i wish to clone a record from a table(tbl_cashsale) ~ Dim rs As Object Set rs = ?? :p
  3. S

    How to filter a list ?

    my Form A have 2 List (L_A , L_B) L_A contain sale record , L_B contain sale details how to make L_B filter when i click a record on L_A ? PS:they are not subform, how to write a filter condition in a List Query?
  4. S

    how to send a data from a form to other form ?

    i wish to do this ~ when i click a button on form A ~ it will open a form B and send a number or text to a field in form B
  5. S

    Filter table by name with the latest price

    how can i filter a table "date , item name , price" by only show an item name per line with latest price ?
  6. S

    Mix up few tables data ?

    i have few tables table :sale, invoice, payment all of them have :date , payby (cash/cheque) , currency what should i do to join them(currency) up and group by month ? or become this : query - cash ___________| Cash |Invoice |Payment 2007 Jan____| $$$$$$ | $$$$$$...
Top Bottom