Search results

  1. J

    Access VBA for Excel Copy & Paste

    I am brand new to the VBA world, and am using a macro I found on another website. I have been able to modify it so far to run, but it is erroring when it gets to the red text in the code. Any idea what is wrong with the code below? I basically want it to copy cells A2 through the end of the...
  2. J

    VBA Code to Call Excel Macro

    I have a VBA code written to call an Excel macro. The code runs, and it runs the Excel macro just fine, but for some reason in Access the code is erroring on the Excel macro even though it ran. Not sure what is happening. It is erroring on the red line of code. I did not write the Excel code...
  3. J

    Yes/No Box w/ VBA

    I am trying to make a yes/no box in VBA. I have no idea what I am doing in VBA, so please provide a dumbed down explanation. So far I have this saved in a Module, but I can't get it to run. I get an error that says "Compile error: Wrong number of arguments or invalid property assignment." I have...
  4. J

    Total Query to Group & Count Some Records Twice

    I know this is something that is probably pretty simple, but I am still new to Access and can't figure it out. I am trying to create a totals query that simply groups all the unit types into 2 categories (FL & TR) and gives me a total count for each type. However, the column that contains the...
  5. J

    New Girl in Town

    New to the forums, and pretty new to Access. I know absolutely nothing about VBA coding and am trying to learn more (any advice on a good class is appreciated).
Top Bottom