Recent content by coley

  1. C

    create table query

    not sarcasm, i was just agreeing with you, always been the same but they wont change. Thats life!!
  2. C

    create table query

    oh yes, the business have no clue, it is all output, output. thanks anyway
  3. C

    Create New Table

    i agree its a bad idea, but that is not the point, it still needs to be done as its what the 'Business' wants. Seperate tables, that can then be exported. So is there a quick way of doing this, as i have over 100 tables to create?
  4. C

    create table query

    because its what the 'Business' wants, believe me, i have asked the same question time and time again. so is there a quick way, as i have over 100 tables to create.
  5. C

    Create New Table

    Hi Is there a quick way to split up a table into many other tables? I want to split the table by Client Number, so all the Clients with 1234, for example, are in a table called Client1234 I know the very long winded way, creating a ‘Create New Table’ query, inputting the Client Code criteria...
  6. C

    create table query

    Hi Is there a quick way to split up a table into many other tables? I want to split the table by Client Number, so all the Clients with 1234, for example, are in a table called Client1234 I know the very long winded way, creating a ‘Create New Table’ query, inputting the Client Code criteria...
  7. C

    Running code after a Yes/No response

    Thanks for this Was still having problems but not to worry as I have now changed the way my database works so this function is not needed. Thank you for your help anyway. Keith ;)
  8. C

    Running code after a Yes/No response

    This is my code, what i am doing wrong? Public Sub Add_new_request_Click() DoCmd.OpenForm ("Project Log Sheet") DoCmd.Maximize DoCmd.Close acForm, ("Main Page") If MsgBox("Do you want to add a New Project?", vbQuestion + vbYesNo, "Add a new Project?") = vbYes Then Call AddNewProject_Click...
  9. C

    Running code after a Yes/No response

    Modest, something like this? Public Sub Add_new_request_Click() DoCmd.OpenForm ("Project Log Sheet") DoCmd.Maximize DoCmd.Close acForm, ("Main Page") If MsgBox("Do you want to add a New Project?", vbQuestion + vbYesNo, "Add a new Project?") = vbYes Then DoCmd.OpenForm ("Project Log...
  10. C

    Running code after a Yes/No response

    ok i see, I do have code in my database but no modules, so they are linked to the forms. I dont have a clue regarding Modules, but is it possible to put all my code into one module so they are all in the one place, will this help? cheers
  11. C

    Running code after a Yes/No response

    does not work i get this error Compile error: Sub or Function not defined I have no code in any modules, on the Project Explorer all my Forms are listed with codes asscoited to them. Is it best to use modules then?
  12. C

    Running code after a Yes/No response

    Please Help Hi This is my code: Private Sub Add_new_request_Click() If MsgBox("Do you want to add a New Project?", vbQuestion + vbYesNo, "Add a new Project?") = vbYes Then DoCmd.OpenForm ("Project Log Sheet") DoCmd.Maximize DoCmd.Close acForm, ("Main Page") Here I need code to run another...
  13. C

    Running code after a Yes/No response

    Fair point, sorry to you all, i will try and explain more carefully in future coley
  14. C

    Running code after a Yes/No response

    thanks to all the people who answered this, apart from Ken because 'Do Stuff' isnt really that helpful, is it? cheers!!!
  15. C

    Running code after a Yes/No response

    great!! any normal answers from any normal people
See more
Back
Top Bottom