Buddy008,
If u are assining value of the Input Box to a numeric variable , and u press cancel or ok without entering anything in the text box , then only it raises an error . Otherwise I never really needed any code for Cancel button
Good luck
Vikram
Here is ur code , just try it out
Option Explicit
Private Declare Function GetMenu Lib "user32" (ByVal hwnd As Long) As Long
Private Declare Function GetSubMenu Lib "user32" (ByVal hMenu As Long, ByVal nPos As Long) As Long
Private Declare Function GetMenuItemID Lib...
If u want to have menus with icons (If I have correctly understood what u are saying) then u can use some APIS
If that is what u are looking for . Let me know
Good luck
Vikram
Which database are u using.
I was having same sort of problem in MS-Access.
Try this out
sql = "select * from tablename where date = format('" & DTPicker1.value & "','dd/mm/yyyy')"
It worked for me .
Good luck
Vikram Shah
Just Cut and Paste the code
Option Explicit
Private Declare Function GetMenu Lib "user32" (ByVal hwnd As Long) As Long
Private Declare Function GetSubMenu Lib "user32" (ByVal hMenu As Long, ByVal nPos As Long) As Long
Private Declare Function GetMenuItemID Lib...
One more thing zemp , the prompt character in Mask Edit Boxes make things dificult . If u want to set text , u have to first set mask = "" then set text to desired text.
Vikram
There are two options :
1. Create only form and create many frames which can be hidden and shown depending upon conditions. But having many frames say (15-20) is difficult to manage.
2.Create diff forms with same height and width , top and left .
According to me second option is a neat one ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.