I'm using office 2007 with windows 7 on all machines.
I tried with office 2003 but also I have the problem.
User Profile
Collapse
-
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? -
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
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? -
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 =
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") -
Table Partitioning over 2 computers
Is there a way to partition a table and distribute the partitions over more than one computers? -
So, how can I test my work?
is there any unit test for windows?
THANKS.Leave a comment:
-
I'm wroking on windows and I think pgTap is not available for windows. right?
THANKS.Leave a comment:
-
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. -
-
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 -
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. -
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... -
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:
When I tried to connect to the database through iSQLplus,Code:An error occurred, but the error record could not be located.
the connection was success.
may someone help me to fix this problem.
THANKS. -
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.Leave a comment:
-
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 -
Ora-04092
I have a trigger as following:
When I execute an insert statement on the table MV_AUDIT, I got an error saying: "ORA-04092: cannot COMMIT in a trigger".Code:CREATE OR REPLACE TRIGGER TRG_REFRESH_MVIEW AFTER INSERT ON MV_AUDIT BEGIN DBMS_MVIEW.REFRESH('MV_SCH_STUDENT_AVAILABLE_COURS','A'); END;
What is the solution for this problem?
may someone help... -
Enable Parallel Execution
How I can enable the parallel execution in the database
in order to execute the SQL statement in parallel?
THANKS. -
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.
No activity results to display
Show More
Leave a comment: