Search results

Hi im after rolling number to appear in the top right hand corner of the main form. This number needs to be then transfered into (Data 2) text box automatically. However at some point i will have to change past records with a new number annually. I still need the (update box) box in the top...

sorry cheated used your database im hopefully going to build on that many thanks will have more questions shortly

taken your advise created a new form based on a query now totally lost any suggestions

See attached, a little lost any ideas again thanks for your help

i think you done it ill let you knnow how i get on many thanks think i might need your knowledge later on thanks very much. can iget you on e mail

ta i think we are close, however, the number 1001, 1002 and so on is a rolling number the initials KA and JS etc are determind at the input stage so. i input kevin alder and in the third box below KA/1001 automatically shows up. then i enter on a second record John smith JS/1002 shows up...

sorry newbie still stuck it returns #name?

How do you concatenate them, sorry newbie

i have 10 names in a combo box, in a third box i would like an auto serial number nut with the initials of the names preceeding the serial number. so say i have names kevin alder, i need the first serial number to be KA/1001 then if i need to select john Smith then the next number would...

this looks like what im after can it be simplified. Autonumber doesn't work this way. In your example, you get QUOT0001, QUOT0002, ORD0003, etc. if it is in the same table. You have to do something different if you want a compound prime key with independent numbering for each sub-set of the...

i have a table with names in it. i need a number system to be automatic for the following. when i put in john smith i need my third text box to generate the number JS/1000 then when i choose fred spears i need FS/1001, and so on. each new record will be a rolling number, however the names...

Help Newbie Learning Hi, tried to do cascading combo boxes think i got it done but now if i change the name in the first box the second box sticks any ideas (see attached) second thing is i have a list of names to choose from when i choose form this list i then have the second combo box to...

see attached query, this works but gets stuck if change the name any ideas going to hang myself

sorry newbie didnt mean to should be upper case, does any one have a solution been on this hours now

here is the script SELECT tblClubs.club, tblClubs.Club, tblClubs.ID FROM tblClubs WHERE (((tblClubs.Club)=forms!ikga England membership.Instructor)); any idea whats wrong

the file is to big help

i select john smith from the first combo box, when i go to select london from the second combo box this works as well, however if i change my mind and put in john doe the second combo box sticks and will not put in the correct entry leeds. im a newbie any help appricated,