Search results

Thanks everyone ! The Actions button opens the Actions table which is available in SQL Server so it is linked in access. The action ID is a number whereas the Action is text . There is no combobox here Do you mean that in another form where there is a column named action it will be a combobox...

CJ_London, Can you please explain?

Yes but there is nowhere in code where we update Action to be ActionID

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

It turned out that Oracle was not installed on the client's machine :)

What tells Access to delete the record ? Is there something in Access/SQL that tells to delete a record if a duplicate column is found for the column with unique constraint?

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

How can I resolve this issue since after I get a message box that I cannot insert duplicate trial code(the unique column) and I try to change it to something unique, the whole record is hash deleted.

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

If Trial ID is represented by Text40, how would multiple selections go over each of the values in Text40 until it is deleted ?

The view on which i am trying to update/delete records is : SELECT Trial.TrialID, Trial.TrialCode, Trial.ActualNrOfTotalEntries, Trial.ActualNrOfEntriesVarNr1, Trial.ActualNrOfEntriesVarNr2, Trial.ActualNrOfEntriesVarNr3, Trial.ActualNrOfEntriesVarNr4, Trial.AtualStartweek...

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

You are right. I just misread 3 as test against "the variable in the form keydown event " which is the Pasted variable. If Not isfield is equivalent to If isfield=false which means lost focus in the key down event but actually we want to display the message if it is in focus and not only that -...

pasting can be done in the datasheet by doing ctrl+v and/or right click context menu and choose paste. How can I disable this?

I trapped it using Case 3155 MsgBox "Can not update the record. it is related to base tables" Response = acDataErrContinue But how can I "undo " the pasted record ?

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

Or I can trap the error in the OnError event handler . Related to View is not updateable because the modification affects multiple base tables

I am not able to make it . I made the boolean isFocused variable equals True in all GotFocus of controls , and false in the Lost Focus events respectively Then I compared against Pasted in Keydown event which was Pasted = KeyCode = vbKeyV And Shift = acCtrlMask If (IsFocused <> Pasted)...

You mean when the variable is true, then the control is not focused ? But i want when one control is focused to actually paste data , also when several are selected but not when ALL the record is selected. There could be another way which is to allow paste normally and issue a data duplicacy...