Recent content by daybase

With help from tek-tips users I have successfully created a function called CalculateAll that carries out a number of calculations based on a value in a recordreturning the results in an array from which I extract values to populate fields on a form at the on current event. calcfield(0)...

Easy one I am certain but I cannot solve it - I have a form based on a query and all works well but if the query returns no results I get a blank form - how can I prevent the form opening (or make it close) if there is no data present? I have tried Private Sub Form_Load() If...

Problem solved - many thanks to you all

Thank you for the amazingly quick response as usual. PHV - my approach was the same as yours but I then have the problem of calling the function thruDue(date1,due1,due2.... etc etc but I get the error message "Argument not optional" which I am assuming is because something like...

I have a problem with Access after recent MS updates - images cannot be displayed on forms and i receive an error message saying that the images are too large. The code is VBA and is linked to the onCurrent event but as the code has previously worked perfectly well for 4+ years I am certain it...

Way out of my depth here so all help gratefully received. I have an application that requires multiple calculations on any particular record and my function takes details from the open form, calculates and returns the values in an array - works great. Problem I have now is that I would like to...

Altered code to case statments and unless the nextdemand = DateAdd(IntervalType, Numbr, dat) is inserted in each case statement i still get the error. Strange but true..

Had completely overlooked CASE option - thanks for the reminder.

well puzzled now - i have cut and pasted nextdemand = DateAdd(IntervalType, Numbr, dat) into each of the if/endif's and all works beautifully. I am at a loss to explain either why it suddenly stopped working for me after months and months or why this solution works but... problem solved...

An old and until now reliable function has suddenly started to return an error "invalid procedure name or argument" Public Function nextdemand(per, dat) As Date Dim FirstDate As Date ' Declare variables. Dim IntervalType As String Dim Numbr As Integer Dim msg As String Numbr = 1 If per = "2"...

For the first time I am trying to use Like in VBA to do a flexible search on a database and to a point it works... but only to a point and I am sure that I must be missing something obvious. By way of explanation I am looking to open a form which contains a reference, a property address and a...

Relatively new installation but it has been running happily on this hardweare with this version of access on a daily basis for 6 - 7 weeks. I have solved the problem for now by doing a restore to a date just prior to the last automatic windows update. Looks like good old MS have managed to...

After 2 years my project suddenly wont work with graphic files and wont recognise jpg or if files to embed. Any ideas why and particularly why now?

aha - of course. Many Thanks job done

I feel very foolish in asking this but where would I check?