Search results

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

Thanks for this and v.sorry for the late reply

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

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

ahah thank you all!!!

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

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

thank you all-this is great

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

Ahh Thankyou !!

Thanks again

Thank alot!!!

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

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

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

:)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...

I will give it ago and I'll get back to you...Thanks

Yes sorry that is correct, the datasheet dosnt seem to be reciving the data from LOCReport.Field(2).Value........?

I have altered the code to show: If LOCReport.Fields(1) = Datasheet.Cells(1, y).Value Then Datasheet.Cells(32, y).Value = LOCReport.Fields(2) End If Its going through the run correctly finishing with 'Run has finished', howver it is not copying the figuers to the excel datasheet...

As i mentioned above i am not using all the variables they are in from a previous code and they are still in as i don't belive they are affecting the code.. i can take them out? also Datasheet is a reference to excel ( a worksheet in excel)!