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

Oracle has been installed on the client's PC. However, when I tried to install it on the machine causing error, it worked fine. So maybe we just have to ask the client to re-install Oracle drivers right?

I mean like I described I am having access to an .xlsm file and the datasource of this file is described in the connection string posted above which I can see from Connection Properties in the excel file. The file itself was uploaded by client on teamspace. Accessing it from my machine worked...

This is the connection string of the excel macro file (.xlsm) Provider=OraOLEDB.Oracle.1;Password=dmdbal_v1;Persist Security Info=True;User ID=sco_dmdbal_v1;Data Source=ORAOBODSP01.eame.syngenta.org:1525/OBODSP;Extended Properties=

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

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

Is there a way to add this in Access?

Hi Olaf, Would I include part1.normalstartweek in the select some columns part?

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

me.selwidth is zero when I select a whole record.

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

Thank you very much! Could you please check my threads titled 'Count of Selected Controls' and 'Event Handler for Mouse Right click and select'?

Can't find Column order property anywhere . I am using access 2010 .Someone has pointed out that I can drag columns but I seem to be able to do it in a form and not in a subform How can I do it in a subform?

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