Search results

Sorry, I tried to be too sybnthetic. I'm doing an internship for an airport company. They have asked me to create a database with all the information about the airport in the world. I have no training in Access, I'm using Access 2007-2016. I started using Access 3 weeks ago. I'm trying to...

Thank you. Sorry, I've just talked to my manager. He told me, that he would like to input TORA/TODA/ASDA and it automatically calculates CWY/SWY or he inputs TORA/CWY/SWY and it automatically calculates TODA and ASDA. So I understood I can't do it in the tables but I could do it in the forms...

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

I managed to solve the problem by checking that the number of columns in row source was the same as the number in Column Count. Mat

Thank you for your help. I managed to solve my problem with your help. Mat

Thank you a lot :) After I've managed to export correctly the data I want. I'll go trough my work to optimize everything I can. I'll keep in mind want you have taught me. Thank you Mat

I'm creating the username/password to only allow my team to use the database. My team is part of an airport company. The information in it doesn't contain any confidential information but I just want to limit the number of people to have access to the database. In the future, in the form, I'll...

- The database I'm creating doesn't contain any confidential information. For the moment, I wanted to limit the access to myself and then the rest of the team. When the time comes, I'll talk to my manager and the team to know what level of security they want. Thank for the "update" information...

So, I've added the field in the row source of the combobox. I've added =[ICAO].[Column](4) in the control souce of the field I want to add. (I'm sure the column is 4, because I started counting from 0) I've added in the combobox event "AfterUpdate" , Me!Elevation.Text = me!ICAO.Column(4) It...

Hi isladogs, I found this quote is the database you linked to me. ' CurrentDb.Execute "UPDATE tblUsers SET PWD = EncryptKey(strPassword), PWDDATE = Date ()" & "WHERE UserName ='" & GetUserName() & "';" Has i'm not using an encrypted key to tried to adpate this example to my database by adding...

Thank you for the welcome! Tres heureux de faire votre connaisance aussi :)

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