Search results

Hi, My Access FE is at remote center and BE is on SQL Server. For all local pcs the db working fine. But I have installed my FE on a remote db I mean in other city and need to get connected my Access FE from remote with DSN less connection code. Nothing has been changed in code but on...

Thanks Gentlemen, I added PK to the table and it worked. Thanks for your support.. Regards,

Hi, I have below code line (from full code set) that producing Runtime error - "Operations Must Use An Updatable Query CurrentDb.Execute "UPDATE tblLoginSessions SET LogoutEvent = Now()" & _ " WHERE UserName=GetUserName() AND LogoutEvent Is Null AND...

Sorry for my late reply. Where the above code you want me to place? At the beginning? Means after Option Explicit

Hi, I managed it following way and it worked well. Dim RunSQL As String DoCmd.RunSQL "DELETE * FROM T_EmpOTFooter where Verified = 0 And OTID = Forms!F_EmpOTHeader!OTID" Debug.Print RunSQL Thanks,

Yes, it is Bit and Allow null = Yes, Default Value or Binding set to (-1) as default on server I just want to explain here..that CheckRightOT is on current subform and there are multiple records in subform that relates to main form record (one-to-many). So the click event will trigger the above...

Below is the result from immedate vba window DELETE * FROM T_EmpOTFooter WHERE OTID = 2 And CheckRightOT=0; OTID is 2nd record which is correct but CheckRightOT=0 means it is not satisfying second condition.

Thanks Arnel, But still same error....Can not find input tble or query '128'

Thanks theDBguy, This way it removed error 13 : strSQL = "DELETE * FROM T_EmpOTFooter WHERE OTID = Forms!F_EmpOTHeader!OTID And CheckRightOT.value = 0 " CurrentDb.Execute dbFailOnError Me!SF_EmpOTFooter.Form.Requery but produced new run-time error 3078 - table not found. My bound...

I am going to delete those subform records whose checkmark value is none I mean unchecked and OTID (int) is equal to mainform which is F_EmpOTHeader. CheckRightOT is a checkmark (Bit type field) and available in each records in Subform. Private Sub OMApproval_Click() Dim Msg As String, Style...

I have below code to read serial number of pc to whom I am delivering my FE Function GetSerialNumber(strDrive As String) As Long Dim SerialNum As Long Dim Res As Long Dim Temp1 As String Dim Temp2 As String Temp1 = String$(255, Chr$(0)) Temp2 = String$(255, Chr$(0))...

You are correct Galaxiom, I tried that way and it worked. Hopefully it will go ahead smoothly. Thanks for your help.

:LOL: really don't understand behavior of SQL server.....When I open actual SQL server tbl and check marked directly Or unchecked record..it accepted. The same thing I was trying to do it thru Access form it was NOT accepting. Strange behavior. Then I tried entering new record thru Access...

There is no code or query for the sub-form. It is bound with table T_EmpOTFooter. It recordset type is Dynaset. Do you think Dirty=False should be set on sub-form event?

Hi, I am facing trouble of Write Conflict on my bound sub-form. (Main form is unbound) I have added one additional field on Server tbl called 'Verified" (Data type Bit) and on the sub-form placed a check mark. Before adding this checkmark, it was running smoothly. I could add rec, del and...

Thanks The_Doc_Man, Isaac and MajP, Excellently explained by you. So I have decided to go with individual FE. Thanks a lot.

Hi, I dont know if this question was asked before or not but I need to know if a centralized Access FE copy can be used by multi-users or delivering separate copies to various terminal is the right way. The only thinking behind this we could save time in delivering and setting up FE at each pc...

Gasman, Thanks for your support. I found where was the problem. I will try fixing it. I have value for Me.EmpHOD to bring from tbl. Thats what I am trying. My question is why is accepting single condition and runing smoothly and why not double condition. Because I had saved other records...

Gasman, It was only idea that user enter the data in main form and subform (one to many) and after saving the record need manager's electronic approval. Just he enter his password and the control gets it relevant data from T_Dept and then record will save upon clicking Update btn on form. But...

If I adds dbOpenDynaset it producing "Wrong Number of Arguments or Invalid property Assignment"