Search results

  1. R

    Help required please

    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?
  2. R

    Help required please

    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...
  3. R

    Help required please

    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...
  4. R

    Help required please

    Hey thanks, that works great!!!
  5. R

    Help required please

    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...
  6. R

    Help required please

    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" ???
  7. R

    Help required please

    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.
  8. R

    Help required please

    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...
  9. R

    Help required please

    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.
  10. R

    Help required please

    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?
  11. R

    Help required please

    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??
  12. R

    Help required please

    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?
  13. R

    Help required please

    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?
  14. R

    Help required please

    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?
  15. R

    Help required please

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

    Help required please

    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???
  17. R

    Help required please

    I just took a snippet of the text.
  18. R

    Help required please

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

    Help required please

    No a web interface is not required.
  20. R

    Help required please

    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...
Back
Top Bottom