Search results

Excellent....I have removed the cross tab and set it with direct tbl.... It is wokring as desired... Thank you so much Arnel.. :) (y)

I want all dept names to appear down and appearance of 6 columns in each dept along with thier total number of employees nationality wize.

Hi, I have this cross tab query that I created using wizard and which generates figures to know how many employees employees of which nationality are in different departments. I used this cross tab query as data source to display graph on one form. TRANSFORM Count(T_JobOffer.CLetterDate) AS...

Absolutely correct...Thank you Pat..

Thanks Arnel for your usual support.

Hi Me.TextInspExpats = DCount("CDept", "T_JobOffer", "CNationality <> 'Irish' AND [CLastWorkingDate] Is Null AND [CNo] <> Null AND [CDept]='Inspection' AND [CCrNumber]= 2051223412") No error in above code and all conditions are working exept the last condition [CCrNumber]= 2051223412...

Now no error in below code strSQL = "UPDATE T_ATemp set [ExistingTotSaudis] = " & Me!OverAllSaudis & ", [ExistingTotExpats]= " & Me!OverAllExpats & ", [NewSaudiAddition]= " & Me!TxtNewSaudiPerc & ", [NewExpatAddtion]=" & NewExpatPerc But displays You are about Update (0) rows where as there is...

Datatype is number with 2 decimals. Dim strSQL As String strSQL = ("DELETE * FROM T_ATEMP") DoCmd.RunSQL strSQL strSQL = ("UPDATE T_ATemp set [ExistingTotSaudis] = " & Me!OverAllSaudis & ", [ExistingTotExpats]= " & Me!OverAllExpats & ", [NewSaudiAddition]= " & Me!TxtNewSaudiPerc & "...

I am trying to overwrite unbound text box data to a temporary tbl with below code but it produces subjected runtime error 3075. strSQL = "UPDATE T_ATemp set [ExistingTotSaudis] = '" & Me!OverAllSaudis & "', [ExistingTotExpats]= '" & Me!OverAllExpats & "', [NewSaudiAddition]= '" &...

Thanks June7. My backend is on server. I will try to make it local tble and send you.

I have placed one graph on form that represent existing number of different nationalities working in the company including local nationals. This graph is based on table call T_JobOffer. I categorized the data into 2 sections.... One textbox displays number of expatriates working in each dept...

Hi, I am wondering if there is possibility of changing graph which uses text box valued on form. I know graph changes based on values it takes from a table or query. But I need to display graph on same form while changing values in different text boxes. Example: let us say we have 5 text boxes...

It solved...I just tried with "Is Null" and not used IsNull which appeares in SQL design and worked... Thanks,

I am fetching up some records in a subform thru a query: SELECT T_JobOffer.CNo, T_JobOffer.CDept, T_JobOffer.CName, T_JobOffer.CLastWorkingDate FROM T_JobOffer WHERE (((T_JobOffer.CNo)<>IsEmpty("Cno")) AND ((T_JobOffer.CDept)=[forms]![F_SaudizationPercent]![TxtDeptEmp]) AND...

Thanks CJ_London, It is a simple and easy method....It is working now.. Thanks to June7 as well for the support.

Mulitple I looked into but it is not for subform.

Thanks June7, Any other thought?

My subform name is SF_DeptwizeEmps which is based on a simple query with 2 fields namely CNo, CName, CDept. I placed this subform on my main form named F_SaPercent. This forms have different lables placed on it that displays department name like: HR Admin ... .... In front of each label, I...

Select case is no doubt good idea. It worked. Thanks for all your support. (y)(y)

Thanks Ranman256 I shifted codelines to OnCurrent event of the form but is still same. I have attached pic just for ref. Percentage that is equal or less than 100....displaying colr effect but if more than 100 then code is not working I believe.