no buddy u can sort the record while ur table is open and while u are making an update statement
but try while doing with module and check there is method called refresh so whenever u make any update or delete statement there is refresh function..
Check this out
kaushal
write a module and create a temporary table
select the filed which u want to seperate, while in the data in ur delimeter should be comma(,) so while calling in module u seperate ur each filed with the delimeter (,) and insert ur record in other table..
Hope ur doubt would solve
kaushal
Basiclly when u give the Auto Number to any field and that as the primary key u cannot have duplicate value...
U have click the Auto Filter jut remove the auto filter
or
pass a query with the select statement and check how many records are there...
If u find the duplicate records just delete...
I have one table which is tblredmption which has field like (date,balance,amt,sec_code) and other table tblcashflow where in my cash flow table there is date where i am checking with the tblredemption table and getting the compound interest. If in the redemption table date match with the cash...
There would be 2 reason when u are taking value from the table check whether the value is in which Data Type and 2) Check whether the combo box properties-->Format-->Format whether it has currency ot not
-kaushal
Hi khwaja,
i have read the query which u send u question is when i add a new record in the Store_master table the recorde should be added to the other three table am i going right...
Solution:----
when u give relationship in the Datatype you have lookup wizard use the property it will ask which...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.