Replies

Thank u dear
i do a new tables with ur name that u put , but where i put the code
Ashraf

Thanks u Hans
i want it in a new table . and only thesse feald id , from begaun the first no and from end with the last no . 10th
Ashraf

First : sorry for all couse iam egyption so my english is bad i know that .
Second : i try to explan more
if i put at startup the form name for exmble ( mainmenu ) the mdb or mde wil be stated with mainmenu or if i do it with macro autoexec . but if i disabled the bypass shift key i can prevent the user from how he know the name mainmenu but i have user can return bypass shift again so he can know to see the macro or also in startup he can see the form name mainmenu.
so i want my mdb or mde start without put mainmenu form in startup or macro .
I hope to be clear
Ashraf

Thanks Dear
I want to prevent the ueser which form is started the mdb .
ashraf

Thank u Hans it work good .
Ashraf

Thank u very much it work good but if i can put a massgae told me that ID is found befroe .
Ashraf

Thank 4 all for them help . sorry 4 late replay .
Ashraf

Hi Hans ,
u r right i want it in a from not in query .
Ashraf

Dear Hans can u do index depond on the levels .
when i press 1 that level 1 when i add 01 index to 2nd level …. etc
Ashraf

Hi Hans , U r understand what i want ecaxtly , U r very cliver
Thank u very much
Ashraf

Thank u Hans
i do it really but when i put number 6 i see 001 in front of that no: 101004001001001 i want that number only display in the query , also if i put 3 the query dislay only acc in level 3

Very Sorry . It is Here .
Thanks Advanced
Ashraf

really iam happy from all to try to help me .
Thanks 4 all
Ashraf

Thank U Hans very much , but also i back to the first how i put that searil at table .
Ashraf

Thank all for help . I chanegd all feald to english . when u run Q1 it ask u about the month put 4 examble (feb) and the year 2001 . u will found that sn will empty . so i want after i put the month& year the Q1 ask me the chik start with no : i put 1300 then the Q1 will full the sn feald with 1300-1301-1302 etc ..
if the Q1has 7 records only the chick will be 7 also . after taht i do a report depond on the Q1 to print the chicks as a searial .
Ashraf