Search results

Hi, This might have happened with many of us and they were helped by forum members. So I hope the same for myself.:) I just copied one of my db from Access 2007 and opened in Access 2016 with no code in errors but found strange thing that no buttons on the forms are workable where as if I...

Solved : I noticed that Hijri date was not storing in datetime format so I simply changed to nvarchar() and it worked. Thanks.....:)

Due to lots of table and records, I am controlling to fetch records to keep the form light weight....

Hi, Suddenly I facing ODBC call failed issue to store record in a linked table... I had previously stored 3-4 records and there were no issue but this error occurred today. My net connection is also fine MemoID is autonumber field.... Could you please help me. Dim db As DAO.Database Dim rst...

Thanks Pac-Man, Sorry for late reply as I was on long vacations. Yes, I tested your changed code and looks working smoothly. The only things the script doesn't provide formatted text that I used ("_") to add length of some characters in Urdu / Arabic which provides more beauty of the words...

I tried as below but still get same error : If IsNull(TxtSaudiAccounts.Value) And IsNull(TxtExpatAccounts.Value) Then TxtSaudiAccounts = 0: TxtExpatAccounts = 0 TxtAccSaudiPercent = 0 ElseIf Not IsNull(TxtSaudiAccounts.Value) And IsNull(TxtExpatAccounts.Value) Then TxtAccSaudiPercent = 100...

Thanks for the useful info. I tried with your above line but it produces error '6' - Overflow

I tried to calculated 2 text boxes value when there is value in both. But when both are null or any of them is null then I am getting "Run-time error 11 - Division by zero" for my this line : Nz(CLng(TxtAccSaudiPercent.Value), 0) = Nz(CLng(TxtSaudiAccounts.Value), 0) * (100 /...

Thanks Bastanu, Here is the error attached

Thanks Arnel This is my basic query which is working fine SELECT DISTINCTROW T_JobOffer.CDept, T_JobOffer.CNationalityExp, Count(*) AS [Count Of T_JobOffer], T_JobOffer.ProffGroupName, T_JobOffer.ProffGroupCode FROM T_JobOffer GROUP BY T_JobOffer.CDept, T_JobOffer.CNationalityExp...

Hi, Can you correct me in this code? Set rst = CurrentDb.OpenRecordset("SELECT CDept,CNationalityExp,ProffGroupName, ProffGroupCode, CLastWorkingDate, CCrNumber, Count(T_JobOffer.LetterRefNumber) AS CountOfLetterRefNumber FROM T_JobOffer" & _ " GROUP BY T_JobOffer.CDept...

Again Thanks theDBguy, I have attached my db herewith with min records and objects help you to understand my requirement. Just make first 5 check marks true one-by-one from top to bottom on the opening form and you will see 2 small graphs are appearing at the right side of the form. First...

When I used query as recordsource of graph and open the form, it says "The microsoft database engine doesnt recognize 'Form!F_SaudizatonPercent!TxtGroupCode' as valid field name or expression. Where as when I directly runing query and giving parameter value...it is working perfectly and...

Thanks theDBguy, In fact initially I tried using query to my graph but the ProffGroupCode ( Integer) changing on the form when I select different profession and my query is not supported to read the ProffGroupCode from form and make it as Criteria to generate data. So I decided go for VBA code.

My db contains a table called T_JobOffer where in 10s of job offer letter are available with diff data like departments, ProfessionName, ProfessionCode, Nationality etc. I want to count the number of Expatriates worker and Local National Worker by Profession wize and Department wize. So we know...

But it working normally in my 2019 Access and other pcs EXCEPT in the pc where 365 is installed. I am sure there must be something else reason. But what....

Off course, after calculations the graph changes.

Hello strive4peace, The code is general calculations using Dcount...Dlookup etc... that I used on an event of form where the graph is place. On form there is now issue in Access 2019. But when I placed a copy of it on another terminal where 365 is installed, my form is asking parameter value...

Finally I did it. I just placed Dlookup and counted records in each unbound text boxes in my report that represents percentages of Bars.

Hi, I would like to know if there is any specific lib file or trick or code to run my Access db in Access 365 version. Bcz it is working with all Access version from 2007 till 2016 except Access 365 particularly graph is not running. (not finding subform textbox data) My General Manager has...