Recent content by Mr.Access

I have a datagrid of three columns; 1. Comb-box1 : Employees' Names (DataSource : EmployeeBindingSource) 2. Comb-box2 : Coming Departure. (DataSource : DepartureBindingSource) 3. Text-box : ............... * How can I filter or re-bind the source of the second one as the first one value...

Thank you datAdrenaline but as someone told me that there's away to show clear and more details of these two commonds. I hope we can get it . Regards,

How can I generate tracking users statistics like .. * No. of users? * Who is online? * Charts if possible .. *... Any ideas ? Best Regards,

I'm going to create a ppt file for my mdb to give an overview of the software , Is there a standard or international strategy in how we go through the slideshow steps. Any ideas ? Best Regard,

Hi redneckgeek, I've got the sum of days in a month as : DATEDIFF(day, @date, DATEADD(Month, 1, @date)) But I couldn't get the desired result even with DATEPART & DATEDIFF ! Could you show me please ? Regards,

Hi All, I wanna create a query in vb.net related to SQL 2005 that gives me the number of days the employee spent or will in a specific month depending on the Contract period as follow: * The usere will input e.g : Contract StartDay = 10-Oct-08 Contract LastDay = 15-Oct-09 Month = Oct-09...

It's done .. Thanks SQL_Hell .

SELECT denied permission on .... Hi SQL_Hell , :) Many thanks for the fast reply but you know .. I've tried your idea but I got all fields appeared when I excuted the View with Kevin account ! and when I made the check-box ( ID and Code) "Deny" , an error msg pop up faced me (SELECT denied...

(SQL 2005) Suppose that I've a db that contains an (Employee table) consistes of the fields : - ID - Name - Code - Department and i'd like to show the user say (Kevin) just the name+Department of all employees and hide the ID+Code . I've tried to go to the Employee table properties >...

It works well . What a nice trick ! Mailman .. you are the man . Many thanks.

Hi, I have a query that contanis the (Employees Work Rotations) of 4 columns ; ------------------------------------------------------| In_Work | Out_Work | Work_Days | Off_Days ------------------------------------------------------| 01/01/2008 | 15/01/2008 | 15 | 4 20/01/2008...

Hi, The Visibility Property of the textbox doesn't take effect ? (Me.txtjob.BackColor = 16777215) where , it works properly with the "Detail" , Like : (Detail.BackColor = 16777215) Any ideas ?

Oh! Ambiguous name. in query expression 'fConcatChild("Order Details","OrderID","Quantity","Long",[OrderID])' . What should I do with this message ? Thanks.

Yes I did. I've created a Module with a name "fConcatChild" , but still the query can't recognize it ?! Any Ideas ? Thanks.

Hi pbaldy, I got the message (Undefined Function "fConcatChild" in expression) . What I did was : >>Copy the following "Select Statement" to the (SQL View) of a new query : SELECT Orders.*, fConcatChild("Order Details","OrderID","Quantity","Long",[OrderID]) AS SubFormValuesFROM Orders; >>...