Search results for query: *

Hi all, I have a table Actions as follow Action ID Action 1 cutting 2 sowing 3 ripping .. .. At some time , on clicking the button that opens this lookup table I found some of the values of Action equal to Action ID Action ID Action 1...

I am accessing a client .xlsm file from my machine and it works fine. The client complains that he received a Run time error 1004 : Initialization of the data source failed. So on trying on a different machine(connected to client's network) , I was able to reproduce this error. I just don't...

Hi all, I am trying to trap the database error "View cannot be updated because modification affects multiple base tables" in the Form OnError event to display a user-friendly message instead of the above. The above can happen in the scenario of inserting/updating several fields of different...

Hi all, Can someone help explain to me how when I have 12 rows in table A and 10 in B and I do an inner join , I would get more rows than in both A and B ? Same with left and right joins... This is just a simplified example. Let me share one of my issues with you I have 2 views ; which was...

Hi all, I want to handle the event when I right click and choose "Paste" to pop up a message to the user that he cannot paste; disabling the pasting functionality. I understand that the Button parameter refers to right or left button , but I need further help on which event to best use (mouse...

I have some texboxes that I want them to appear in datasheet view with a specific order. How can I control the order given that I tried tab index and tab order but did not achieve the desired result?

Hi all, I have a form consisting of textboxes and I open it in datasheet view. I want to be able to ctrl+v something if I am selecting only one control(one textbox). But if several texboxes are selected , or the whole record ...then I want to pop up a user-friendly message and disable...