Exporting in xml using a module (1 Viewer)

sxschech

Registered User.
Local time
Today, 15:02
Joined
Mar 2, 2010
Messages
799
ok, logic in place for the T/F 1/0 fields.
added combo box to select aircraft.

the user can chose which aircraft he want and the export will be what you are working on.

Is intent they would choose one aircraft or do they need to choose multiple aircraft, in which case need to change combo box to list box to allow multi-select.
 

Mat1994

Registered User.
Local time
Tomorrow, 10:02
Joined
Nov 29, 2018
Messages
94
Great news thanks.

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

sxschech

Registered User.
Local time
Today, 15:02
Joined
Mar 2, 2010
Messages
799
Here is the file. Couple of notes:

  1. Changed file to overlapping windows instead of tab interface. Much easier to work with and see multiple objects at once.
  2. Added qryUserInterface to provide data for the recordset
  3. Combo will display after clicking on Export to Airbus button
  4. Combo will hide after xml file has been generated
  5. ExportXML is the name of the sub which is called in the after update event of the combo
  6. There were a couple of fields that had spaces in them such as [All Engine Proc]. I removed the spaces
Hope it meets your needs.
 

Attachments

  • DataBase_V14_WIP.accdb
    1.1 MB · Views: 106

Mat1994

Registered User.
Local time
Tomorrow, 10:02
Joined
Nov 29, 2018
Messages
94
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.
 

Users who are viewing this thread

Top Bottom