Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. applek

    Unlock PC programmatically in VB

    Hello, is there anyway to unlock PC programmatically? I'm running Window 2k and running some scheduling task at night time. I manage to power-off the system after the task completed. But what I have found is in order to shut down and power off the system properly, the PC must be stayed in...
  2. applek

    delimiter problem in SQL SELECT statement

    ok...you are right. I try to clarify the situation: In VB, I have this variable strValue. This strValue is captured in the application. Ex: strValue = Sister's Friend. In the VB program, I have to retrieve the ID for the corresponding strValue. So, i have to pass the strValue which contain...
  3. applek

    delimiter problem in SQL SELECT statement

    Hi, All. I'm using SQL server and would like to know that if a record contain a string with few delimiter, For instance: FieldA FieldB 1 Sister's Friend 2 Cousin's Brother's food If i would like to retrieve the particular FieldA by passing the FieldB...
  4. applek

    EnumDateFormats to change the time regional setting

    I'm using the SetLocaleInfo function to overwrite the region setting of the time. Thanks anyway:)
  5. applek

    EnumDateFormats to change the time regional setting

    Thank you very much. I did solve my problem :)
  6. applek

    EnumDateFormats to change the time regional setting

    Thanks CCLINT. Well, i do this has my own purpose. I do encounter a problem where my application is written in VB and the DB is SQL server. My pc setting is "dd/mm/yyyy" and the application can run in my PC. However, it couldn't run in other PC as i discovered that there is other type...
  7. applek

    EnumDateFormats to change the time regional setting

    Hi, all. Is there anyway to change the time regional setting at application run-time according to my format? I have found some source code, there is some limitation as i would like to change the time format to dd/mm/yyyy and inside the setting, it doesn't have this kind of setting. Could we...
  8. applek

    masking password in SQL server 2000

    nope. I mean the field inside the table of SQL Server, not the field in VB design stage.
  9. applek

    masking password in SQL server 2000

    Hi, all. Is there anyway to mask the password when writing it to SQL server 2k? Either, can we control the password field in SQL server to be masked whenever data key-in? Pls advise.
  10. applek

    Check Table existence

    Hi, does anyone have any idea of how to check a table is exist in Microsoft Access? I mean in SQL form?
  11. applek

    Connection Type

    Hi. Regarding to the performance factor, which type of connection should we adopt if using SQL server: 1. Set a connection once at run time, exit it when eixt the whole application 2. Set a connection on a specified time, exit it when exit a certain function/procedure. Thus, it has to set...
  12. applek

    Assigning variable to menu name at run time?

    Well. I have my own reason to do so. Anyway, thanks for the help. I do solve the problem. Thank you so much for your attention.
  13. applek

    Assigning variable to menu name at run time?

    This is also kind of 'hard-code'? whenever u add a menu item and you have to add another menu name (in CASE type) in the program? As my purpose is: whenever i add a menu item in the form, i just need to add the menu name in the database without adding any code to the program. During the running...
  14. applek

    Assigning variable to menu name at run time?

    Hi. Is there any other way to assign a variable to menu.name? snippit code: dim oMenu as Menu while Not (rs.eof) oMenu.name = rs.Fields("Item") rs.Movenext loop As i understand that the menu name can not be assigned at run time. But i have to use the menu name to manipulate...
  15. applek

    How to set menu properties programmatically at run time?

    Hi. There are existing menus inside the form. My program is to define which user has the right access to which menu. These information will be retrieved from a DAtabase. For instance, i retrieve userID 123, who can only access menu1, menu2, menu3(the menu name of the form). Hence, i tell the...

Part and Inventory Search

Back
Top