User Profile

Collapse

Profile Sidebar

Collapse
osman7king
osman7king
Last Activity: Sep 11 '13, 05:07 AM
Joined: Sep 6 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • osman7king
    replied to OLE Server
    I'm using office 2007 with windows 7 on all machines.

    I tried with office 2003 but also I have the problem.
    See more | Go to post

    Leave a comment:


  • osman7king
    started a topic OLE Server

    OLE Server

    Hello,

    when I run an access database the form dose not displlay all its objects and I got the message:

    " The LinkMasterField s property setting has produced this error: 'A problem occurred while was communcating eith OLE server or ActiveX control' "

    I copied the file to another computer, It works normally!!

    may someone help me?
    See more | Go to post

  • Ok Dears,
    this is my code:
    Code:
    Private Sub save_Click()
    On Error GoTo Err_save_Click
    Dim v_balance As Double
    Dim v_final_balance As Double
    Dim v_move_type As String
    Dim strSQL As String
    Dim db As DAO.Database
    
    Set db = CurrentDb
    
    DoCmd.RunCommand acCmdSaveRecord
    
    
    If Forms![cash].employees_combo.Value = 0 And Forms![cash].cash_out_type_combo = 2 Then
    ...
    See more | Go to post

    Leave a comment:


  • How to back to the form after MsgBox to select a value?

    Hi dears,

    When the user press the Save button, the program should insure that a combo box has a value select.
    If not selected, a message box with single OK button should be opened. but when I press this button, the program is going to complete.

    I want to reinforce the program to back to the form after pressing OK button to select from a specific combo box.

    what is the best way?
    See more | Go to post

  • Oky,
    It works now

    I used DLookup function as you suggest:
    Code:
    Private Sub save_Click()
    On Error GoTo Err_save_Click
    Dim v_balance As Double
    Dim v_final_balance As Double
    
    Dim strSQL As String
    Dim db As DAO.Database
    
    Set db = CurrentDb
    
    DoCmd.RunCommand acCmdSaveRecord
    
    DoCmd.OpenQuery "Q_get_balance"
    
    
    
    v_balance =
    ...
    See more | Go to post

    Leave a comment:


  • How to RunSQL for update a record in ON CLICK event?

    I want to run an execute SQL statement which update a field in a table after clicking on "save" button

    here the code I use:
    Code:
    Private Sub save_Click()
    On Error GoTo Err_save_Click
    Dim v_balance As Double
    Dim v_final_balance As Double
    
        DoCmd.RunCommand acCmdSaveRecord
            
        v_balance = DoCmd.OpenQuery("SELECT closing_balance FROM balanceT")
    ...
    See more | Go to post

  • osman7king
    started a topic Table Partitioning over 2 computers

    Table Partitioning over 2 computers

    Is there a way to partition a table and distribute the partitions over more than one computers?
    See more | Go to post

  • osman7king
    replied to PostgreSQL Unit Test
    So, how can I test my work?
    is there any unit test for windows?

    THANKS.
    See more | Go to post

    Leave a comment:


  • osman7king
    replied to PostgreSQL Unit Test
    I'm wroking on windows and I think pgTap is not available for windows. right?

    THANKS.
    See more | Go to post

    Leave a comment:


  • osman7king
    started a topic PostgreSQL Certificate

    PostgreSQL Certificate

    I have a good hand on experience with PostgreSQL database and I need to get an international certificate for that.
    Are there certificates for PostgreSQL database, if yes, how can I prepare that?

    THANKS.
    See more | Go to post

  • osman7king
    replied to PostgreSQL Unit Test
    Stored procedures, functions and may be triggers.
    See more | Go to post

    Leave a comment:


  • osman7king
    started a topic PostgreSQL Unit Test

    PostgreSQL Unit Test

    I use Postgresql 9.1 and I need a unit test to ensure my work. So, is there a unit test to do that in a simple way?

    THANKS
    See more | Go to post

  • How postgresql 9.1 streaming replication achieve load balancing?

    I have build a replication system on two servers ( Master and Slave) with windows server 2003, how should I configure my application to achieve load balancing? Is load balancing done by the master server or there is another solution?

    THANKS.
    See more | Go to post

  • Postgresql database clustering (Replication)

    I have Postgresql 9.0 on windows operating system, and I want to build a replication system for high availability.

    I have read a lot about this issue, but I still have some miss understanding and I think I'm not ready to start.

    The most clear blog was:
    http://pgsnaga.blogspo t.com/2010/05/5-steps-to-implement-postgresql.html

    but it does not explain the second step in details.

    may...
    See more | Go to post

  • osman7king
    started a topic Connection Error to the database

    Connection Error to the database

    I have installed Oracle 10g on my PC. I tried to access to the database through Embarcadero DBArtisan 8.1.5 as SYSTEM
    user but I have got the following error message:
    Code:
    An error occurred, but the error record could not be located.
    When I tried to connect to the database through iSQLplus,
    the connection was success.

    may someone help me to fix this problem.

    THANKS.
    See more | Go to post

  • osman7king
    replied to EXP-00056 ORACLE error 12154 encountered
    dear rski..
    I have fixed the problem.
    there was a '@' charactre in the password of my database, and after I change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully.

    THANKS.
    See more | Go to post

    Leave a comment:


  • osman7king
    started a topic EXP-00056 ORACLE error 12154 encountered

    EXP-00056 ORACLE error 12154 encountered

    I have tried to export a database, but i got the following message:
    EXP-00056 ORACLE error 12154 encountered
    ORA-12154: TNS could not resolve the connect identifier specified

    but i can access the database successfully and the TNS is correct.

    Thanks
    See more | Go to post

  • osman7king
    started a topic Ora-04092

    Ora-04092

    I have a trigger as following:
    Code:
    CREATE OR REPLACE TRIGGER TRG_REFRESH_MVIEW
    AFTER INSERT
    ON MV_AUDIT
    BEGIN
    DBMS_MVIEW.REFRESH('MV_SCH_STUDENT_AVAILABLE_COURS','A');
    END;
    When I execute an insert statement on the table MV_AUDIT, I got an error saying: "ORA-04092: cannot COMMIT in a trigger".

    What is the solution for this problem?
    may someone help...
    See more | Go to post

  • osman7king
    started a topic Enable Parallel Execution

    Enable Parallel Execution

    How I can enable the parallel execution in the database
    in order to execute the SQL statement in parallel?

    THANKS.
    See more | Go to post

  • osman7king
    started a topic Automatic Refresh Materialized View

    Automatic Refresh Materialized View

    I have a materialized view which needs to be refreshed automatically once each day at a specific hour (2:00 PM).

    How can this be done?

    I need a clear example ,please.

    THANKS.
    See more | Go to post
No activity results to display
Show More
Working...