Search results

When you changed data again in the main form, did you again save that record to fully commit it

Thanks Bob, you've been a great help

I am only a noob Pat but on my test project, i ended up creating 3 forms to make things easier for people. One form for viewing records (View), one for editing (Edit) and one for adding (Add) new records. That way users easily could view, edit and add records

Hi Bob, thanks, yes they are stored as views. One final question and i'm finished for the evening as my mind is in overload. At present i am building combos from select statements. Is it possible to create a view of what should be in the combo and then from the combo use something like select...

When you change data in one of the tabs, is the record fully committed/saved first before you then go to the subform

Thanks Bob. I think it was creating a DSN on all users machines was turning me off using an accdb version. I have test queries saved through SSMS. Can i still use these through link version or do i need to create them again on client side. Sorry for the questions, i am just trying to get my head...

? How do i link the tables to SQL in new accdb format. Do i need to run vb to create a connection etc.

Thanks Bob, i will try same. Much appreciated

Thanks Bob - will try same and see how it goes. Would that mean that the Collect Data feature would also work in accdb format and update the data to sql server too

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.

Thanks Bob. What would be involved in converting my current adp file back to an accdb file. I have only one form as it's a test project.

Pity. I have been messing about with it for last hour or so and it's a great feature. I am currently developing a new application using Adp connecting to SQL. From reading online, there seems to be a lot of differences on using adp, mdb or accdb to achieve editing data in sql server 2005. Any...

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

Please help as this step will have my project 90% finished I have managed to add the three queries together to give me the required values below that i need but when i try to add the two values in the Total column, the values are not adding. Any ideas? Also, how would i go about diving...

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

Any ideas guys. This is driving me nuts :confused:

I am able to get the count of employees in the following query SELECT COUNT(Employee) AS TotalEmployees FROM dbo.Employees And i am able to get the employees who completed the course in another query SELECT EmployeeID FROM dbo.CourseCompleted WHERE (Courseid =...

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