Recent content by Jaydeebe

I've just done it. I just needed to set the defaultvalue property to reference the controls on the other tabs and keep the control source as the table fields.

Sorry I can't help you but I am interested in the code. Can you tell me where you found it?

Some of the fields on tab 4 (contained in a sub form) take their values from other controls on the main form by using them as the control source. Some take a value automatically as a master/child link and are indeed bound to the recordset. If instead of this I do this - If i make the...

I have a form with 4 tabs. The first 3 tabs take data from the user. The 4th tab displays this data for the user to confirm that it is correct. At this point I would like to pass those values as a record to a table. How can i do this? any help greatly appriciated!

Ok, that may be true for short distances, but for my own satisfaction I would like to use the more accurate equation so that it can be reapplied to future projects where the level of inaccuaracy will make a difference. My spreadsheet works on "Great circle theory" accounting for the curvature...

Ok fair point. I could do the radians calculation as you have stated. However, I am using radians because I don't think Excel's trig functions work with degrees, only radians.

Hi, You can create a parameter query (a query that asks for criteria to search by) and a report based on that query. I have a form with a command button. Clicking the button runs the report. Because the report is based on a parameter query it will ask the user for input before running. Hope...

Thanks for your replies. I'm sorry, i don't think i explained myself properly. What I would ideally like is for a user to be able to run a find nearest query themselves from a form in the DB. I'm trying to find a way to run this query quickly. At the moment I see it as this - I have 3000...

I have a table that contains a storelist and another that contains postal sectors and their longitude and latitude coordinates. I have made an Excel spreadsheet that calculates the distance between two postal sectors based on their longitude and latitude coordinates. I would like to find the...