Search results

option 1 i want it to be This isn't right

Well I used the SQLStr function as you describe title = " & SQLstr(me.title,false) & " where..." and still the apostrophe is double

the spaces aren't suppose to be there I just want to Emphasize the ' character which is double if I will add the chr(39) and replace it with chr(39)&chr(39) it still have twice of the '

Hi I would like to update a query with special characters like ' the update statement looks loke "update Task set titles = '" & titles & " ' where....." The problem is if I am using "update Task set titles = '" & replace (titles,"'","''") & " ' where....." is save in the database twice of the '...

Hi again I have another question regarding the same soulution. can I add another parameters to each cell? for example for each task there is a priority and I would like to sum the priorities like I did at the tasks so if a person has 6 tasks which 1 is low priority , 3 is mediom priority and 2...

Great thank you very much for your help

I meant how do I create a report that contain all employee in vba

Yeaaa the query works great thank you very much. Now can you please tell me how do add more rows for each employee?(like bound but in vba)

attached example file . you will be able to see that there are more status than the query I would like to create a report or a form that show the query

OK jow do I create it in vba? I would like ot create one text box for the employee and for every employee it will create another row

ok I created the crosstab. at the title I have the taske and on the keft I have the employee name.As you can see, the status wait doesn't have number becuase no one is waiting. If I will add text box with bound I will get an error message avout the wait status So I need to do it as unbound. I do...

ok. if so, how can I add more rows for each employee ? do you have an examlple for it?

it just a simple table sometime it could be 4 employee and sometimes more

I think I didn;t explain my self well. I will try to expalin again. If one team has 3 people and the other team have 10 people, the report for the 3 teams will look smaller . I have another idea. is there away to create a table with number of column as the employeesnumber? for example the A...

becasue i need to add maximum textboxes , lets say I have 40 employee and I have sometimes 5 tasks for 5 employee and sometimes I have 10 tasks for 10 people and the 10 in that case I need to add 10 textboxes . if the team will have 5 people the report will be very small.

Hello I would like to create a flexible reports with employee and tasks. The number of employee is flexible which mean sometime there are 8 and sometimes there are more and even less. I though of creating textbox for each employee which mean if I have 8 employees it should create 8 textboxs one...

the header should be flexible . sometimes there are 8 employees and sometimes could be more than that I would like to create very flexible report

i thought about it but lets say I have in one department with 5 employees and in another department 10 employees. if I understand correctly I have to inset 10 textboxes and assign the vba to them, so in one department the report will be in half page and for the seconf department it will be the...

this is the problem. I can't use fixed column heading. Is there a way to create flexible heading coulmns?

Hello I have a table with few employee, tasks and status_task. I would like to create a report that I will be able to see all employees in a columns and the tasks in a rows something like matrix form Any Ideas? Thanks