It is sometimes useful to let a user sort, filter etc. by right clicking on a field and bringing up the short menu.
I have noticed that with the run-time environment (test with /runtime at end of shortcut) right clicking is not allowed anymore.
Is there any flexibility here such as being able...
I should have looked more carefully before asking this question - sorry!
However I have now discovered the ADO error object and whilst NativeError and Number properties are strange, I notice that the SQLState property matches some of the Jet Errors I used to use. eg.
errorhandler:
Dim errado...
When I used VB6 with DAO to talk to Access97 I was able to respond to 'Cant Update Record locked' messages by trapping error 3186
Now I am using ADO with Access2002 backend, 3186 is not trapped and the error comes up as -2147217887 but with the same error message "cant update, record is...
Maybe not a solution but perhaps of interest is the fact that we were unable to upgrade our Windows 2000 to SP3 or 4 and Microsoft help asked us if we had used a third party partition manager on the disk recently.
We had used Paragon Partition Manager to enlarge the primary partition...
Its more hyperthetical than a particular problem.
One of the advantages (I thought) of going to Access XP was to use single record locking rather than page locking so that there would be less conflicts.
All my Access applications primarily use code to manipulate records and trap the usual lock...
Am I right in thinking that just converting one's Access Application from 97 to 2002 is not enough to take advantage of single record locking (even if database is set to single record locking) and that you have to use ADO with "locking mode" set to "row mode"?
i.e. My...
I think I have solved the problem with my last statement.
After I posted the thread, I tried inserting the following:
Application.SetOption "Confirm document Deletions", False
and it appears to work in ordinary Access XP so assume it will work in Runtime.
I can't believe this is not easily solvable but even though I switch 'confirm record changes', 'confirm document deletions' etc to 'no' in Edit/Find of Options before creating a "Package" for installing a runtime version of my database it always has the check boxes set to yes after...
When a user right clicks on some of my forms and filters either by selection or with specific criteria, I use the apply filter event to run some code that puts the current contents of "me.filter" in a text box. The user then can see the cumulative filters that he/she has chosen.
My...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.