Search results

Thanks Arnel. It is working now.

I tried changing code with UPDATE query.... Dim strSQL As String strSQL = "UPDATE T_JobOffer " & _ "SET [CECompany]= '" & Forms!F_SaudizationPercent!CECompany & "', [CACompany]='" & Forms!F_SaudizationPercent!CACompany & "', [CCrNumber]='" & Forms!F_SaudizationPercent!CACompany & "', " &...

Also I like to know if my process is correct or not. Bcz as raised by oleronesoftwares, should I bring the data in unbound form first and then replace few fields? Please advise

Yes these both are string type. and CR number is number.

Still same error

Yes, you are correct but the limited data appearing on this continuous form is thru query and I am just updating 3 fields data in the tble where the CNo number is same as that appears on the form. I am replacing name of company and its CR number of the same record. Isnt it possible? Or it would...

The Continuous form is just to bring the data on screen and from there it will shift to tble T_JobOffer. The data source of this continuous form is a query that is based on tble T_JobOffer.

It is vba code which placed onclick event of a command btn on a continues form. I want to shift selected employees from that continues form and and store in relevent tble T_JobOffer. How to copy it in query n run?

Hello, For some reason, I would like to change company name (in 2 languages) and CR (Certificated of Registraton) in tble T_JobOffer with condtion if a particular CNo (candidate number) is what is at present on the form. In compilation no error found but at execution it produces Error 3075...

Hi, I have attached my db with least records. I was trying the show the percentage of employees different nationalities working in each dept which will show on click of the btn 'Show %age' on GRAPH tab of form. All unbound small text boxes shows percentage vertically under the each dept in...

Btns or textboxes will work at most of the places on the form except on chart itself. Neither we can get them on front of chart nor even make them visible or invisible if requires. They always go behind chart. My plan was just to place btns on bottom of each Bar and once clicked, it will show...

Hello, I have some working code in a Sub xxx() for the graph that placed on a form. This code was used for chart. The same chart I have placed on the report to send it concerned authorities in pdf. The graph in report is ok but some calculated figures which are appearing in the form are not...

Thanks oleronesoftwares, But what I was looking for is to place btn or unbound text box on LIVE chart and not on the image. Even if we place the code to convert the chart into an image and place btn over on, it will be useless for me as I have some other code behind btn that will change chart...

Hi, I would like to know if any unbound text box or a command btn can be on a graph that placed on a form. I tried to keep one unbound text box over to graph / chart wherein some calculated value will appear after clicking a command btn. I tried but it is going behind graph and only appearing...

This time it is working....let me check if there are still some errors.....

I did it Arnel. This is 3rd time I did that :)

Hi Pat, I tried to replace and made new SELECT query. But attached msg is appearing SELECT A.CDept, Count(A.CNationality) AS CountOfCNationality FROM A GROUP BY A.CDept HAVING (((A.CDept)<>"Top Management")) ORDER BY A.CDept;

Msg appearing "You can't assign a value to this object" and removing the modified code keeping the old one

Hi, My this query I created is presenting department wize employees including all nationalities. TRANSFORM Count(T_JobOffer.[CDept]) AS CountOfCDept SELECT T_JobOffer.[CDept] FROM T_JobOffer GROUP BY T_JobOffer.[CDept] ORDER BY T_JobOffer.[CDept] PIVOT T_JobOffer.[CNationality]; There is a...