Search results for query: *

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?

For reasons I cannot fathom my call to Word has ceased to function the following code results in: compile error: user-defined type not defined. Private Sub Command18_Click() Dim objWord As Word.Application I am presumably missing something very obvious so any assistance welcomed

Thanks for the advice but I have not mastered sql yet so will persevere with the PHP option for now. Could you give me some pointers to using fwrite - in particular how to write the file from the server to local directory c:\mydownloads

Bit beyond my capabilities I am afraid. Teaching myself as I go and working from examples in manuals. PHP current project so I will have to leave the ODBC etc for later. The server is not networked - it is a managed server via ISP so all scripts rum over internet.

Stupid question time - is it possible to write to a file from a server to a local PC or write to a file on the server then download to the local PC using FTP functions. What I am looking to do is compare data held in an SQL database online with an Access equivalent on my laptop. The current...

Many thanks - I had just had a lucid moment and got the answer myself but, as ever, thanks for the assistance.