Search results

I'll try and attach the picture again... (and the code as I notice that hasn't either) Please note that I have been looking on internet for a solution to this problem aswell and it seems that oracle has an sql function REGR_SLOPE that would do the trick - is there no such thing in access...

I might be being a bit thick here but have you tried DoCmd.OutputTo acReport, "record", "Text Files", "C:\temp\record.txt" (As in using backslash instead of forward slash)

I assume your at the table design stage. You could just use put the following in input mask.. "01"/99/99;0; and then >=now() in validation rule... This will mean that you will only need to input 09/06 for example to store September 2006... This obviously assuems the 1st day of the month is...

Thanks ChrisO but this seems to achieve exactly the same as what I did pretty much - I still can't use xlSlope within a query if you know what I mean. I basically want to be able use the xlSlope function within query designer as shown in the attached picture.. This is necessary because we...

Hi.. This has had me and the team stumped for a while. Basically I need to use the excel 'slope' function (and intercept etc.) on a group of values returned in a query. I have managed to create a function to sort of do this but I want to know if I can create a function in VBA and then use it...

thats right oldsoftboss, I have used error trapping within vba - and that's fair enough because it's up to you to control it... What I am talking about though are the standard Access errors - They are very unhelpful - and should really - in this day and age be a lot better. They give you no...

I'm sick of the lame excuse for error messages that Access gives out.. I'm talking about 'Overflow', 'invalid use of Null' and such like. What about telling you what field/expression caused the error and on what record if applicable. It's so frustrating - Access obviously knows what caused the...

Thanks SJ, that works great - although I think some users are running Access 2000 - so may have some problems with that - but thanks a lot. Just out of interest though - was I barking up the wrong tree with classes? What are they used for?

I want to create a number of functions that can be called from a number of different databases. At the moment we store the same functions in a module in each of the databases but when we want to change something we have to update them all which is not only time consuming but it is easy to miss...

thanks workmad3, but i couldn't get it to work I amended it a bit but here is the code I used.. Function tot2(a As Variant) As Long Dim rs As adodb.Recordset Dim sql As String '<Set up your sql statement here and store it into the string sql> sql = "EnTot: Sum(IIf(" & a & " In...

Hello, I have a query that has a number of fields one of which is checking to see if one value is in a list. To do this I created the following function in vba.. Function tot(a As Variant) As Long If a = "1" Or a = "2" Or a = "2A" Or a = "2B" Or a = "2C" Or a = "3" Or a = "4" Or a = "4+" Or...