Recent content by jconverse

  1. J

    I need a function to loop a macro until a field reaches 0

    Can you get me started on what it would look like?
  2. J

    I need a function to loop a macro until a field reaches 0

    Thanks in advance!! I really have been out of VBA and Access for 5 years and have lost some of my edge. I need to loop a macro from a Function until a field in the Table [MakeRatio]![ASK] reaches 0. I can take care of the counting within the macro but I need to call a function from RUNCODE in a...
  3. J

    I can't name file from query DoCmd.OutputTo acReport

    I need help...I want to name a file from the results of a query in Access 2003 I have Private Sub Command0_Click() DoCmd.OutputTo acReport, "REPT_MAKE1", "MicrosoftExcelBiff8(*.xls)", "C:\" & Store# & ".xls", 0 End Sub I want to get to where I can name XLS from the query results I have a...
  4. J

    Macro Repeat Expression

    Hi all....I have a macro that I want to repeat only when there are records still in a table. I'm creating a flat file and deleting records as I write them. I want to stop writing when all the records are gone from the header table. I tried something like =[hdr]![wave_number] is not null and it...
See more
Top Bottom