Recent content by catt

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?

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...

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)...

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...

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...

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...

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...

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

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 =...

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

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...

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

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 =...

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...

Thank You.