User Profile

Collapse

Profile Sidebar

Collapse
chinfk
chinfk
Last Activity: Oct 20 '08, 06:22 AM
Joined: Oct 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • chinfk
    started a topic Did treeview 5 support for hyperlink data ?
    in Access

    Did treeview 5 support for hyperlink data ?

    Hi All,

    I have a table that consist of hyperlink field, but when it display in treeview as text not in hyperlink format.

    Did any one have an ideal how to present the hyperlink field format in Treeview ?
    See more | Go to post
    • chinfk
      replied to How to export out the OLE object content to a folder (c:\temp)
      in Access
      Hi Brother Fish,

      Thanks for your advice, did this feature available in MS access ?
      See more | Go to post

        Leave a comment:

      • chinfk
        started a topic How to export out the OLE object content to a folder (c:\temp)
        in Access

        How to export out the OLE object content to a folder (c:\temp)

        Hi Guys,

        I have OLE field in the tables, in the datasheet view, it is written there as "packager". Usually, I insert the field content by insert object ways ( insert a PDF ).

        How should I export all the files / object to a particular folder in C:\Temp ?

        Thanks in advancevd.
        See more | Go to post
        • chinfk
          replied to How to make sure output to outlook express not MS outlook
          in Access
          Hi Jim,

          Come on, don't be stingy. Share your knowledge ... =)

          Cheers.
          See more | Go to post

            Leave a comment:

          • chinfk
            replied to How to make sure output to outlook express not MS outlook
            in Access
            Jim,

            I have find in the net which provide the solution for the code below.
            But I have yet to try to combine it with the docmd.sendobjec t because
            it have errors. Please take a look of it.

            ----- start of module code -----
            Option Compare Database
            Option Explicit

            Private Type MapiRecip
            Reserved As Long
            RecipClass As Long
            Name As String
            Address As String...
            See more | Go to post

              Leave a comment:

            • chinfk
              replied to How to make sure output to outlook express not MS outlook
              in Access
              Hi Jim,

              I do chanhe the default email in the IE to outlook express and remove the outlook program as well. But when run the program, it will then prompt for mail
              profiles instead.

              Maybe there is other place to change default email software in the registry or
              maybe have to create a profiles for it.

              Any ideal ?
              See more | Go to post

                Leave a comment:

              • chinfk
                started a topic How to make sure output to outlook express not MS outlook
                in Access

                How to make sure output to outlook express not MS outlook

                In my program, i had set that report to be output as an attachment in the email.

                But recently, one of the user find that it output by using Microsoft outlook rather than previous one which use outlook express.

                How to switch it back to outlook express ?

                The program code as below :

                DoCmd.SendObjec t acSendReport, "PhoneBillMaste r-tmp-rpt", acFormatRTF, , "leess@abc.com" ,...
                See more | Go to post
                • chinfk
                  replied to How to prevent the overlapse range entry ?
                  in Access
                  Hi Brother FIsh,

                  The order no range will consist of alphanumeric value, so i had to string it else will get data type mismatch error.
                  See more | Go to post

                    Leave a comment:

                  • chinfk
                    replied to How to prevent the overlapse range entry ?
                    in Access
                    Hi Brother Fish,

                    There is the loop hole in my program which it can detect the overlapse range
                    But for the value that smaller or larger than the current range of data, it can't
                    allow that.

                    My code as below:

                    If DCount("[ID]", "Temp-QA2", "((str(SN) > " & .SN & " And str(SN) < "
                    & .EN & ")
                    ...
                    See more | Go to post

                      Leave a comment:

                    • chinfk
                      replied to How to prevent the overlapse range entry ?
                      in Access
                      Hi Brother FishHal,

                      Thanks for your helps and i have modify to what my program needs, it works definitely.

                      Thanks and wish you have a nice day ya!
                      See more | Go to post

                        Leave a comment:

                      • chinfk
                        started a topic How to prevent the overlapse range entry ?
                        in Access

                        How to prevent the overlapse range entry ?

                        Hi There,

                        I hav a entry said order serial no from 001 - 700, in the QA approval entry for this range no could be partial.

                        Less said 1st lot - (001 - 100), 2nd lot - (300 - 420) and so on.
                        How to prevent user to key in 050 - 070 or something are in within the previous entry ?

                        I had manage to limit the entry from 001 - 700, but in between that overlapse is had to control.

                        Any suggestion...
                        See more | Go to post
                        • chinfk
                          replied to How to stop this popup msg ?
                          in Access
                          Thks for the advice, i hav find the reason why it popup by disable or remark the
                          delete temp table in cancel button.

                          So by doing that when user select the order it won't pop up that msg again.

                          Thanks again n hav a nice day ya. =)
                          See more | Go to post

                            Leave a comment:

                          • chinfk
                            replied to How to stop this popup msg ?
                            in Access
                            Yes it is bound to order header
                            See more | Go to post

                              Leave a comment:

                            • chinfk
                              replied to How to stop this popup msg ?
                              in Access
                              My after update has below code : (No subform)

                              DoCmd.SetWarnin gs False
                              DoCmd.RunSQL "DELETE [Temp-OrderHeader].* FROM [Temp-OrderHeader];"
                              DoCmd.RunSQL "DELETE [Temp-OrderDetail].* FROM [Temp-OrderDetail];"
                              DoCmd.RunSQL "INSERT INTO [Temp-OrderHeader] ( Type, ORDNO, SYSDATE, MODEL, SUBJECT, ORDDATE, ETA, REV, PACK, ETA2, REMARK1, REMARK2, REMARK3, REMARK4, REMARK5, REMARK6, Location ) SELECT...
                              See more | Go to post

                                Leave a comment:

                              • chinfk
                                started a topic How to stop this popup msg ?
                                in Access

                                How to stop this popup msg ?

                                I has a combo-box in the form, that after update event it keep on pop up below msg :

                                "The data has been changed. Another user edited this record and saved
                                the changes before you attempted to save your changes. Re-edit the
                                record."

                                How can i stop this ?

                                Thanks for advanced.
                                See more | Go to post
                                No activity results to display
                                Show More
                                Working...