Search results

As JFGambit says, it depends on how accurate you need to be. If you want the distance as the crow flies. This is not too difficult. You would need to integrate your database with a third party PostCode Address File (PAF) product. I haven't done this for many years , but last time I used AFD...

Thanks Mile-O-Phile I will give that a try. I will also continue to try to find a solution to what I am trying to acheive. If i do I will post it. My latest thoughts are, would it be possible to create a global recordset veriable to store the dates in. At least that way each record would not...

Mile-O-Phile We are based in the UK so I would be interested in seeing your solution for calculating bank holidays. I wasn't sure if it was possible, because I didn't think they followed any particular pattern. I would still prefer to have holidays in a table, becuase themn it would allow for...

dcx693 Is that a standard function? I can't seam to find it. I have Excel 2000 and I have looked in the entire list of standard functions, but its not there. I have also looked in vidual basic help and can't find anything on it! :confused:

dcx693 The for each structure works fine, i used a test routine with it to validate the array contents. I like you don't have much experience of arrays, an attempt to use Lbound and UBound failed. The main reason i am using an array, is I am using the function in a query to count the working...

I have created a number of simple crosstab queries. Each has one set of column headings and one set of row heading. For example quantity of different case types handled by worker in one month. When I try to create a report on any of these queries, I am unable to. If I use the report wizard...

The function GetHolidays works fine! The problems Occur in the Function CountWorkingDays in the For each loop when the following line is excuted: If (CDate(varDates) = dtmCurrent) Then blmIsHoliday = True I tried to debug it with msgBox VarType(VarDates) and msgBox(dtmCurrent) but even this...

That doesn't seam to work. I must be doing something wrong. what I am trying to do is load a table of holiday dates into an global array. Then use this array as a check list to work out the number of working days between two dates. My code is as follows: ***************Function to create...

I have an array which holds dates as variants and I want to compare each with "real" dates held in a date field. My routine keeps throwing up a data missmatch error. Is there anything I can do to make them both look the same for a successful comparison.

Does anyone have an answer to this. In access 2000 there appears to be no way to filter a crosstab query by using the value in the field of a seperate form. keep getting the error: "The microsoft Jet engine does not recognize '[Forms]![frmSwitchboard]![txtStartDate]' as a valid field name or...

The query suggested by dcx693 works great. Is there anyway to modify it so that it creates the average time to first appointment for each calendar month?

dcx693 Thanks for your help. I tried it out and it does just what I am looking for. I just had to reverse the Avg([InitialContactDate]-[FirstAppt]) else it gave a negative number. :) sametch

I am designing a relational database for keeping appointment details. I have a parent table with person details and a child page with appointment details. A simplistic design of the two tables is shown below: tblPersonDetails PersonID: FirstName: LastName: InitialContactDate...

It came back to me for those who want to know its me.NewRecord Sametch:)

I am coming back to designing Access databases after a 3 year break. So I am very rusty. I need to be able to detect if the current record is a new record. I seam to recall this was very easy with a one line statement in the onCurrent event. But I just can't remember it and I am struggling to...

Thanks Newman That works fine. I also found out you can reference them by their index number as in: MyTab.Pages(1).visible where 1 is the index number. Sametch

I have a number of tabbed pages on a form. Not all are needed at all times. I would like to be able to disable or make invisible non relavent tab pages depending upon the selection of a combo box outside the tab suing VBA. I am using Access 2000. Is this possible? If so could someone please...

Thanks for all your help I ended up combining bits from different suggestions and coming up with: Function ReplaceSpaces(strEntry As Variant) As String On Error GoTo Err_ReplaceSpaces Dim strTemp As String Dim i As Integer Dim booSpacesFound As Boolean booSpacesFound = False If...

What a great forum, thanks for so many responses. I will try them later tonight with interest. sametch

I have a field for entering URL's and I would like to detect if a user accidentally types in a "space" character and either prompt them with a message box or replace the space with _ Does anyone know how I can detect the prescence of a space character in a string using VBA