Recent content by proballin

  1. P

    Accepting Correct Parameters from Query to Report

    The report is opened through a macro which runs the queries first (asking for the input criteria) then opens the report.
  2. P

    Accepting Correct Parameters from Query to Report

    I am having trouble understanding what parameters are being passed from my query to my report. Currently I have the field name in a report title set to a field name (account type) from my query. The proper name appears based on the user input that I created in the query Criteria area. The only...
  3. P

    Export from Access Creates new Worksheet instead of Updating

    You are right MailMan...I did that and it all works out now. Thanks!
  4. P

    Export from Access Creates new Worksheet instead of Updating

    I have a macro in Access that should update my worksheet called "Sum". However instead of updating the sheet it creates a new worksheet called "Sum1". In Access I am using the TransferSpreadsheet operation for the Macro. Any clue as to why it will not update the existing "Sum" worksheet but...
  5. P

    "Code Execution has been Interrupted"

    I am going through an excel sheet and deleting a whole row of cells using the following code: Do While Not IsEmpty(Cells(r, 21)) Cells(r, 21).Select Selection.ClearContents Cells(r, 22).Select Selection.ClearContents r = r + 1 Loop However...
  6. P

    Nested Function too Large?

    Luckily I found a way around it. This is what I ended up using: =IF(AND(Spread!$F$12 = LEFT($K2,2),MONTH($B2)=3),S2+Spread!$E$12, IF(AND(Spread!$F$13 = LEFT($K2,2),MONTH($B2)=5),S2+Spread!$E$13, IF(AND(Spread!$F$14 = LEFT($K2,2),MONTH($B2)=7),S2+Spread!$E$14, IF(AND(Spread!$F$15 =...
  7. P

    Nested Function too Large?

    I have a nested function: =IF(AND(NOT(ISERR(FIND("CH",K2))),MONTH(B2)=3),S2+Spread!E$12,IF(AND(NOT(ISERR(FIND("CK",K2))),MONTH(B2)=5),S2+Spread!E$13,IF(AND(NOT(ISERR(FIND("CN",K2))),MONTH(B2)=7),S2+Spread!E$14,IF(AND(NOT(ISERR(FIND("CU",K2))),MONTH(B2)=9),S2+Spread!E$15...
  8. P

    Getting the Formatted Value from Cells

    Ohhhhh...I got ya. Yeah for my case I needed what was being displayed only, not the literal value. Good looking out though Bob!
  9. P

    Getting the Formatted Value from Cells

    Really? Why is that? Also .Value did not work for me. It would still return the full date as opposed to just the Month and the Year.
  10. P

    Getting the Formatted Value from Cells

    I was able to get that date in VBA by doing: Cells(i,j).Text Adding the .Text works.
  11. P

    Getting the Formatted Value from Cells

    Gotcha...thanks!
  12. P

    Getting the Formatted Value from Cells

    I have dates in my excel sheet that originally were put in in the mm/dd/yyyy format. However I right clicked on it, did "Format Cell" and changed it to the "Jan-01" format. However when I do a comparison statement in VB it still compares the cells to the original format of mm/dd/yyyy and it...
  13. P

    "Do While" issue

    That looks to have solved the problem. I just took off the ".value" off of Cells(i, 1). Thanks!
  14. P

    "Do While" issue

    The code below works fine as far as putting the right things in each cell. However the code just continues to loop and never exits. Is the first line in my code correct? Do While Cells(i, 1).value = "Chicago" Cells(i, 4).Select Selection.Copy...
  15. P

    Conditional Copy From one Worksheet to Another in Excel

    I have a worksheet in excel that contains data that can go in either 5 worksheets depending on location. Once I figure out the specific worksheet to paste the particular cell in, I then have to figure out under which year and month to place the text. So pretty much I have 3 conditions that must...
Top Bottom