User Profile

Collapse

Profile Sidebar

Collapse
suet
suet
Last Activity: Mar 12 '12, 09:51 PM
Joined: Nov 21 '11
Location: CA,USA
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • suet
    started a topic Maximum size for exporting a table
    in Access

    Maximum size for exporting a table

    Is there a maximum size of the table that can be exported from Access to a text file? I have a table with a length of 519. After exported the table to text, the content seems to be truncated. Can someone provide me a suggestion?
    Thanks.
    See more | Go to post
    Last edited by Stewart Ross; Nov 30 '11, 08:36 PM. Reason: Moved to a separate thread - please do not post in an old thread (one dating from 2006 in your case)
    • suet
      replied to show blank in the date selection field
      in Access
      Right now instead of showing blank, it displays "#Name?". In the default value field, it has a value as =""
      Any suggestions?
      See more | Go to post

        Leave a comment:

      • suet
        started a topic show blank in the date selection field
        in Access

        show blank in the date selection field

        I have a date field on the form which is to be used as an optional selection criteria. How would I display this date field with a blank value when I open the form?
        See more | Go to post
        • suet
          replied to update groups of fields with sets of conditions
          in Access
          I applied IIF to my update query which works perfectly!
          Thanks a bunch!
          See more | Go to post

            Leave a comment:

          • suet
            replied to update groups of fields with sets of conditions
            in Access
            Hmm..I just realize the sql codes did not really explain what I am trying to do.
            I need to figure out if I can update "vendor chanage" and "vendor change date" based on one condition and "mod code change" and "mod code change date" with another condition within the same table. All 4 fields are in the same table. With other programming language, I can easily use case statement and code the criteria...
            See more | Go to post

              Leave a comment:

            • suet
              started a topic update groups of fields with sets of conditions
              in Access

              update groups of fields with sets of conditions

              I have a query that I like to run in SQL format, but it's not getting corret results. This is to update multiple fields with multiple conditions. Should I be using VB to apply this type of update? My preference is to run the query using macro. Does anyone out there has any suggestions?

              Here are sample codes:

              Code:
              UPDATE TBLE_2 INNER JOIN TBLE_1
    ON TBLE_2.part_no = TBLE_1.PART_NO
SET    TBLE_2.prime_vendor_change
              ...
              See more | Go to post
              Last edited by NeoPa; Nov 23 '11, 12:59 AM. Reason: Added mandatory [CODE] tags for you
              • suet
                replied to update with multiple conditions
                in Access
                What about the following type of update?
                update a code set to '1' if condition 1 is true or set to '2' if condition 2 is true or set to '3' if condition is true
                Can all these be done in single query?
                See more | Go to post

                  Leave a comment:

                • suet
                  replied to update with multiple conditions
                  in Access
                  Just tried to run the codes and works ok.
                  Thanks.
                  See more | Go to post

                    Leave a comment:

                  • suet
                    started a topic update with multiple conditions
                    in Access

                    update with multiple conditions

                    Still a novice in access query update and need some suggestions from expert out there...
                    I have a query that will update multiple fields based on speciefied conditions.
                    e.g. if a supplier is changed in the master table when compare to the one in my work table, I need to mark the vendor_change_f lag to 'Y'. Then the same query will check the release date of the product and mark the release date change flg to 'Y' if value is changed....
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...