If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> conObjStateClosed Then If FORMS(strFormName).CurrentView <> conDesignView Then IsLoaded = True End If End If
End Function Function ShipName() ShipName = "LAILA THERESA" End Function Function CallSign() CallSign = "OUJQ2" End Function Function SENO() SENO = "herning shipping a.s 55001715" End Function Function NationalityOfShip() NationalityOfShip = "Danish" End Function Function Homeport() Homeport = "Struer" End Function Function SBT() SBT = "408" End Function Function GT() GT = "2682" End Function Function NT() NT = "1305" End Function Function Address() Address = "herning shipping a.s" End Function Function address1() address1 = "Olufsvænget 29" End Function Function address2() address2 = "DK-7400 Herning" End Function Function address3() address3 = "DENMARK" End Function Function radar1() radar1 = "STN ATLAS" End Function Function Echosounder1() Echosounder1 = "STN ATLAS" End Function Function Echosounder2() Echosounder2 = "STN ATLAS" End Function Function radar2() radar2 = "STN ATLAS" End Function Function tank1() tank1 = "1 Port" End Function Function tank2() tank2 = "1 Starboard." End Function Function tank3() tank3 = "2 Port" End Function Function tank4() tank4 = "2 Starboard" End Function Function tank5() tank5 = "3 Port" End Function Function tank6() tank6 = "3 Starboard" End Function Function tank7() tank7 = "4 Port" End Function Function tank8() tank8 = "4 Starboard" End Function Function tank9() tank9 = "5 Port" End Function Function tank10() tank10 = "5 Starboard" End Function Function tank11() tank11 = "6 Port" End Function Function tank12() tank12 = "6 Starboard" End Function Function tank13() tank13 = "Deck Tank Port" End Function Function tank14() tank14 = "Deck Tank Std." End Function Function tank15() tank15 = "" End Function Function tank16() tank16 = "" End Function Function tank17() tank17 = "" End Function Function tank18() tank18 = "" End Function Function tank19() tank19 = "" End Function Function tank20() tank20 = "" End Function Function tank21() tank21 = "" End Function Function tank22() tank22 = "" End Function
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Morning Jan! Not QUITE sure what you are wanting, but if I'm right then I suggest the following. You have GLOBAL variables, these are variables you declare in a module with the keyword PUBLIC this says that all forms have access to them. Then when you start you program you call a function with the LOGIN name as a paramater. Then the function selects all the information and sets the GLOBAL variables. The user information should be in a single table to make it easy.
Once the variables are set then they can be used in ALL forms.
Morning Terry Ovenstående modul er kun gyldigt for et skib, hvis et andet skib logger på applikationen, så ønsker jeg at access henter et andet modul (med andre oplysninger. Kan man ikke bruge en CASE funktion eller IF..ELSE..ENDIF på ovenstående modul ved brug af Password og userid Jan
Lets just say you have a table containing ALL infromation for ALL ships "tblShipInfo"
With these fields ShipName CallSign SENO NationalityOfShip . . . and so on
Then when you LOGON you find the name of the ship and then either using the DLookup function or a recordset you fill in the GLOBAL variables which you can use in all forms
You may think it will take lots of work but once you get going it will go much faster than you think and it is MUCH more flexible if you need further functions or new ships.
When Access applications get more complicated then quite often programming will be necessary so its a good idea to learn VBA code. There is alwasy help to get here if you have problems.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.