User Profile

Collapse

Profile Sidebar

Collapse
bae14
bae14
Last Activity: Feb 17 '09, 03:39 PM
Joined: May 22 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bae14
    replied to Substring a variable length field
    in Visual Basic
    Thanks for all responses. Actually I got them split and then used the "replace" to remove the underscore. The replace command will really be useful. Thanks. And Stewart, I used a form of your Left and Mid to get the original breakout. I appreciate everyone's help!
    See more | Go to post

      Leave a comment:

    • bae14
      started a topic Substring a variable length field
      in Visual Basic

      Substring a variable length field

      Hi, I'm hoping for some help on how to substring a field using VB. I have fields such as B6002_1.9.6.15C O, 103456_304793. I need the #'s and digits both to the left and right of the underscore as separate fields (B6002 as one field and then 1.9.6.15CO as a second field). The underscore is never in the same position in the field. Can anyone please help? thanks
      See more | Go to post
      • bae14
        replied to Import a date like JAN-07 in MMM-YY in access
        in Access
        Thanks a lot for both of your help. I may try putting in an arbitrary day and see if I can work it from that angle. Thanks SO MUCH!
        See more | Go to post

          Leave a comment:

        • bae14
          started a topic Import a date like JAN-07 in MMM-YY in access
          in Access

          Import a date like JAN-07 in MMM-YY in access

          I have a file I'm trying to import into Access that has dates in it that are in the form MMM-YY (JAN-07) and Access isn't letting me import it in as a date. It says type conversion error. I need this field to come in as a date because I want to prompt a user for a date range for them to get a list of data. For instance, Enter a date range desired and they will put in JAN-07 and then DEC-07. Thanks for any help you can give.
          See more | Go to post
          • bae14
            replied to Prompt a user for a file in Access
            in Access
            Thanks so much for your help! I believe I can get beyond this now. Have a good day.
            See more | Go to post

              Leave a comment:

            • bae14
              replied to Prompt a user for a file in Access
              in Access
              Actually my code passed through the error and got to "ImportIt" and says the sub or function not defined. Any help on this one rather than the one I just posted? Thanks!
              See more | Go to post

                Leave a comment:

              • bae14
                replied to Prompt a user for a file in Access
                in Access
                That helped. Thanks! BUT, now I get a "run time error" '438'. It says the object doesn't support this property or method. It is stopping on the Filters.Add line. Any ideas? Thanks a lot for your help.
                See more | Go to post

                  Leave a comment:

                • bae14
                  started a topic Prompt a user for a file in Access
                  in Access

                  Prompt a user for a file in Access

                  I have been trying to prompt a user for a file name. I'm using the code below but keep getting the message "compile error: Method or data member not found". It is stopping on the Application.Fil eDialog line. Any help would be greatly appreciated!!

                  Code:
                  Private Sub Command13_Click()

Dim myDialog As FileDialog
Dim strFile As String
Dim strSearchPath As String
Dim vrtSelectedItem As Variant
                  ...
                  See more | Go to post
                  Last edited by NeoPa; May 25 '07, 07:28 PM. Reason: Tags
                  • bae14
                    replied to Prompt user to search for file to import using macro actions
                    in Access
                    Is this process different for Access 97? How do I "use" this once it is created? I would like to use this on a form where a user would click on a button and have it prompt to import a file. Thanks!
                    See more | Go to post

                      Leave a comment:

                    No activity results to display
                    Show More
                    Working...