Search:

Type: Posts; User: ExcelChampion; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Creating Bins based on Average Value *AND* Count

    Racking my brain on this one...

    creating a table of 1-10 buckets to show the average of values that fall in those buckets. The buckets are simply a min as the lowest, max as the highest, and the...
  2. Replies
    2
    Views
    149

    Re: MS Query Won't Allow Calculation

    Good eye! Thought I had set that to false, but I guess not. That did the trick.

    Thanks!
  3. Replies
    2
    Views
    149

    MS Query Won't Allow Calculation

    I added an MS Query statement to VBA to query data from an Access database. After it performs the query, its should calculate a worksheet with formulas that calculate based on data from the query. ...
  4. Replies
    1
    Views
    437

    Get VBA Code from Corrupt file

    My Access frontend is corrupted. Lately IT has been pushing out these updates that's been causing everyone to get the blue screen of death. While I was compacting my database (frontend), I got the...
  5. Replies
    6
    Views
    138

    Re: Quitting an instance of Excel

    Ok, this is weird. This code should close the instance of Excel, but it does not.


    Sub Close_Excel()
    Dim xlApp As Excel.Application
    Set xlApp = GetObject(, "Excel.Application")
    ...
  6. Replies
    6
    Views
    138

    Re: Quitting an instance of Excel

    That's right. Access is essentially creating a report for the user, so I don't want the macro to close Excel. It creates the report, and then shows it to the user. This instance of Excel is only...
  7. Replies
    6
    Views
    138

    Re: Quitting an instance of Excel

    Norie! You have helped me almost exclusively over the years. You're like my guardian angel. :rofl: Thank you so much...again.

    First, I don't know what I was thinking, but the Quit command I...
  8. Replies
    6
    Views
    138

    Quitting an instance of Excel

    I have a macro that creates an instance of Excel, does some stuff and then ends, leaving the workbook open and visible. If I then manually close workbook, the instance of Excel still remains running...
  9. Replies
    6
    Views
    397

    Re: Decimal places - VBA

    You da' man. I should have known that Value2 was it. Woulda', coulda', shoulda'...

    Thank you, Rory.
  10. Replies
    6
    Views
    397

    Re: Decimal places - VBA

    I was just thinking that too.
  11. Replies
    6
    Views
    397

    Re: Decimal places - VBA

    Thanks, but its still a no-go.

    I've tried that before (and I just tried it again to be sure), and though I'm not positive, I think it throws up a 'Type Mismatch' flag because the cell(s) actually...
  12. Replies
    6
    Views
    397

    Decimal places - VBA

    Something that I've worked around for years, and finally want to fix is, when a formula returns a number that extends out to more than two decimal places, the following code ends up rounding the...
  13. Replies
    4
    Views
    444

    Re: GetOpenFilename...what the heck

    [QUOTE=RoryA;4356284]ChDrive and ChDir only apply to the current application (instance).[QUOTE]

    Holy moly!!...I didn't even think of that. I'll try filedialog...good idea.
  14. Replies
    4
    Views
    444

    Re: GetOpenFilename...what the heck

    Thanks, but I don't understand your post. Of course the function itself does not open a file, and I said nothing of that in my post. I want it to open the window to a default folder. I think...
  15. Replies
    4
    Views
    444

    GetOpenFilename...what the heck

    I'm trying to open to a default folder but its not working and I have no idea why...

    I've played with my code, but it keeps opening to the System32 folder on the Windows folder.

    I'm in Access,...
  16. Re: Populate combo box from multiple fields

    Not sure what you're getting at but we have multiple products that need quoting. The table is a summary of said quote.
  17. Populate combo box from multiple fields

    I'm trying to figure out how to write a query for the row source of a combo box.

    In a table I have Fields: Prod1, Prod2, Prod3. Consider these the headers.

    Let's say in Prod1 I have, "ABC", in...
  18. Replies
    4
    Views
    372

    Re: Code check, please

    Craps out here: con.Execute sSql, lRows

    I'm thinking its a grammatical error somewhere...missing comma, asterisk, ??? But maybe its something else I'm over looking.

    Thanks.
  19. Replies
    4
    Views
    372

    Code check, please

    I cannot figure out what is wrong with this code. I get the error, "Object variable or With block variable not set."

    I just don't see the problem...


    Sub remDuplicates()
    Dim sSql As...
  20. Replies
    3
    Views
    4,808

    Re: Single Cell Array?

    Got it.

    Thanks guys.
  21. Replies
    3
    Views
    4,808

    Single Cell Array?

    Never ran into this before...guess it just never came up.

    So, I have a simple VBA array:

    vars = Range("G2:G" & Cells(Rows.Count, 7).End(xlUp).Row).Value

    where vars is DIM'd as a variant: Dim...
  22. Replies
    1
    Views
    263

    Re: ADO/DAO Excel 2010 Unrecognized

    Bump
  23. Replies
    1
    Views
    263

    ADO/DAO Excel 2010 Unrecognized

    Sorry if this has been talked to death, but I cannot find a solution after researching for a little over a week.

    Basically, I had code that created a connection from Excel to Access (and vice...
  24. ...error occurs because a macro or event name is expected to run when the event occurs

    I cannot figure out the solution to this error:


    This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen...
  25. Replies
    1
    Views
    390

    Excel 2007 Not Calcualting

    Made the plunge to XL2007 about a month ago. I have run across an issue twice now. A search of the internet shows that this is a common issue, but I have yet to be able to find a fix.

    My...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4