Recent content by mattaus

  1. M

    set odbc timeout in my vba code

    Hi I am trying to insert a piece of code so the odbc databases timeout is set to 120secs rather then the standard 60secs. Could somebody tel me the code to insert and where to insert it? Please find my procedure below with the querys also. Thanks matthew Sub Test_Reporta() Dim...
  2. M

    set a criteria for 2 txt fields in my form

    Thanks for this and v.sorry for the late reply
  3. M

    set a criteria for 2 txt fields in my form

    Hi, ive got to txt fields fin my form called "txtStartDate" and "txtEndDate" where the user enters the start date and end date as a criteria o the report..howver i want to limit the date range to a 12month period for example the following date range would work: between 01/04/2008 and...
  4. M

    running multiple modules with clicking one button on the form

    Hi, Just for anybody else dealing with a smilar problem 'ahp' is the name of the module so the above code did not work, howevver the below code worked without the modules referenced: Private Sub AHP_Click() RunAll End Sub private sub RunAll() Test_Reporta1 Test_Reporta2 Test_Reporta3...
  5. M

    running multiple modules with clicking one button on the form

    ahah thank you all!!!
  6. M

    running multiple modules with clicking one button on the form

    I would run the first module using the code below: 'AHP' is the name of my button and 'AHP_ACTIVITY.Test_Reporta1' is in the location and name of the module... Private Sub AHP_Click() AHP_ACTIVITY.Test_Reporta1 End Sub
  7. M

    running multiple modules with clicking one button on the form

    Hi, On my form I have a button called 'runall', what would be the correct syntax to insert in my vba once this button is clicked to run all modules, theer are around 6 modules i would like it to run... I know the synatxt to get it to run 1 module but i am not sure how to tell it to run...
  8. M

    select first free letters of the postcode only

    thank you all-this is great
  9. M

    select first free letters of the postcode only

    ahh thanks mike, yes it is a uk postcode, what would be the syntax to do that?
  10. M

    select first free letters of the postcode only

    Ahh Thankyou !!
  11. M

    select first free letters of the postcode only

    Thanks again
  12. M

    select first free letters of the postcode only

    Thank alot!!!
  13. M

    select first free letters of the postcode only

    Hi in my ms access query i have a field called 'postcode', i only want to select the first 3 digits only and ignore the rest? also what would the syntax be if i wanted to selct the last 3 digits only? I thought it may had been the trim function but im not sure now Thanks mattaus
  14. M

    vba code or selcetion help

    p/s congtratz to burnley for reaching the premier league..im originaly from queensgate!!!
  15. M

    vba code or selcetion help

    no, after it has finished populating the first spreadsheet i would then like it to start populating the next spreadsheet...the reason for this is it will be done overnight with nobody here to keep selecting each option...as it takes each option 30-40mins to run..eventualy there will be around...
See more
Top Bottom