Search results

Great! It's working now. Your GetStringLatLong was the missing piece of the puzzle. I now have to repeat this method a few time, for example the longitude. No, I've notice our validation controls are not the same but both our methos work. Thank you very much, I appreciate it a lot, Mat

thanks a lot for the demo. It's what I'm trying to do. I don't understand : GetStringLatLong What does the LatLong refere to? Because I copied/pasted your code, but I get an error : "Compile error : Sub or Function not defined". I replaced your GetStringLatLong with GetStringLatitude, which is...

I don't need any calculation done, so I don't think I need your first code. Or I didn't understand them. If I show the string in an unbound field, I won't be able to store the value in a table? My thought were : I have 4 unbound fields (deg, min, sec, cardinal). I could create a button with a...

I would prefere showing the full latitude value in the form and not using a query. I can create a button that calculates the latitude after the deg, min, sec and cardinal are inputted. However, I'm not sure to understand how to add the deg, min, sec and cardinal values and seperating them...

Thanks for your help. I don't fully understand you. -Where do you write a public function? I've only worked with events, so I'm only know private sub. -Why would you not save the string and use the function? Mat

Thank, your post is interresting but I don't need to convert latitude/longitude in distances. I created 4 unbound controls in my form. - LAT_degrees for the latitude degrees. Input mask is 99 - LAT_Minutes for the latitude minutes. Input mask is 99 - LAT_Secondes for the latitude secondes...

Ok, your method does seem better. I'll try it out. Thanks, Mat

Hi, MajP I'll see if I can limit myself with a validation rule so I just have one field to deal with. Otherwise, your method is probably the easiest. Mat

Thanks, Is it possible to combine both, the input mask and a validation rule? I've never used a validation rule, so I'll have to check it out. Mat

Hi All, In my form, I have a two fields for the latitude and longitude. The data is a combination of numbers and one lettre (N, S, E or W). The input mask is : 999\°99\'99"''"L I've used an input mask "L" for the letter. However I would like to know if it was possible to limit the letter to...

ok, unfortunatly my colleagues weren't satisfied if what I did. The value need to be stored. I have a new idea but I need to try it out. Mat

Hi All, I've manage to solve myu problem. MajP was right. I add a new field called Dist_init and a field called Dist_FNL. For the Dist_init, I created an event (after_Update) that populates the field Dist_FNL. I wrote the simple equation : Me.Dist_FNL = Me.Dist_init Then, for the ObDistRef...

I've just thought about it. But if I do a initial and final distance, the problem stays the same. I would like the the Dist to correct itself when the ObDistRef changes. So this idea won't change the fact that the equations would repeat themselves if the same value of ObDistRef is selected. Mat

Yes, this value needs to be stored. Your idea is not bad. That's what I did to calcule other fields I have. I'll try it again even if I would of prefered having just one Dist (no InitialDistance and FinalDistance)

Hello and Happy new year! The code is : Private Sub ObDistRef_Click() ' will calculate the value of Dist depending on the chose of BR or LO If Me.ObDistRef = "BR brake release" Then Me.Dist = Me.Dist + Me.Parent.TORA_FNL Else: Me.Dist = Me.Dist - Me.Parent.TORA_FNL...

I have a similar problem with another code I have. I have a form (frm_UserInterface), in the form there is a tab with a subform (sfr_Obstacles). - I have one field (ObHtRef) that can have 2 values ("BR brake release" or "LO liftoff end of runway"). -This field has a "on click" event, when if...

Many thanks, It works now!

Hi All, I have a simple question concerning a calculation field a a subform. In my form (frm_UserInterface), I have 2 tab control, "Runway Information" and "Obsctacles + Procedure Information". -In the tab Runway Information, I have a field called TORA_FNL. (TORA_FNL is a number.) -In the tab...

Thanks June, found it. It works now. Thank Cronk for the feedback, I'll trie it out.

You are talking about the "Link child fields" and the "Limk Master fields" in the property sheet of the table tbl_Airport_info?