User Profile

Collapse

Profile Sidebar

Collapse
Fotorat
Fotorat
Last Activity: Mar 28 '08, 04:01 PM
Joined: Oct 26 '06
Location: Swindon Wilts
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Fotorat
    started a topic Linking to ASP like a table for Reporting on?
    in Access

    Linking to ASP like a table for Reporting on?

    Hi

    I have an ASP table source:

    http://www.intrawide.n bsnet.co.uk/naff/common/ViewTableData.a sp?id=2007

    which I need to dynamically link into Access so that it appears as a table.

    Cant figure it out

    I have ACCESS 2003 on XP professional
    See more | Go to post
    • Fotorat
      started a topic PDF VB Sendobject on XP or 2003
      in General

      PDF VB Sendobject on XP or 2003

      I need to use the Send object function to email reports out via my internal email.

      at the moment I use:

      DoCmd.SendObjec t acSendQuery, rsDlist("Query Name"), acFormatXLS, rsDlist("Outloo k To")

      But need to email in PDF format and I cant get Access 2007, so I need to buy a pdf solution so that I can have a PDF format option.

      any suggestions - ideally a UK vendor by US is...
      See more | Go to post
      • Fotorat
        replied to Opportunity in Swindon, Wiltshire, England
        in General
        Thanks Neopa, still no joy!
        See more | Go to post

          Leave a comment:

        • Fotorat
          started a topic Opportunity in Swindon, Wiltshire, England
          in General

          Opportunity in Swindon, Wiltshire, England

          I know this is a cop out but I have a report request from a client that I cant resolve, I can do the cross tab query but as the headers change each time period I cant figure out how to set the report up. I dont know VBA but would welcome a solution based on that.

          I need a quick turnaround so I am offering £400 per day for up to 2 weeks so £4000 for 2 weeks in my office at swindon to analyse my issue, make a rec ommendation, do it,...
          See more | Go to post
          Last edited by NeoPa; Dec 2 '06, 11:20 AM. Reason: Clothed naked e-mail.
          • Fotorat
            replied to Using Cross Tab qry as Report Source Value seems 2b TXT!!
            in Access
            Now I feel a right idiot, I am still doing the same report and in the page footer I need column totals. =sum() wont work, nor does =val(), nor does any combination of =sum(cdbl()) or = sum(Clng()) any suggestions?
            See more | Go to post

              Leave a comment:

            • Fotorat
              started a topic Report Formating lost when saving to RTF
              in Access

              Report Formating lost when saving to RTF

              Access 97
              Office XP Professional
              Word 2002

              I would like to know how I can keep my Access Report formatting when I export to RTF and view in Word 2002.

              Bolding comes accross ok, but I am losing my headers which are Active X - Access Rotate Text Control 1.2
              See more | Go to post
              • Fotorat
                replied to Using Cross Tab qry as Report Source Value seems 2b TXT!!
                in Access
                Excellent that help me nail it, I used this in the detail section to sum each row:

                =Val([1-Transfers])+([2-Transfers]) ect

                I think you should be charging for this service- but as you don't I am helping out on some questions that I know!
                See more | Go to post

                  Leave a comment:

                • Fotorat
                  replied to Need help Importing data from excel
                  in Access
                  I think I know what you mean, to start importing from into the 3rd access tbl field you could simply insert to blank columns into the excel sheet so column A and B are blank.

                  the second problem you have in your formula cells in excel is that you are actually pasting in the formula text not the result of the formula. you can get around this in excel by highligthing the whole sheet and doing copy> paste special > values. warning>...
                  See more | Go to post

                    Leave a comment:

                  • Fotorat
                    replied to Using Cross Tab qry as Report Source Value seems 2b TXT!!
                    in Access
                    Yes I have numbers up until the cross tab which converts the summed values into Text - so I need to know how to force the cross to retain the numerical formatting on its value field
                    See more | Go to post

                      Leave a comment:

                    • Fotorat
                      started a topic Using Cross Tab qry as Report Source Value seems 2b TXT!!
                      in Access

                      Using Cross Tab qry as Report Source Value seems 2b TXT!!

                      I have this transform:

                      TRANSFORM Nz(Sum(IIf([CODE]="L",[TOTAL],[TOTAL])),0) AS SumOfTOTAL
                      SELECT UNION.JOB
                      FROM [UNION]
                      WHERE (((UNION.JOB) Not Like "**Other - Non RetailPosition* *" And (UNION.JOB) Not Like "Dec*"))
                      GROUP BY UNION.JOB
                      ORDER BY [UNION].[Months2] & '-' & [CODE]
                      PIVOT [UNION].[Months2] & '-' & [CODE];


                      And I want...
                      See more | Go to post
                      • Fotorat
                        started a topic arrggg! Query to complex!!!
                        in Access

                        arrggg! Query to complex!!!

                        I did this code converts a date into a value -1 to -12 to be used in crosstab report headers.

                        The problems arises when I insert the last IIF statement for month -12!!!

                        up to -11 it runs and works but I get The Expression you entered is to complexwhen I inseert the last iff for -12. Any ideas???

                        this is what tips it over:

                        ,IIf(DatePart(" m",[EFFDT])=DatePart("m", (DateAdd("m",-12,Now()))),"-12")...
                        See more | Go to post
                        Last edited by Fotorat; Oct 26 '06, 02:08 PM. Reason: wrong error msg
                        • Fotorat
                          replied to Cross tab qry for report
                          in Access
                          Brilliant - many thanks

                          I had tried that earlier with no success but this worked:

                          TRANSFORM Nz(Sum(IIf([CODE]="L",[TOTAL],[TOTAL])),0) AS SumOfTOTAL

                          No if anyone can start me of one assigning 0 to 12 for the last 12 months

                          I am clutching at straws like this:

                          MonthsAgo: IIf(DatePart("m ",[EFFDT])=DateAdd("m",-1,Now()),"-1","next ...
                          See more | Go to post

                            Leave a comment:

                          • Fotorat
                            started a topic Cross tab qry for report
                            in Access

                            Cross tab qry for report

                            Access 97 windows XP Pro

                            I have done a crosstab query for a report with 12 months as the columns and job codes as rows counting people as the value:

                            Link to view report so far

                            Ps the zeros in there so far came from an outer join so I could show Job codes with no transfers or leavers and I used rotate text active X for the headers.

                            I have 2 questions

                            1- How can I force "0"...
                            See more | Go to post
                            No activity results to display
                            Show More
                            Working...