User Profile

Collapse

Profile Sidebar

Collapse
kommanman
kommanman
Last Activity: Aug 7 '23, 08:00 PM
Joined: Apr 17 '20
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kommanman
    started a topic Too many arguments
    in XML

    Too many arguments

    I keep getting too many arguments when I try to use ISNA. Cell F148 has "#N/A"

    =IF(ISBLANK(F14 8)," ",IF(ISBLANK(H1 47),"ok",IF(AND (H148="P/T",H147="F/T"),"Ok",IF(BG1 48>BG147,"OK",I F(BG148=BG147," OK",if(ISNA(f14 8,"")),"BAD"))) ))
    See more | Go to post
    • kommanman
      replied to Access copy/paste special
      in Access
      I do understand that this community helps and I'm grateful for all input. I'm used to working alone since I'm an Industrial Engineer and we don't have many friends. haha. Sorry for lack of detail but 'you don't know what you don't know" and I will work on my explanations in the future so as to not frustrate.
      Thanks again. Cheers.
      See more | Go to post

        Leave a comment:

      • kommanman
        replied to Access copy/paste special
        in Access
        Microsoft excel object library was not checked. Therefore all 'xl...'commands were not working. After change this worked for me.
        Code:
        TargetWorkbook.Worksheets("Daily Summary").Range("A100000").End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValuesAndNumberFormats
        thank you for your help and motivation.
        Cheers!!!
        See more | Go to post
        Last edited by NeoPa; May 5 '20, 08:15 PM. Reason: Added mandatory [CODE] tags.

          Leave a comment:

        • kommanman
          replied to Access copy/paste special
          in Access
          I apologize for lack of details but I have been trying many different ways to Paste/special on the last row from internet suggestions.(ap pend new data) This is my first attempt to manipulate data using Access VBA in Excel spreadsheet. Code works fine up to paste. I can copy and paste special.
          TargetWorkbook. Worksheets("Dai ly Summary").range ("A1111").paste special
          but I don't want line "A1111" I need to...
          See more | Go to post

            Leave a comment:

          • kommanman
            replied to Access copy/paste special
            in Access
            Compile error: Sub or Function not defined.
            See more | Go to post

              Leave a comment:

            • kommanman
              started a topic Access copy/paste special
              in Access

              Access copy/paste special

              I've run my queries in Access VBA and exported data into excel. I want to select Range("A4:AC4") (which are formulas reading from data just exported) and paste/values/formatting appending to bottom of same sheet. How do I find the bottom of data and place on next row.

              Code:
              Public Sub TEST()

Dim locationstring7 As String

locationstring7 = "J:\Reports.xlsx"


DoCmd.OpenQuery
              ...
              See more | Go to post
              Last edited by gits; May 2 '20, 09:45 AM. Reason: added code tags
              • kommanman
                replied to Date 16 digit string need to pull data for last hour
                in Access
                Thank you for all your help. This finally worked after refreshing Referencing tool.
                TrueDate:DateAd d("s",CInt(Val( Right([Date],4))/100),CDate(Form at(Left([Date],12),"@@@@\/@@\/@@ @@\:@@")))
                See more | Go to post
                Last edited by kommanman; Apr 21 '20, 09:05 PM. Reason: When I paste into reply, *s are added where spaces are in formula.

                  Leave a comment:

                • kommanman
                  replied to Date 16 digit string need to pull data for last hour
                  in Access
                  Got two errors. The first was a space after *4))_/100* which I deleted space. Then the "@@@@/@@.." was highlighted with error saying 'The expression you entered contains invalid syntax. you may have entered an operand without operator.'
                  I tried changing to:
                  TrueDate:DateAd d("s",CInt(Val( Right([Date],4))/100),CDate(Form at(Left([Date],12),#yyyy/mm/dd hh:mm#)))
                  with and without " " around #s but got...
                  See more | Go to post
                  Last edited by kommanman; Apr 20 '20, 05:52 PM. Reason: *s appeared after pasting.

                    Leave a comment:

                  • kommanman
                    started a topic Date 16 digit string need to pull data for last hour
                    in Access

                    Date 16 digit string need to pull data for last hour

                    Trying to pull data on what happened in the previous hour but date time is 16 digit string. (ex. 202004160955408 9)
                    When I use date() in criteria , nothing is returned. I can use 2020041609* but I want to make auto report without keying in criteria. any help is appreciated. thank you.
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...