Search results

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

Hi All, When I have a record that I copy and paste into a new record with one column having a unique constraint , I display message "Cannot insert duplicate code" then if not all values in the record are inserted , I get a #deleted in all columns Refreshing , I find that the id is incremented...

Hi all, When I copy an entire record and paste it in a new record , I first get a duplicate issue with one of the columns(unique key constraint) and when I attempt to change the column value so as not to be duplicate ...I get a #deleted for the whole record. This does not happen when I copy...

Hi all, If I want to delete multiple records (select more than a record and right-click delete) how can I achieve this given the following with one record: Private Sub Form_Delete(Cancel As Integer) DoCmd.RunSQL "Delete * from Trial where TrialID =(Text40)" Me.Refresh End Sub PS:- I am...

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

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

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

Hi all, I want to handle the event when a user clicks Ctrl+C for a complete record in a datasheet then goes to a new record and presses Ctrl+V. I have added the following Private Sub Text40_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case 22 MsgBox "Please copy and paste the desired...