Search results

I want to prevent ms access from automatically saving changes on a form when I navigate or close the form. Instead, I have a Save button I 'd like the end user to use. I find that you can use a unbound form to control the saving of a record by using a button only. But using an unbound form...

I am using Access 2010 with linked tables from SQL Server 2008. I have a form that takes a QCNote from the end user. The control source query of the form looks like this: SELECT B.QCDecisionPointID, B.Description AS [Decision Point], C.QCResultDecisionPointID, C.QCNote, C.QCResult...

I am using an Access 2010 database with linked tables from SQL Server 2008. I have a form that needs to get it's data from a table valued function in SQL. The function takes two integer parameters. I was not able to convert the underlying SQL query to Access, and am therefore hoping to use a...

I am using Access 2010 with linked tables from SQL Server 2008. I have one user-editable field on my form, which is the only field that is auto-saved by Access into the Result table, when navigating from record to record or when the form is closed. Since I do need to save changes that the user...

I am using Access 2010 with linked tables from SQL Server 2008. I have a form where a end user must be able to edit a textbox with notes and see the latest changes made. First I tried to use a query to populate the form and for edits/updates to the Notes textbox. A Submit button already...