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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jambai

  1. jambai

    List of Softwares installed using VBScript

    Thanks for your suggestion. But I am clearing the values (svalue,sPublisher, etc.,) after inserting into database. When I run this code today I am getting the display name as "?b?[&o". Yesterday it was like "?["
  2. jambai

    List of Softwares installed using VBScript

    When I use the below function to get the list of installed software in a computer, I am getting the product name as "?[" or some other junk character when the DisplayName is empty in the registery Private Function GetAddRemove(sComp) As String Dim cnt, oReg, sBaseKey, iRC, aSubKeys, iPN, ix...
  3. jambai

    Access 2010-Disable Exit under File menu

    Hi, Can anyone tell me how to disable Exit option under File Menu (Not the "X" on the top right corner) in Access 2010. Thanks Jambai
  4. jambai

    Access VBA to exclude holidays and weekends from a datediff formula

    Check this out http://www.mvps.org/access/datetime/date0012.htm Thanks Jambai
  5. jambai

    access backwards compatibility

    In addition to dhookom's point, coulpe of features were discontinued in Access 2010. Like Calendar control. So if you were used those in your 2003, then you will not be able to access those functionalities in 2010. Check it here, you will get more insight about backward compatibility...
  6. jambai

    How can I get my emails generated from MS Access to automatically send

    tstrike, Insert the send mail procedure into AutoExec Macro and let the routine runs by timer event. The Access needs to be opened for this. I would create a service to do this. Thanks Jambai
  7. jambai

    MS Access 2007 - Can it open/use prior MS Access Versions?

    assets, Try to open it using 2003 and then 2010.
  8. jambai

    Need to assign read/write or read only permissions for Access 2007 DB

    User-level security is not supported by the new file formats in Microsoft Office Access 2007. http://office.microsoft.com/en-us/access-help/what-happened-to-user-level-security-HA010234561.aspx Thanks
  9. jambai

    Application Exit and MSAccess Termination

    assets, The Microsoft link that I copied in my previous reply has code to disable the close option (Alt+F4). The user can still close the application through File/Exit option or double click the application on the top left corner. You can customize the File/Exit through customize the ribbon...
  10. jambai

    How to automate Word using VB code

    Change file name in CreateNewWordDoc .SaveAs (AppPath & "\ MyNewWordDoc.doc") Sub CreateNewWordDoc() Dim wrdApp As Word.Application Dim wrdDoc As Word.Document Dim AppPath As String AppPath = Application.CurrentProject.Path Set wrdApp = CreateObject("Word.Application")...
  11. jambai

    access 2007 customize qat

    If you could share the xml and the procedure to use, it would be helpful.
  12. jambai

    access 2007 customize qat

    See if this helps http://msdn.microsoft.com/en-us/library/ee704589.aspx
  13. jambai

    How do you lock down the navigation pane from users?

    http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/0a34dbec-5078-4e16-b6a7-78f62c39f1bf/
  14. jambai

    Clock in/ Clock out

    For some reason you are not getting the Args in the below line. strInOut = Forms!frmClock.OpenArgs The workaround would be, Keep a hidden textbox in the form where you are calling frmClock. Fill the value of the textbox based on the button click. ("In", "Out") Private Sub cmdIn_Click()...
  15. jambai

    Application Exit and MSAccess Termination

    I would disable the X on the database and force the user to close the application through the button click. The below link will tells you how to disable System Close and X http://support.microsoft.com/kb/245746 Thanks

Part and Inventory Search

Back
Top