Search results

is there anyway to set a password to prevent other people from editing the codes of my project?

actually my code is fine.. it is working.. after i added Private Sub Image47_Click() Dim DBpath As String On Error GoTo Err_Image47_Click If IsNull([Yield Trend Chart]) Then Me.Image47.Picture = "K:\Staff Folders\JinLong\New Folder\nochart.jpg" Else DBpath = [Yield Trend...

i have entered the following codes Private Sub Image47_Click() Dim DBpath As String On Error GoTo Err_Image47_Click If IsNull([Yield Trend Chart]) Then Me.Image47.Picture = "K:\Staff Folders\JinLong\New Folder\nochart.jpg" Else DBpath = [Yield Trend Chart]...

ok.. solved the problem with Form_Switchboard.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "

ok solved it... Private Sub Image56_Click() Dim DBpath As String If IsNull([Yield Trend Chart]) Then Me.Image56.Picture = "K:\Staff Folders\JinLong\New Folder\default.jpg" Else DBpath = [Yield Trend Chart] Me.Image56.Picture = DBpath End If End Sub thanks...

it tried to replace If IsNull(DBpath) Or DBpath = "" Then with If Nz([Yield Trend Chart],"") then but it show Run-time error '13': Type mismatch

the error shown was Run-time error '94': invalid use of null

sorry.. i dont get what u mean by this

i tried the sample and changed the code to Private Sub Image56_Click() Dim DBpath As String DBpath = [Yield Trend Chart] Me.Image56.Picture = DBpath If IsNull(DBpath) Or DBpath = "" Then Else Me.Image56.Picture = "K:\Staff Folders\JinLong\New Folder\default.jpg" End...

but closing the form only will bring me back to the sub switchboard.. i need to get back directly to the main switchboard

after i open a form using the switch board, i need to click a button to close the form and return back to the default switchboard.. what code do i need to put in the button to do the task?

Private Sub Form_Load() DoCmd.Maximize Me.Image56.Picture = "K:\Staff Folders\JinLong\New Folder\default.jpg" End Sub Private Sub Image56_Click() Dim DBpath As String If [Yield Trend Chart].Value Is Not Null Then DBpath = [Yield Trend Chart] Me.Image56.Picture = DBpath Else...

how to maximize the form when you load it?

anyone can help?

lets say i have a data field which contains hyperlink for a html file, can i display the content of the file from the hyperlink in the form when the form is loaded?