Search results

  1. V

    open a secure database using vbs

    hi i can get the below code to work.. how do i add a command to run a macro after it opens access. Set objConnection = CreateObject("ADODB.Connection") Set accDB = CreateObject("Access.Application") accDB.visible = false objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data...
  2. V

    open a secure database using vbs

    hi guys I have the following code that works and opens an access database. how do i pass my username and password to prevent the logon screen from popping up? The database uses the workgroup security. any help would be appreciated. thanks in advance. Cheers! Set accDB =...
  3. V

    if statement help in vba

    There was a space between else and if. Thanks vbaInet.
  4. V

    if statement help in vba

    Hi New to VBA , Can some one please correct the code below. I ve heard that a select case statement might be even better then using If case statments. can you also please show me how to use the case statement for the code below? Thank you If Left(Me.Engine, 1) = 6 Then Engine_Type.Value...
  5. V

    filepath error when trying to transfer spreadsheet into access

    Thanks for your help guys. It works.
  6. V

    filepath error when trying to transfer spreadsheet into access

    Hi I have created a macro that will transfer an excel file data into an access table. the problem i am facing is that i want to specify the worksheet i want to transfer. in the macro window the file path i specify is C:\My Documents\[consume.xls]sheet 2 and it gives me an error. can i not...
  7. V

    list tables in a combo box

    Thank you guys. the website link was very useful for another part that i needed help on and the combo box works perfect with the code provided. cheers! Viren
  8. V

    list tables in a combo box

    Hi Is it possible to populate a combo box with a list of all tables in a database and view a tables contents based on the selection made in the combo box? thanks Viren
  9. V

    validate field entry

    thank you. it works great!!!
  10. V

    validate field entry

    hi I have a field with data type "number". i need to always validate that the first number entered is a 7,if not an error message. any help would be great. cheers Viren
  11. V

    Loaded Forms

    Hi Bob Thanks for your quick reply. I dont know how to incorporate this code into the database. Do I need to create a list box / command button and then attach this code to the on open event .. please help Viren
  12. V

    Loaded Forms

    Is there a way i can get a list of all loaded forms in my database? viren
  13. V

    Loaded Forms

    Hi Is there a way of knowing which forms are loaded in the database? viren
  14. V

    set focus

    It doesnt seem to work. error says that it cannot set focus on notes. regards viren
  15. V

    set focus

    i am trying to get the focus to change to another field as soon as a defect is recorded for a part. can some one please take a look at the code below and point me in the right direction.. thanks viren If SCR = -1 Then MsgBox " A DEFECT MUST BE RECORDED FOR THIS PART "...
  16. V

    user notification

    hi wiklendt my user logs in through ms access default login form with no password. (i have used the user level security wizard to create all users) and i want the program to alert me when a user logs into the database. thanks in advance
  17. V

    user notification

    thank you guys. appreciate it
  18. V

    user notification

    Hi George Thanks for the reply.. i dont understand what you mean? could you please explain in detail? thanks viren
  19. V

    user notification

    Is there a way of getting a message popup of a user who has just logged into the database?? :rolleyes:
  20. V

    sendKeys enter key to a message box with yes /no fields.

    Cheers i'll give that a go
Back
Top Bottom