Search results

  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

    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...
  3. 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...
  4. 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
  5. M

    vba code or selcetion help

    :)Hi i need to put a case in or a statement where the user can run all teh options for exampel below the user selects either "Youth Offenders Service" or "Look After Child" and it then runs either of the selections...i would like it to run all the selections one after anither with the user...
  6. M

    VBA Automation from Access to Excel help

    Hi I am adapting my former colleagues VBA so when the VBA runs it firstly: 1)looks at the date in the access table and if this then matches the preset date in my excel worksheet (cells 1, Y..-refer to code below) it then places the value from the next field in my access table to a range of...
  7. M

    Compile Error: Wend without WHile

    Hi I keep getting the above mentionted error can anybody help..?? Please look at the VBA below...Thanks Public Sub Report_Run23(LOCReport As Recordset, datasheet As Variant, RepType As Integer) 'OUTPATINETS FOLLOW-UP' Dim AppExcel As Object Dim CurrentPG As String Dim CurrentSheet...
  8. M

    help with vb

    Hi, Currently when i run my vba it populates my excel spreadsheet fine. The only problem being if there is no data within a month in my access table it wont recognise it and will just populate the the excel spreadsheet not reading the month. for example if my access atble dosnt have a july...
  9. M

    insert a If statement in my vba

    Hello all, I am counting contacts through using the field "SCHDL_REFNO" as my count field and i am listing all the 'contacts' per each financial year month using the field "SchduleDate". The problem occurs when there ahve been no contacts for a certain month. If there have been no contacts...
  10. M

    I want my VBA statment to ask for a date range once only...pleasssee

    Hi i am new to VBA and i am hoping somebody will help be write the following vba code...I need to include a statement so if I enter a date once I don't need to enter further dates as at the moment after each query runs i have to keep enetering date ranges. I have managed to adapt the code...
Back
Top Bottom