Search results

errrrrrrrr...... here is what happen for me : 1. i create a table in database "one" with ID and name i set the name lookup combobox itself it work fine ,lookup by clicking the downarrow and expand work fine 2. i create another database "two" and drag the table from "one" as copy...

i did ~ but still cannot , i can select from combo box but when i type the follow never show up

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 ?

heihei !! i done it using Currentdb.Openrecordset () btw thanks

sorry ~ you misunderstanding normally ppl use to do like this Dim rs As Object Set rs = Forms![ABC].Recordset.Clone can i direct Clone recordset from a table ?

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

Ya Ya ~ thanks ~

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?

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

thanks ~ it works

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

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____| $$$$$$ | $$$$$$...