Jump to content

Visual basic to php


Recommended Posts

  • 2 weeks later...

well heres one, but really if there was some software might be better. I dont know if you all can do it with out other information, but let me know and Ill provide what ever I need to.  DB Structure attached

Option Compare Database
Public XTrk_Name As String
Public XTrk_Oper As String
Public XTrk_Short_Name As String
Public XTrk_Desc As String
Public XTrk_ID As Long
Public XHome_ID As Long
Public XHomeSet As Boolean

Public Sub SetHomeTrack()

    Dim VarX As Variant
        
    VarX = ""
        
        VarX = DLookup("[Trk_Name]", "Track_Master", "[Trk_Home] = True")
            If Nz([VarX], "") = "" Then
                XTrk_Name = "Points Management System"
                XHomeSet = False
            Else
                XTrk_Name = VarX
                XHomeSet = True
            End If
                    
    VarX = ""
            
            VarX = DLookup("[Trk_Short_Name]", "Track_Master", "[Trk_Home] = True")
                If Nz([VarX], "") = "" Then
                    XTrk_Short_Name = "Home Trk Not Setup"
                Else
                    XTrk_Short_Name = VarX
                End If
    VarX = ""
            
            VarX = DLookup("[Trk_Oper]", "Track_Master", "[Trk_Home] = True")
                If Nz([VarX], "") = "" Then
                    XTrk_Oper = "Home Oper Not Setup"
                Else
                    XTrk_Oper = VarX
                End If
        
    VarX = ""
            VarX = DLookup("[Trk_Desc]", "Track_Master", "[Trk_Home] = True")
                If Nz([VarX], "") = "" Then
                    XTrk_Desc = "Home Desc Not Setup"
                Else
                    XTrk_Desc = VarX
                End If
                
    VarX = ""
            VarX = DLookup("[Trk_ID]", "Track_Master", "[Trk_Home] = True")
                If Nz([VarX], "") = "" Then
                    XTrk_ID = 0
                    XHome_ID = 0
                Else
                    XTrk_ID = VarX
                    XHome_ID = VarX
                End If
End Sub

Function ParseTime(InTime, Outtime)
    'Determine The Format
    
    For x = 1 To Len(InTime)
        If Mid(InTime, x, 1) < 0 Or Mid(InTime, x, 1) > 9 Then
            Mid(InTime, x, 1) = ":"
        End If
    Next x
    Outtime = InTime
End Function
Function IsLoaded(ByVal strFormName As String) As Integer
' Returns True if the specified form is open in Form view or Datasheet view.
    
    Const conObjStateClosed = 0
    Const conDesignView = 0
    
    If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> conObjStateClosed Then
        If Forms(strFormName).CurrentView <> conDesignView Then
            IsLoaded = True
        End If
    End If
    
End Function
Public Function GetHomeTrack(Track_Data, Get_Data)
    
    Select Case Get_Data
    
        Case 1
            VarX = ""
            VarX = DLookup("[Trk_Name]", "Track_Master", "[Trk_Home] = True")
                    Track_Data = VarX
                    
                If Nz([VarX], "") = "" Then
                
                    If Not IsLoaded("CM_TRK_MASTER_01") Then
                        Msg = "You must setup at least one Track as the Home Track" & Chr(10) & Chr(13)
                        Msg = Msg & "Open the Track Master Control Setup and Select a Home Track"
                        MsgBox Msg
                        Cancel = True
                    End If
                Else
                    Home_Setup = True
                End If
                    
        Case 2
            VarX = ""
            VarX = DLookup("[Trk_Short_Name]", "Track_Master", "[Trk_Home] = True")
                    Track_Data = VarX
        Case 3
            VarX = ""
            VarX = DLookup("[Trk_Oper]", "Track_Master", "[Trk_Home] = True")
                    Track_Data = VarX
        Case 4
            VarX = ""
            VarX = DLookup("[Trk_Desc]", "Track_Master", "[Trk_Home] = True")
                    Track_Data = VarX
        Case 5
            VarX = ""
            VarX = DLookup("[Trk_ID]", "Track_Master", "[Trk_Home] = True")
                    Track_Data = VarX
                    
        End Select
        VarX = ""
End Function

 

 

[attachment deleted by admin]

Link to comment
https://forums.phpfreaks.com/topic/140079-visual-basic-to-php/#findComment-739039
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.