Search results

  1. M

    Re-Bind a Combo-box by other in same datagrid

    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...
  2. M

    SQL 2005 db Tracking Users Statistics

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

    Question ppt slideshows' steps for mdb

    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,
  4. M

    Counting the month's days between two dates

    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...
  5. M

    Grant/Deny table fields permissions

    (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 >...
  6. M

    Query value from two records ??

    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...
  7. M

    Merge Query rows in a new one

    Dear Friends,:) I have 2 tables .. (GroupNo.) & (employee) The conjunction between them as : tbl1 tbl2 -------------------------- No. Name -------------------------- 1 John 1 Alian 1 Sali 2 Robert 2 ...... ... .. ...
  8. M

    MsgBox (Duplication in name)

    Dear Friends, I have an Employee table which includes: Emp_ID (PK) ……. FamilyName First _Name …… ….. In this case where the name is separated in to textboxes , how can I generate a MsgBox that indicated the name is already inserted (Duplication in name) in case of ? . Kind Regards,
  9. M

    LAST job ?!

    hi Friends , I have three tables : 1) Employee : * Emp_No *Emp_Name * ……….. 2) Job *Job_No * Job_Name * …………… Since the relation is (M:M) , that may an employee transfer from a job to other, the third table generated . 3) Org_Chart * Emp_No *Job_No *Date Now, How can I get just the...
  10. M

    Closing mdb interfaces ..

    Hi Friends,:) 3 small questions I need your help about ACCESS 2003 : Note: I'm using a workgroup for users access through the network and the .mdb located in PC as a server NO Front-end & Back-end . 1. Is there a software that can close the .mdb interfaces or forms in all users PCs ? for...
  11. M

    ALAS! No way to ACCESS !!

    Dear Freinds, I have a MS-ACCESS 2003 mdb located in a pc (as a server) and that mdb is shared with other users via a (mdw shortcut ) . The mdw has 4 groups (Admins ,Full data users, Read-only Users and users) . The shared mdb was going on properly and what I was afraid of is that when someone...
  12. M

    You don't have ...!!

    Hi Dears, I have an error message ("You don't have exclusive access to the database at this time. If you proceed to make changes, you will not be able to save them later") in the case of another user using the DB in the same time . The database has the following : - Created by Access 2003 -...
  13. M

    6 in one

    Hi Friends, I made a search on the forum looking for this point but I couldn’t get it as hoped .. Anyhow .. I have a.. •table contains all the employees images’ paths with other info –As in Northwine samle DB- . And a.. •form let the user specify the desired department . I want to display the...
  14. M

    Combo to Text & Vice versa

    Hi , I have a combobox and a textbox . The combo is a search control related to the textbox, fetch its data (employee number) from the Employee Table where the textbox has the ( employee name ) . How can I match or update the combo value auto. ,When the textbox value changed by using the mouse...
  15. M

    Monthy Time Sheet

    Dear Friends , I have a database that contains all the employees info. and I wonder about the following small cut that represent the monthly Time Sheet of an employee .. How can I implement it ? Best Regards,,
  16. M

    Trombinoscope ??

    Hi all, :) I want to design a Trombinoscope for my staff with an ACCESS 2003 form . How can I achieve this :confused: ------------------------------:rolleyes: Best wishes ..:rolleyes: ------------------------------
  17. M

    Do you think Access can do it ?!

    Hi all ,:) I’m going to create a DB that deals with the personnel payroll and administration . the DB will be shared in the server by many employees with an account for some ones for modifying and updating . Do you think that I can create it efficiently with MS_Access 2003 ? :confused: Best...
  18. M

    An EXE file ?

    Hi all , :) How can I deploy my Access program as an EXE file ? :confused: Best regards ..
  19. M

    A menu in a form ?

    Hi all :) , How can I add a menu ( File , Edit , .....) in my Access form ? :confused: many thanks 4 consideration ,,
Top Bottom