Good day iI am happy to join this science community- my first project need help

[walidkamel245]

kindly find attchment my projet
when open transcation the enty no 2 it reates it self - if you pls help me - thank you

 

[Gasman]

I open transactions and nothing changes?
It's source is

SELECT TransActions.TransID, TransActions.TransDate, TransActions.MZ, Sum(MoneyMoves.Debit) AS Totol
FROM TransActions INNER JOIN MoneyMoves ON TransActions.TransID = MoneyMoves.TransID
GROUP BY TransActions.TransID, TransActions.TransDate, TransActions.MZ;

 

[walidkamel245]

thnk you for yor reply can make dubbel clik

choose trancation form and make dubbel clik on no 2 by clor gray you find may proplem

 

[walidkamel245]

 

[walidkamel245]

MoneyMoves1 MoneyMoves1

رقم الحساب​	الحساب​	مدين​	دائن​	رقم السند​	شرح الحركة​
91009004​	ASS-TRANSPORTATION & CARS​	90,348.00​	0.00​	2​	​
95095001​	PREVIOUS YEAR P& L​	0.00​	90,348.00​	2​	​
91009004​	ASS-TRANSPORTATION & CARS​	90,348.00​	0.00​	2​	​
95095001​	PREVIOUS YEAR P& L​	0.00​	90,348.00​	2​	​

this dubel if you remve that the trancation repet aging

 

[Gasman]

And I get

and if I open the form manually I get the error then

I am out as I cannot read Arabic and recognise fields etc

 

[MajP]

And I get

I found I get this in all arabic written databases. Only solution i found is to create a new DB and import.

 

[walidkamel245]

ok thnk you i will make chang and import

 

[MajP]

ok thnk you i will make chang and import

No. We would have to import into an english version. I do not think there is something you can do on your end.

 

[Gasman]

No. We would have to import into an english version. I do not think there is something you can do on your end.

I just tried importing into a new DB amd got the same issue?

 

[MajP]

Me too. Normally this will fix it.

 

[MajP]

Believe this describes the cause.

I have to believe there is some globabl setting to fix this.

 

[walidkamel245]

good dy my english DB-

 

[walidkamel245]

the basic entry 2000 in record no 3

when we open it in form trancation make duble

 

[pbaldy]

@walidkamel245 accidentally reported post 12 instead of replying to it. Reply was:

tahks for help

 

[walidkamel245]

any one help pls

 

[Gasman]

any one help pls

Still get

That is despite changing the code to
DoCmd.OpenForm "EditRecords", , , "[TransID]= " & Me.TransID 'Forms![Transactions]![TransID]"

Supply something that at least works and shows the issue.

Not even sure what you are trying to do, as that doubleclick opens form Edit Records whose source is Transactions1 and the table is empty?

 

[walidkamel245]

thank you Gasman i will do it

 

[MajP]

@walidkamel245. Unfortunately, I do not think you can do anything on your side. I believe this is a language variant problem. It will run fine on your system, but not on an English version. Hopefully, someone here can look at it. I currently do not have the time. I think we can open it if we change our regional settings to match yours. Can you tell us what your regional settings are? If not we may be able to just look at the code and see if we see the issue without being able to run it. I may have a chance later today.

 

[Gasman]

Your sql in the load event of EditRecords form is invalid anyway ?

This works

Insert into TransActions1 select * from TransActions
Insert into MoneyMoves1 SELECT TransID, AccID, Debit,Credit,NoRec, Note FROM MoneyMoves

you had

CurrentDb.Execute "Insert into TransActions1 (select * from TransActions"
CurrentDb.Execute "Insert into MoneyMoves1 (SELECT TransID, AccID, Debit,Credit,NoRec, Note FROM MoneyMoves)"

You really need to test SQL statements before trying to run them with VBA.