Private Sub lstClients_Click()
Dim strQuery As String
strQuery = "SELECT * FROM Appointments INNER JOIN AppStatus ON Appointments.StatusID = AppStatus.StatusID
WHERE Appointments.CompID = " & strCompID & "ORDER BY DateTime DESC"
adoAppointments.RecordSource = strQuery
i had using the adodc and data grid to list out different appointments info for the different sales person. i face the problem when i try to update the information (AllowUpdate = True).
the data can be updated successfully if after i update that cells (eg row = 2) and i click the other row (except row = 2)
if i LostFocus from the data grid table (without click the other row) then the value i try to change will set back to the old value. (failed to update)
this situation also make me impossible to update the data if there got jus one row
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…