User Profile

Collapse

Profile Sidebar

Collapse
JM420A
JM420A
Last Activity: Aug 20 '14, 04:47 AM
Joined: Jul 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JM420A
    replied to Invalid Use Of Null - No Null Values in table
    in Access
    Figured it out

    I created a make table query, from the values then ran the query from the tbl, it worked out well.
    See more | Go to post

      Leave a comment:

    • JM420A
      started a topic Invalid Use Of Null - No Null Values in table
      in Access

      Invalid Use Of Null - No Null Values in table

      I have a query that looks like this:

      SELECT qryPhysicals.NA ME, qryPhysicals.UP C, qryPhysicals.SS N, qryPhysicals.Ph ysDate, qryPhysicals.Ye arMo, qryPhysicals.Ti meElapsed
      FROM qryPhysicals
      order by qryPhysicals.Ti meElapsed desc

      This works fine.

      However, if I add a where clause,

      SELECT qryPhysicals.NA ME, qryPhysicals.UP C, qryPhysicals.SS N, qryPhysicals.Ph ysDate, qryPhysicals.Ye arMo,...
      See more | Go to post
      • JM420A
        replied to Calculating No. of Days excluding Public Holiday
        in Access
        As a thought, You could have a separate table that holds the date and title of your National Holidays. From there, you could do a query that searches for the dates where date not in (select * from holidaytable). My syntax is jacked up I'm sure, but it is more to give you an idea to start from.

        hope that helps.

        jm420a
        See more | Go to post

          Leave a comment:

        • JM420A
          replied to How to split by the value of a field and copy to respectively excel files?
          in Access
          I'm no pro, by any means, but I will throw this out there:

          Look in to building code using Select Case or IF statements

          Build a statement that looks for the city name and assign it to a variable

          strCityName = rsCity.cityname

          build your statement based off of that

          Then you can have one long piece of code that checks the value of the city name. It may take longer to write, but...
          See more | Go to post

            Leave a comment:

          • JM420A
            started a topic Parse a string to pull second of three words
            in Access

            Parse a string to pull second of three words

            Access 2k3

            Query:

            I have a string: DOE JOHN MICHAEL (last first middle)
            I need to pull JOHN out of it

            I can pull out DOE, and get the length of DOE, what I'm having trouble with is how to pull JOHN out. I've been working on it for a while and getting frustrated, so I'm coming to the pros for help.


            Here is what I have so far.
            Code:
            SELECT Left(tblUnit_Data_Current.NAME,InStr(1,
            ...
            See more | Go to post
            Last edited by NeoPa; Aug 5 '08, 08:01 PM. Reason: Please use the [CODE] tags provided
            • JM420A
              started a topic SendReport using value in table
              in Access

              SendReport using value in table

              Platform: Access 2003

              I have a table that has one record, need to pull the EmailAddress field to set as a value for a SendReport Command. I have searched for examples on line as to how to do this with no success.

              I was able to create the RS and didn't get any errors, but when I tried to view the value of the email field, it gave me a wrong number of properties/arguments error.

              Unfortunately I deleted...
              See more | Go to post
              • JM420A
                replied to Need help on creating macro to print reports sequentially
                in Access
                Stewart,
                Option 2 worked. I tried doing that before I asked and it didn't work. Must be one of those "Take the car to the mechanic so the noise stops issues"

                I'll probably post more

                You answered my question, thanks

                jm420a
                See more | Go to post

                  Leave a comment:

                • JM420A
                  started a topic Need help on creating macro to print reports sequentially
                  in Access

                  Need help on creating macro to print reports sequentially

                  I have 3 reports that I need to print sequentially, situation is this

                  R- Report
                  P-Person

                  R1 has 3 pages, one for each P
                  R2 " "
                  R3 " "

                  I would like to be able to print R1P1,R2P1,R3P1. .., then do the same thing for each subsequent person.

                  Any guidance or direction is greatly appreciated....
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...