Search results

Is there away to maximise a form on load to cover the complete screen. I have managed to turn off the ribbon and can hide the sidebars etc. but is there a way to make the form completely fill the screen.

Hi folks - do you know if it is possible to use the Collect Data Feature (e.g. create email, manage replies) to send forms to users to automatically import into the DB by using an Access 2007 adp version file and SQL Server 2005? Currently in my 2007 adp version, the feature is not available...

I have received help with the query below to show how many employees have taken courses from the total amount of employees but i have hit a problem. The employees table contains the employeeid, name and location. An employee can take more than one course which is recorded in the ccompleted...

I have two queries which i would like to divide one from another. What is the Sql statement to do same please

I need to create a pie chart to show the percentage of employees who have completed a course. I have 3 tables Employees (PK_Employeeid, Employee) Courses (PK_Courseid, Course) Courses_Completed (PK_Completedid, FK_Employeeid, FK_Courseid) For example, if there are 100 employees and only 25...

I have turned on Record selector for my continuous form but the Record Selector bar creates a blank area in my Form Header. Is there a way to turn off the Record Selector part for the Form Header? I have my From header coloured blue so the Record selector is creating a vertical white space on...

Is it possible to have a nice looking dropdown similar to the existing dropdown (combobox) used for formatting text etc. in Access 2007

I have one table Employees that contains the EmployeeID (PK), Location & Department fields. All this information is imported in from another Dbase so it comes in like below: John Doe, 1, 13 As the Location and Department comes in as numbers that are programmed in the other database application...

I have been using a Primary key (numerical eg. 002, 003 etc. from Employees in a test database) and all is working fine. I now want to use the company system employee number eg. b002, b003 as the primary key but when i changed the records and used this new PK with combos etc., access declares...

Hi folks, I have multiple combos working together correctly as follows: Year Location Department Employee The combos bring back the correct records for that individual employee contained on a subform when the last combobox (employee) is selected. I'd like to break this down further so when...

Hi Folks, Have managed to get two cascading dropdowns working but need three and can't get the third working. (see included file) The CHistory form will only used to view courses completed by employees. I hope to include a Subform on the CHistory form to show the employees when the third...

Hi Folks, Access Noobie here. Having great difficulty linking result from 2 DropDown selections to a Subform. I have Location, Employee and Courses Table. I have managed to get the two dependant dropdowns working so upon clicking the first Location option, the Employee Dropdown is then updated...