Recent content by sullyman

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