Search results

Hi all! An Access 2k nightmare that I'm living thro' right now. I have about 20 forms and lots and lots of VBA code in my project. All I did was put in some canned code from MS KnowBase to disable the mouse whell scrolling feature. Since then my entire application started to behave strangely...

Hi all again, I have some users who love to use their scroll button on their mouse. Half way thro' data entry on a form they do this and they actually move away from the record. This causes problems to me [variables lose values, etc., etc., :-(], is there a way to disable the scroll key...

Hi all! I'm sure this is a familiar story to you all. I've spent quite a bit of time building this front end using MS access and VBA. All my tables are in MSSQL7.0 and are linked into access. Every now and then access just decides to make the table "read only". I have to actually delete the...

Hi all, I have forms where users like to use the tab key instead of the mouse to move b/w fields. Problem: when you continue hitting the tab key even after you've crossed the last field on teh form, it just saves the record and gets the form ready for another record data entry. I NEED TO...

Hello all! I have several Access 2000 forms which are opened in either "edit or add new" mode. The user half-way thro' decides to quit without saving changes. What code should I put underneath the "QUIT" button to completely clear the form >>AND<<< even release an IDENTITY value that was...

Hi all! I have a query which has a function as its parameter. The function is in a module and is a public function. All it does is returns the value of a global variable to the query. Here is my query.... SELECT C.CONTACT_ID, CL.LOCATION_ID, L.SITE_ID FROM CONTACTS AS C, CONTACT_LOCATION AS...