Search results

  1. C

    Help

    Job # date employee# chemical# Employee# employee name Chemical# chemical name In the query link the employee# and the chemical# click on the TOTALS icon. Use Group by for job#, count for date, and count for employee name Three tables per above One query Is this what you need?
  2. C

    Import .lis files as .txt

    Hi Pat; Found it. Name Statement Example This example uses the Name statement to rename a file. For purposes of this example, assume that the directories or folders that are specified already exist. On the Macintosh, “HD:” is the default drive name and portions of the pathname are separated...
  3. C

    Import .lis files as .txt

    Hi RV; The original files are in a directory in my computer, (I run an Oracle process that produces the files in my PC with a .lis extension). I created a module the imports the file (after renaming the file with a new extension (.txt), by going into a DOS window and using the copy command)...
  4. C

    Import .lis files as .txt

    Hi: I import several flat files from the network daily, all of these files have a .lis extension. Currently I open up a dos window and copy the files from .lis to .txt. I would like to rename these files through VBA, before importing them into Access. Is this possible? I tried looking into...
  5. C

    Create Table & Add Data

    Dearest Pat: I wish you had been more specific, but I looked up the explanation for each of the arguments in the transfer database command and LO and BEHOLD the last word should be false, not true. Because I had copied the code from another post it didn't dawn on me that any of it was wrong...
  6. C

    Create Table & Add Data

    Hi Pat: I entered your code (copy paste) and placed it in the onclick command of a button on a form. Private Sub Command0_Click() Dim tablename As String tablename = InputBox("please type a table name,") DoCmd.TransferDatabase acExport, "Microsoft Access", CurrentDb.Name, acTable...
  7. C

    Create Table & Add Data

    Hi; INSERT INTO ABABA ( SOC, NAME, SumOfAMT, TERM ) SELECT AddChangeName.SOC, AddChangeName.NAME, AddChangeName.SumOfAMT, AddChangeName.TERM FROM AddChangeName WHERE (((AddChangeName.TERM)="200301")); This is the SQL I got from an append query. ABABA is the table created with the first...
  8. C

    Create Table & Add Data

    Hi Again; It is probably so simple it's going over my head. But the new code doesn't work. I even tried it as a separate procedure and it still doesn't work. Help Please!!! Judy
  9. C

    TransferText

    I was able to import text, in a limited way , which may help you. Dim FALL01 As String Dim SPRING02 As String Dim FALL02 As String Dim SPRING03 As String Dim SUMMER02 As String Dim SUMMER03 As String Dim FALL03 As String Dim WINTERIM02 As String Dim WINTERIM03 As String FALL01 =...
  10. C

    Create Table & Add Data

    Hi Crosmill; I tried typing "exec strSQL" after the strSQL line and I get a compile error. I added "exec" to the beginning of the strSQL line and I got a compile error. I don't understand execute the SQL.??? What am I doing wrong? Thank You, Judy
  11. C

    Create Table & Add Data

    Based on a prior post I created the following procedure, which creates a table (GREAT!!) but I can't get the data per the where statement to transfer over. I need all the fields populated (name, social, term, sumofamt) where I choose the term and the amount. I was trying to start by choosing...
  12. C

    import text file

    Thank You It would have taken me a while to figure out that "Then" was at the wrong line. Judy
  13. C

    import text file

    Hi: I am finally trying my hand at modules and VBA. I have converted some of my macros into modules and now would like to streamline some of the commands. One of the lines of the module imports a text file into a table. Dim FALL01 As String Dim SPRING02 As String FALL01 =...
  14. C

    A single report applying to different queries

    If one report can handle the data of several queries, it is easy to do. First, all the fields in each query must be named the same, if not use aliases. Second, copy the report as many times as there are queries giving each a new unique name. Then, open each report in design, click on the...
  15. C

    import flat files

    Thank You.
  16. C

    import flat files

    I regularly import flatfiles from our network in order dissect, compare and produce reports. The report generator that produces these flat files only create files with a .lis extension. Access only seems to accept .txt extensions. Renaming the original flat file is doable but it does not...
    • catt
    • Thread
    • Replies: 1
    • Forum: Macros
  17. C

    more than one action

    Unless I don't understand "action", you can assign whatever you want done to a macro. Even run macros from one macro. I usually separate my steps by the action I want done. Ex: Updating one table may require, first emptying it out, importing date, formatting data, using a query to make a new...
  18. C

    Automatic Compact

    In Access 2000 you can just check the "Compact on Close" checkbox on the General tab of the Access Tools/Options dialog box. This will allow the compacting to be automatic everytime you close.
  19. C

    addresses

    In order to match up the different addresses to the one company name, you need to give each company a unique identifier. You might not want to use a number with 15,000 entries but maybe a combination of the letters of the company names. With so many companies a number may be the only real...
  20. C

    Creating a Case Statement

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/xhtml/output/F1/D6/S5B2A6.asp I hope the above link above works, other wise look up my question under VBA coding and use the link from one of the answers given to me, which has a link, and then search for "case...
Back
Top Bottom