Search results

Just added a field in my userinterface form. I've attached the database and the xml fields. Mat

Thank you for your help. The last clarification I can give you is what matches the xml field name to the database field name. On the left is the xml field name and on the right the db field name. <Airport> <Name> -> AirportName <State> -> Empty, not a field in the db <City> -> AirportCity...

Thank you. When I ?currentproject.Path in the immediate window I get the following message : I:\FlightOps\Perfeng\wordperf\NEW Airport Database Project\03-New Access Database

Hi, Ok, so I placed my db in another folder to avoid conflict with the name "Data". I'm not sure I understand you. Where do you want me to write : Mat

Hi All, I need help setting a backup button. I've found the thread : https://access-programmers.co.uk/forums/showthread.php?t=199405 Working step by step, I created a from (frm_Backup). I have a problem with the code of the backup button : Private Sub Button_Backup_Click() Dim str As...

Yes. No, I would like to export all the data. So the xml file will have all the data about all the airports displayed one after the other with the same structure as the xml I shared with you. So I guess what would be good is : After the user click on the "export to Airbus " button. The code...

Yes, when the user clicks on the export button, I would like the xml to save itselve directly in a folder I chose (I:\FlightOps\Perfeng\wordperf\NEW Airport Database Project\06-Export) Yes, I would also like the save the xml as the date+time. This will let me keep a archive of the xml. Yes...

Thanks, What would I have to change in your code to have an automatic save, where the name of the file would be the date+time? For the print statement. Would it be a good idea if I used the print #1, to rename my field and display the right data? For example, for the name of an airport...

theDBguy Yes, but I quiclky end up in a dead end because I don't know how to add a tag and I need to have two fields with the same name (and a query won't let me do that). sxschech Thank you for your code. I'm still a beginner with access and coding, so I don't fully understand your code...

Hi All, I've created a access database using access 2016. This db is an airport database. It regroups the data that will be used by two differents software. I'm here now because I need to export my db in a specific way and in a xml file. But I don't know how to do this. The result I need to...

I'm using : Public Function GetStringLatLong(degrees As Long, minutes As Long, seconds As Double, Direction As String) As String ' function that defines the formats GetStringLatLong = degrees & Chr(248) & " " & minutes & "' " & seconds & "'' " & Direction End Function Public Sub...

Perfect, thank you very much ones again. Mat

Perfect, changing it to "double" works. I've also tried setting the input mask of lat_seconds to a 4 digits (2 integer number and 2 decimal number). When I set the input mask to 99,99 or 99.99 I get a error message saying I don't respect my validation rule. Where the latitude seconds must be...

Hi MajP, sorry to come back to this post. A colleagues told me he would like to have the seconds with 2 decimals number. In the property sheet of the latitude_seconds, I changed the decimal places to 2. That works ok. That the problem is : when the latitude uploads itselfs it rounds the seconds...

Well that's pretty weird. That's how I wrote the code in the first place and it didn't work than but it works now. Sorry for that. Thanks

Also, to have the dist value displayed in the form also allow my colleagues to check if the dist they want to use after export is accurate. You're not a pain at all, I'm new at Access and I really appreciate the help you and the other on this forum give me.

Dist has to be stored because in case of an aircraft accident. If an aircraft craches in a obstacles, during the investigation we have to verifie the distance value we have stored and used to calculate the aircraft performance. Storing the value is also a quick way for my colleages to check if...

Sorry I know you told me this before. But I need the "ObsDistRef" and the "Dist" to be stored and shown to the used when the changes are made.

Hi All, I've attached a demo of my problem. The DB form has: - "ObsDistRef" is a combo box and can have the value ("BR brake release" or "LO liftoff end of runway") -"Dist_init" is used for a calculation -"Dist" is the value I want stored. It referes to the distance between "BR brake...

Thank you, I don't know if my colleagues want a conversion option in the interface. I'll need to discuss this with them. Mat