Search results

umm DMAX is just totally confusing me even though it looks like the answer to my problems could you teach me how to use this function please?

when i follow the steps i actually get stuck on the following procedure Create and run an append query to append the temporary table to the table whose AutoNumber value you want to change. could you direct me in the best way to approach this as it says query must have at least one...

hi i have a fully made up database using access 2007 i have now decided that i want ther database to start from record number 3000 can this be done or is there a difficulty i have done some research and found http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ209696 this didnt help...

youve done it again ;) thanks

hi all well at the moment i am very happy with my database. the ID i think though is going to be a big issue! at the moment it is set as a auto number so every record would get assigned a unique ID in my form that number has been concatenated with ABA/23 to form e.g: ABA/23455, ABA/23018 where...

you too and thanks for the time and effort, i actually learnt something :D and saved myself a week or so of manual typing :| i guess this case is closed!

actually some how it seems to be working now thankyou anyway

well it only showed the error once and i closed and ignored it thinking it was nothing and now when i try putting the coding into the box it just reverts back so: i input "ABC/" & right("0000" &[ListID],3) and it just keeps reverting straight back to "ABC/" & [ListID]

hey umm it seems to be coming up with some query error is this because i havent made no queries or relationships?

will do mate & rep added ;)

thanks and where does this actually go? does it go in the control source after the "ABC/" & [ListID]? or in validation

ok thanks guys now ive got another little issue! now that ive got that working it says "ABC/23" and the number at ListID the list ID goes on and on into its hundreds! is there a way of formatting or coding or validating this so it places 0's to not make it look odd. e.g: ABC/23001, ABC/23021 -...

i dont have no relationships actually going on its just one big table! do you think thats the reason that it wont concatenate??

umm thanks for that but im not linking no tables together i just want the ID to show ABC/ at the front of the ID number which has already been issued by the autonumber! and thanks for all your time and effort james!

actually to be honest i think im getting there but there is just one screw which is not tight enough which is making it all fall through! thats why i think if someone takes me through a little step by step it would be good and much much appreciated

everything youve said is what i want to do but there is one main i dont know how to do any of the 2 options available! i mean you (James) walked me through one of the options and nothing came up in the results! so im not sure if ive got something wrong. and ive not tried the other one, infact...

how do you actually fix the alpha part of the totalID and how do you actually use this as for everything else your correct im just not any good as access so a description of how to do it/make it work would be nice, thank you ive been trying to get this done for a couple of days now and its...

well what ive done so far is ive created another text box on my form for the new field startID (this does not contain no info in any cell) and then i typed ="ABC/00" & [ListID] in default value in the form when i did this and checked to see if it works, nothing actually came up in the box at...

its saying this error: the database engine does not recognise either the field 'ListID' in a validation expression, or the default value in the table 'client database' do you know anything about this?

well im trying that right now but i dont understand what you mean by default value property let me explain what ive got fully i have a ListID which includes numbers, these numbers are auto numbers and this field is my primary key i now want to add some text to the start of each cell in...