Search results

  1. P

    External Name Not Defined

    Hi, I am trying to create a new column within an existing table in my db. I know I need to define the external field [PHARM_NAME], but I am new to VBA and am not sure of the syntax for defining it. I was trying to accomplish this in a query expression, but there are several other criteria and...
  2. P

    Subtotal VBA Not Working

    Hi, Does anyone know why the subtotal code below would only work with one column instead of all? It only sums the last (total) column. It's almost as if it doesn't recognize the other columns can be summed. They are all in the same format (General). Any help is appreciated! Set tbl =...
  3. P

    Need Prompt to Not Overwrite Files

    Hi, Users may want to filter on different selections and want to save several of these reports, so I am needing a way to not have my code attempt to overwrite or modify the existing file. I would need to also apply the formatting to whatever the secondary file name would be. Can someone please...
  4. P

    Error on Range("A1").SpecialCells(xlLastCell))

    Hi, This line of code will give me a "Method 'Range' of object '_Global' failed" error about 50% of the time I try to run the below code. Debug takes me to this line: Set rng = xlWS.Range(Range("A1"), xlWS.Range("A1").SpecialCells(xlLastCell)) Can anyone help with this problem?? Thanks...
  5. P

    Applying Table Formatting in Excel Export

    Hi, Is there a way to apply a certain table style in access VBA for an excel export? I've tried several things and nothing seems to be working for me. Any help is much appreciated. Here is what I have without attempting any table formatting: Private Sub SandorFormatting_Click() Dim...
  6. P

    Apply Table Formatting in Excel Export

    Hi, I've been scouring the internet trying to find a way to make this work. I want to apply excel table formatting to an export from Access using VBA. Below is what I currently have. Can anyone help?? :banghead: Private Sub SandorFormatting_Click() Dim Filename As String Dim month1 As String...
  7. P

    Display Max Date Text Box

    Hi, I've read several discussions on here and still have not been able to find a solution to my problem. I'm wanting to display the max date of a field in a text box on my report. I've tried the following: =DMax("[HbA1c_Test_Date]","QI_GAP_REPORT") w/and w/o brackets/quotes on each...
Back
Top Bottom