Search results

can anyone explain the function below to me? I understand the first part its after the "&" i can't get my head round? left( [textstring],3) & int(1000+ rnd()* 8999) also how do i find the max of an autonumber and then increment it by 1 every time in a query?

I don't think that would work. At the moment there are no customers. The append query from above populates the table using a customer number that i enter and the first name which gives customer id. How would i get the query to recognise that the customer id must contain the autonumber? It...

One more question if i may? At the moment i am having to type in the customer number. Is there any way that this could be retrieved so that each time a new customer is entered a unique number could be assigned without me having to remember which one i have already used??? I thought about using...

Hey thanks, that works great!!!

Expr1: [Forms]![Frm Create Booking]!Left([Forename],3) & ([Cust no]) Can anyone tell me why i am getting the following error message when i try to run the above query? "Undefined function '[Forms]![Frm Create Booking]!Left' in expression. What i am trying to do is get a customers first...

Ok so now i have the following Left([Customer_Name],3) & Right([Customer_no],4)& "000" where do i put this. I can place it with the above code? And how can i get this to be executed and update another field in another table that will contain the default value of "free" ???

no i think you may have misread, we don't need a web based front end just a database. I am trying to produce a working database but i am trying to understand how i can get the first three digits of their name followed by four numbers.

thanks again, been slow to respond as ive lost my internet at home. The deadline for this unit of work is may 16th so i need to get it functioing asap. that is why i am willing to overlook the limitations for now. Sorry to sound stupid but i can't seem to get my head round how the above code...

Thanks....but i'm not having much luck with this openrecordset. :confused: And with regards to reaching over 10000 customers i'm not concerned as long as it works up to 10000.

Thanks, would you mind giving me some idea of what function i need and also does it need to be written in a VBA editor?

Just tried linikng the query to a text box but it doesn't work? Can some one help, am i along the right lines or am i firing blanks??

ok i think i might have solved this. If i make a query and make a new field based on an expression Left([CustomerID],3) this works. I should now be able to run a macro to run this query no?? also how can i get four digits automatically at the end of this customer id?

Hi thanks for the advice. I am trying functions to automatically generate id using customers name is this correct: On the control source I type in left([customer_name]),3) but this doesn't produce anything?

Hey thanks for your help, your ideas and advice was first class and very valuable. I have looked for a theatre booking scenario in these forums and as yet i have not found one, but i'm still looking... Also when you say i need a function, do i assign it to an unbound text box?

No I teach ICT 11- to 16 year olds, databases is just an element of it.

OK withou over complicting, how do you assign a unique id that consists of the last three letters of theri name, my guess is a query???

I just took a snippet of the text.

:eek: you sound like your are over omplicating things... and thanks!

No a web interface is not required.

I need to build a database from scratch. Without hiding anything, i am a teacher teaching databases to students. I have been given some pre release materials containg a scenario. I have an ok level of access however i have problems interprating scenarios into databases. Please don't get me...