User Profile

Collapse

Profile Sidebar

Collapse
Wayne L
Wayne L
Last Activity: Dec 9 '10, 05:52 PM
Joined: Sep 20 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Wayne L
    replied to Import Text Code does not see my file??
    in Access
    Found out what was missing..
    DoCmd.TransferT ext acImportFixed, "TLimport", "TblTL", strFolderPath & strFile,
    I needed to add the folder path and the file together..
    Attached code is what worked. Thanks for the assist!!!

    Code:
    Dim strFolderPath As String
Dim strFile As String
  
strFolderPath = "C:\SFOEDL\TL\"
  
strFile = Dir(strFolderPath &
    ...
    See more | Go to post
    Last edited by Wayne L; Nov 16 '10, 06:41 PM. Reason: figured out the problem

      Leave a comment:

    • Wayne L
      started a topic Import Text Code does not see my file??
      in Access

      Import Text Code does not see my file??

      Can someone tell my why this is not seeing my file in its location because it is there. Iam trying to import all .txt files in one folder and then archive in a seperate folder. I am not an expert by any means.. know enough to be dangerous..

      Code:
      Private Sub ImportFiles_Click()
    Dim RSO As Object
    Dim strFolderPath As String
    Dim strFile As String
    Set RSO = CreateObject("Scripting.FileSystemObject")
      ...
      See more | Go to post
      • Wayne L
        replied to Import (1) Text File with (3) different Header Records (3)Different Tables
        in Access
        Below i have bolded and underlined what I want to key on with the loop..
        Currently I have set up three differenent tables to import them into and add some missing data and append to the correct format for export. The file has to stay in its current state with no changes except for the card colums. It is currently working in my current DB but would like to take this one file and import to their seperate tables instead of breaking them up into...
        See more | Go to post

          Leave a comment:

        • Wayne L
          started a topic Import (1) Text File with (3) different Header Records (3)Different Tables
          in Access

          Import (1) Text File with (3) different Header Records (3)Different Tables

          I am not sure on how I should approach this. I know a loop but I am a newbee on this..I have one file that contains 3 seperate header records that contain data under each header.
          (AA AA) (AA BB) (AA CC)
          What I want to do is loop thru the data under each header data. I am using ACCESS 2000 and have import Specs for each one.
          (AA AA)Data in (Table1) and
          (AA BB)DATA in (Table2) and
          (AA CC)Data in (Table3)
          ...
          See more | Go to post
          Last edited by Wayne L; Nov 15 '10, 05:37 PM. Reason: wrong version of access
          • Wayne L
            replied to Import (1) Text File with (3) different Header Records (3)Different Tables
            in Visual Basic
            Sorry folks looks like I posted this in the wrong forum..
            See more | Go to post

              Leave a comment:

            • Wayne L
              started a topic Import (1) Text File with (3) different Header Records (3)Different Tables
              in Visual Basic

              Import (1) Text File with (3) different Header Records (3)Different Tables

              I have moved this question to the correct forum..
              See more | Go to post
              Last edited by Wayne L; Nov 15 '10, 04:02 PM. Reason: posted in wrong forum...
              • Wayne L
                started a topic MS Access Question Loop and delete
                in Visual Basic

                MS Access Question Loop and delete

                Is there a way to loop thru looking for duplicated values in a table "column1" and look at the next row in column2 for a value and if the value equals BBB then delete the duplicate values.

                column1 column2

                AAA
                AAA
                -------------BBB

                CCC
                CCC
                CCC
                -------------BBB
                See more | Go to post
                • Wayne L
                  started a topic Table insert question
                  in Visual Basic

                  Table insert question

                  I have a table with Field1, Field2
                  Field Two may have 2 or more duplicate values. I want to insert a 0 (zero) in field one in a new row after the duplicate values in field 2.

                  11111
                  11111
                  0
                  22222
                  22222
                  22222
                  0
                  See more | Go to post
                  • Wayne L
                    started a topic Export with extention of .61R
                    in Access

                    Export with extention of .61R

                    I have an ACCESS database that exports data for import into a DBF database. I did not know that the program for import requires a certain type of extention other then .txt. The type is "File" Can MS Access export other then .txt and Excel and .csv files. I have tried to export with different extentions and nothing gets exported.
                    Thanks,
                    Wayne L.
                    See more | Go to post
                    • Wayne L
                      replied to Auto Number field and ReSet used only for export files
                      in Access
                      I will keep on eye on it and thanks for the reply. I was hoping to reach a number and have it reset when it reaches the goal number. I could not figure that one out....
                      See more | Go to post

                        Leave a comment:

                      • Wayne L
                        replied to Field is Decimal and I want to Zero Fill
                        in Access
                        Thanks for the input. I am taking the approach of multiplying to remove the decimal and then zero fill with an update query.
                        Thanks again for you input.
                        Wayne
                        See more | Go to post

                          Leave a comment:

                        • Wayne L
                          replied to Field is Decimal and I want to Zero Fill
                          in Access
                          Rabbit,
                          I have tried to change it to text but it converts back to a decimal. I am importing a .dbf file into the Access database. The field actually has 4 decimals to the right. example: 2.2050 this is converted to 2.20 when imported. I need to zero fill and read 220 as 00000000000220. I have created a temp table and append the master table to convert it to text but it changes back to the 4 decimal places??
                          Wayne...
                          See more | Go to post

                            Leave a comment:

                          • Wayne L
                            started a topic Field is Decimal and I want to Zero Fill
                            in Access

                            Field is Decimal and I want to Zero Fill

                            I have a table that is named “field14" that is set to
                            Data Type: Currency
                            Format: Fixed
                            Decimal Places: 2

                            This field is populated correctly but I want to convert the currency to 14 digest with zero fill. Example: "2.20" would be "00000000000220 " I have tried an update query with format but it didn't work. Any suggestions?
                            Thanks,
                            Wayne L
                            See more | Go to post
                            • Wayne L
                              started a topic Auto Number field and ReSet used only for export files
                              in Access

                              Auto Number field and ReSet used only for export files

                              Ok now everyone has mentioned not to use auto number if it means anything to the user. My application uses the auto number for exporting only. I append the mastertbl column with my starting number of 0001(4 digits) (prior to populating the table). When information is imported and appended via a query to the mastertbl it will start with 0002 and increment. All tables used are cleared with a delete query after being exported, this allows the number...
                              See more | Go to post
                              • Wayne L
                                replied to Auto Increment and Reset Number Sequence in a Table
                                in Access
                                Ok, I have read enough about autonumber not to use this for my output file. I am trying to use the DMax function that you have sited and i have inserted it into my form "BeforeInse rt" It is not working properly. My numbers are still null in my table when new records are being added. I may not have the knowledge on the proper way to insert the DMax function.
                                See more | Go to post

                                  Leave a comment:

                                • Wayne L
                                  replied to Export a table but increment the name
                                  in Access
                                  Here is what worked for me.


                                  [Code=vb]Private Sub Export_text_Dat e_Click()
                                  'TheDate = Month(Date) & "-" & Day(Date) & "-" & year(Date)
                                  TheDate = (Format(Now(), "yymmdd-hhmmss AM/PM")) & ".txt"
                                  TheFile = ("C:\FSMFILES\A 4A\A4A ") & TheDate & ""
                                  DoCmd.TransferT ext acExportFixed, "Import/Export SPECS", "YourTbl",(TheF ile),...
                                  See more | Go to post

                                    Leave a comment:

                                  • Wayne L
                                    replied to Auto Increment and Reset Number Sequence in a Table
                                    in Access
                                    Nico,
                                    Thanks for the input. I was looking at the DMax also. I am kind of new writing code. I just want to throw an idea towards you about the autonumber. My table starts with a number of 9000 (Now) and the number can never reach 10000. I have a compact and repair set up on exit which resets the number now but if the user goes in twice a day the number will be duplicated because the orig table is truncated before exit.
                                    Now the solution...
                                    See more | Go to post

                                      Leave a comment:

                                    • Wayne L
                                      started a topic Export a table but increment the name
                                      in Access

                                      Export a table but increment the name

                                      I posted a question simalar to this before but was not clear on what I was trying to do. I am using two tables one primary and a temp table. I import my data to the temp table and bounce it against the primary table and append the primary table with the new data for export. The problem is I have set a command button to do this and if the user selects the button twice the name of the output.txt file is then zero. I need to add an increment number...
                                      See more | Go to post
                                      • Wayne L
                                        replied to Auto Increment and Reset Number Sequence in a Table
                                        in Access
                                        Nico,
                                        I have been trying to get the module to update my table and I seem to be running into trouble. I am using your sample but can not get the table to update when new data is added to it. Can I just use DMax on an autonumber field and have the number reset when it reaches a certain number?
                                        Thanks,
                                        Wayne L
                                        See more | Go to post

                                          Leave a comment:

                                        • Wayne L
                                          replied to Auto Increment and Reset Number Sequence in a Table
                                          in Access
                                          Thanks Nic;o)
                                          I looked at it briefly and it may be what I need. My database is pretty simple. The table is imported to one table and appended to another table with standard default data. That is where I need to insert the sequenced numbers a total of 4. then the data is exported. Thanks for the sample database. I am going to look at it closer today.
                                          Regards,
                                          Wayne L...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...