Recent content by uday

Jack the Star!!!! Thanks a lot mate! Yes you were spot on. I had to export the forms individually to a new db minus the screwly module + class module and it works now. Its funny how access gets all confused just because you have these problematic classes/modules and even though you don't...

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

Thankx a ton Jack! I would have never found this on my own. Just curious, have you done this in your work, if yes, did you take the DLL approach or the other one? regards uday

Thanks Albert, It turned out to be the way access works with linked tables. Just for the benefit of all >>>note<<< when you link tables from access, make sure the original tables have keys defined correctly and indexes built on them. When you link a table into access and access prompts you to...

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

thankx Rich! a bit slack on my part, becuz its explained clearly in help online on how to achieve this. regards Uday

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

I found this method to work perfectly fine...it forces the user to comply to your rule >>>and<<< stays put in the control, till the data is right!! hope it helps rgds Uday ____________________________________ Private Sub CUSTOMER_Exit(Cancel As Integer) If IsNull(Len(Trim(Me!CUSTOMER))) Then...

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

Thankx Pat, actually thats where the problem was. The query was'nt working outside the DCOUNT.... I love this forum....its great rgds Uday

Thankx Jack, it turned out that I had not declared my function as "public". It works now! And thankx for the tip on passing a numeric parameter.... regards uday

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