Search results

  1. B

    Formatting Tables with VBA

    So, I want to insert an iterative calculation into successive columns of a table. Using a loop, I calculate the first the number as use INSERT INTO Table1 VALUES Number1. Then do the same for Number2, Number3....etc The result is each calculation on its own record, when I want it all in one...
  2. B

    Defining Global Variables

    I want to define, not just declare, a global string array for use in all my subs and functions in my module. I know how to define a global function, but I can not call this function in the same way I could call an array. I could use a class, but I want all the code to be in the same standard...
  3. B

    SQL Variables

    So, I need to create a query to read values from a table that was created my multiple people. Some people wrote in the Days Field: 1,2,3,4 While others wrote: 1.2.3.4 While others wrote: ALL I could just clean up the data, but that might be futile because if we ever want to add data with an...
  4. B

    String Arrays and Function Calls

    I have some very important code that I need to write myself but am relatively new to VBA. I need to be able to: 1.) Obtain the field names of a query 2.) Place those field names in a string array 3.) Use the string array in looped a function call I found some good tutorials on the first two...
Back
Top Bottom