Search results

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...

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...

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...

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...

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...

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...

Hi All, I've got a problem with my database and I don't know how, why it occured and how to solve the problem. I've attached the database so you can have a look. I'm working on a airport database. I've been using this forum to answer a lot of my questions as i don't have any training in...

Hi All, I'm having trouble creating my database (airport database). After charing my database with this forum concerning another topic, I was advised to rething the structure of my tables. I'm not 100% sure I comply with the 3 rules of normalizations. The reason I not 100% sure is because...

Hi All, I working on Access 2007-2016. I have a question about calculated fields in tables. I creating an airport database. In a table (tbl_Runway), I have 5 fields I'd like to automatically calculate, TORA, TODA, ASDA, CWY and SWY. The equations are : TODA=TORA+CWY ASDA=TORA+SWY...

Hi All, I'm creating an airport database. And I'm having problems linking my form with my table. I've created a tables with the following fields : ICAO, IATA, Airport Country, Airport City, Elevation, Airport Usage : Inactive, Airport Usage : Destination Airport. ICAO, IATA, ICAO, IATA...

Hi All, I've created a simple login form that pops up when the Access database opens. I've followed the instruction of a tutorial on youtube. The login is a simple form with a User Name and a Password. The code compares the name and password with the data in a specific table. The Vb code I...

Hello everyone, I'm an French engineer student doing an internship in the Air New Zealand company for 6 month. My project is to create a new database for the rest of the team I'm working with. I've started one month ago, and i'm self taught using Access 2007-2016. No one in the team can help...