Recent content by jarico75@yahoo.

  1. J

    Very Urgent

    Is it giving you a runtime error? If not then you may want to save your work and close out of access and reopen. I changed all of you variable and ran the code fine. If you continue to have problems, you will need to look at the form fields you are referencing as possible errors. This is how...
  2. J

    Access noob - problem using query in VBA to change an object's property

    I agree with Kiwiman. You have a proble, with the SQL code, but I also changed the way you are evaluating your file. See changes in the select statement and the IF statement. Private Sub Form_AfterUpdate() Dim db As Database Dim Lrs As DAO.Recordset Dim LSQL As String Dim...
  3. J

    Select Case Statement issue:

    If I understand you correctly, You are better off setting focus yourself rather than trying to determine where access has placed the focus. Below is a very simple way of setting specific focus. Form.FirstFieldName.SetFocus 'Run your Code here Form.NextFieldname.SetFocus 'Run you next...
  4. J

    Importing specific fields from text file

    I found a fix....... If anyone would like to discuss let me know. Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim PathtoTextFile As String Dim PathtoMDB As String Dim myarray() As Variant Private Sub Form_Load() PathtoTextFile = "C:\" PathtoMDB = "C:\" End Sub...
  5. J

    Importing specific fields from text file

    So I cannot specify which fields to grab using this method? That is helpful. I was hoping to avoid having to loop through variables to insert the data. I unfortunately do not have any control over the file.
  6. J

    Importing specific fields from text file

    I have a text file with 261 fields that I need to import inot Access. Due to the limitation of 255 columns in an access table I need to import the fields into separate table. I have attempted to do this using the below code. I am receiving an error of "Syntax error in FROM clause" any help...
  7. J

    Manipulating Zip Files In Access

    I am looking for a way to selectively choose which files I extract from a Zip file. I believe that VBA can open a zip file and review the contents, but I am stuck on where I should start. Does anyone have experience doing this?
  8. J

    VBA Code Create query

    Add New Reference Because you are using Access 2003, the method you are using will not work unless you add the Microsoft DAO 3.6 Object Library. DAO is becoming an obsolete connection method, however it still has some bang where ADO does not.
Back
Top Bottom