Recent content by Mat1994

Thanks, Yeah, I don't want to be the cause of plane crash. My work is going to be checked by everyone in the team, then tested on the sofware, then checked again, then "certified" then used on the final sofware and only then will it be accepted.

Thank you for all your explanations. Has advised I rethought of how I was going to use this field. This field will be used after export in a software that can read FL + 3 digits or just digits. However, when I questioned my supervisor about this. He thinks using FL+3 digits will define a...

June, Yes for FL123, 457 and 87143. But no for FL32762. This fields indicates an altitude. In aeronautics, we can do that two differents ways. Or you indicate the altitude with a number (from 1 to 10 000 for my case) or we use a flight level (FL + 1 to 3 digits) Galaxiom, Yes, it would be...

Hi June, I don't want to sort the record. When the user inputs this field in the form I want to be sure the format is FL123 or a number (<10000). Could I use me!field.format or a format([field]) = "the format I want"? Mat

Hi All, In my form, I have a field where I would like the user to comply with one of two format. The fields name is : TargetAltitudeSID The format possible are : - FL and 1 to 3 numbers (e.g FL1 or FL12 or FL458 ...) - The field has to be a number < to 99999 I haven't...

Thank you very much!! I've had a try, it seems to be working pretty well. I'll have to fill in real data and try it on the calculation software. Thank you for what you've done. I should be able to understand what you did and do correction if needed.

Great news thanks. Do you think you can send me what you've done so I can try it? Mat

Hi, Is Print #1, "<GroovedPfcSurfaceTO>" & rs!TakeoffRunwaySurface & "</GroovedPfcSurfaceTO> Is Print #1, "<GroovedPfcStopway>" & rs!TakeoffStopwaySurface & "</GroovedPfcStopway>" Is Print #1, "<RunwayPavement>" & rs!RunwayPavement & "</RunwayPavement>" Is Print #1, "<GroovedPfcSurfaceLD>" &...

Thank you for your time and effort but don't give yourself to much work for me. If you can't handle it, let me know and I could trie to finish what you started. Yes, my mistake. The correct field is CLIMBSPEEDLIMITSTATUS. Concerning your sample. I've noticed that in the xml the obstacles are...

Thank you for the advice. I'll apply that method to solve my coding problems in the future. Mat

ahah nothings impossible with code. It was your code, but I was to blind to see that one line had backspaced into a comments.

Sorry about that. Got a collegues to have a look at the code and indeed this line (source = CurrentProject.Path & "") was put as a comment. Now the code works perfect! Thank you for you help. Mat

No, my db is located here whitch is a network all my collegues have acces to : I:\FlightOps\Perfeng\wordperf\NEW Airport Database Project\03-New Access Database\02-Export_WIP But it copies the db located here in Documents that is in my local network.

Thank your code works perfect. I've noticed another problem. I've noticed that the backup button doesn't create a copy of the db I'm have open. Instead it creates a copy of a db located in another folder (Documents) of my local network. Do you know why?

Ok, so I created a folder Data in the same folde as the db. I placed a db in it. Then the backup button worked. Would it be possible to improve the code so it just create a backup folder in the same folder as the db? I would like to avoid having to create the Data folder and make sure there...