User Profile

Collapse

Profile Sidebar

Collapse
angusfreefa
angusfreefa
Last Activity: Dec 1 '10, 03:53 AM
Joined: Sep 25 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • angusfreefa
    replied to Manually add MySQL access to PHP via php.ini
    in PHP
    Thanks Atli, XAMPP does help a lot.
    See more | Go to post

      Leave a comment:

    • angusfreefa
      started a topic Manually add MySQL access to PHP via php.ini
      in PHP

      Manually add MySQL access to PHP via php.ini

      I saw on the web saying that MYSQL is no longer bulit in PHP 5 and need some manually add in "libmySQL.d ll" in system32, then remove the ";" in front of "extension=php_ msql.dll ." in php.ini

      but below is the only extension i could find inside the php.ini, there is only extension=mysql .so but no extension=php_m sql.dll

      If you wish to have an extension loaded automatically, use the following...
      See more | Go to post
      • angusfreefa
        replied to Problem of transferring data from one table to another in the same DB
        in Access
        Thanks orangeCat for helping and topher23 for your detail explaination. These helps a lot.
        See more | Go to post

          Leave a comment:

        • angusfreefa
          started a topic Problem of transferring data from one table to another in the same DB
          in Access

          Problem of transferring data from one table to another in the same DB

          Dear All,

          I am facing a problem of transferring data between 2 tables within the same database.

          I set up 2 tables. The first table is the permanent table (oos_table) for saving records. the other table is a temp table (oos_table_temp ) for storing records which all data would be deleted after the data transferred to the permanent table.

          below is the code I am currently using.
          Code:
          Dim strNewTable
          ...
          See more | Go to post
          • angusfreefa
            replied to Send message to logged on user
            in Access
            Any one got any suggestion? thanks
            See more | Go to post

              Leave a comment:

            • angusfreefa
              replied to Send message to logged on user
              in Access
              I will be aware of this next time. Thanks NeoPa....
              See more | Go to post

                Leave a comment:

              • angusfreefa
                replied to Send message to logged on user
                in Access
                Also, the below code is from somewhere in Internet which i used for tracking who is logging-on the database and it work well.
                Code:
                Function ShowUserRosterMultipleUsersLocal()

    Dim cn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim Rst As DAO.Recordset
    
    Dim i, j As Long
    Dim StrComp As String
    Dim StrUser As String
    StrWhereAmI = CurrentProject.Path
                ...
                See more | Go to post
                Last edited by NeoPa; Sep 29 '09, 10:22 AM. Reason: Please use the [CODE] tags provided.

                  Leave a comment:

                • angusfreefa
                  replied to Send message to logged on user
                  in Access
                  Hi ADezii,
                  I am sincerely interested. I tried to make a Form for sending message, still I am not sure how to send to particular receiver. So now the code would show a pop-up form which all logged-on users can see the message.

                  Below is how I set up the Message sending Form.
                  A Form with a listbox, a textbox, a timer and a commandd button. User type message in the textbox, then the message saved in a table. the content...
                  See more | Go to post
                  Last edited by NeoPa; Sep 29 '09, 10:22 AM. Reason: Please use the [CODE] tags provided.

                    Leave a comment:

                  • angusfreefa
                    replied to Send message to logged on user
                    in Access
                    Thanks ADezii,

                    I got a question, how can the system identify who would be the receiver of the message? I am not expecting when i post a message in a Form, with a timer, Everone logged on would see the mesasage.

                    If you have have anything which likely to have similar function, You are welcome to send to my E-Mail: ** removed as per site rules **.

                    Thanks....
                    See more | Go to post
                    Last edited by NeoPa; Sep 28 '09, 07:06 PM. Reason: email removed as per rules.

                      Leave a comment:

                    • angusfreefa
                      replied to Send message to logged on user
                      in Access
                      Thanks NeoPa,
                      The thread is as below:

                      http://bytes.com/topic/access/answer...ge-logged-user

                      I saw you at the post also, haha

                      Cheers...
                      See more | Go to post

                        Leave a comment:

                      • angusfreefa
                        started a topic Send message to logged on user
                        in Access

                        Send message to logged on user

                        Dear all,

                        This is my first post in BYTES.
                        I am new to Access VBA. I am currently doing a database which serve as a central warehouse for 2 properties. The database is put on the company network so that users from different properties can access in the same time.
                        I have already having a code for checking who is logged on the database using ADODB, which works fine.

                        Here come to the problem, how can I send...
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...