Search results

The main intention of search combo in main form is to search old record and end user might have forgotten to enter some employees of a particular dept so later on he can add. So once he search the old record entry from main form he can add few more additional employees of that dept Sorry to say...

Bastanu, I have reduced records and other unnecessary objects from the attached db. I have added one record only of Administration staffs. You may make another new entry for calibration dept. My Concern is only why the subform combo is not generating the employee list as per the selection at...

I removed rowsource from property of subform combo CboOTEmp and placed this code in after event of combo CboSearchOT Me.SF_EmpOTFooter!CboOTEmp.RowSource = "SELECT DISTINCT T_JobOffer.CName, T_JobOffer.Cno, T_JobOffer.CDept " & _ " FROM T_JobOffer WHERE...

Basically CboOTEmp combo is placed on subform with following Rowsource code of this combo is: SELECT DISTINCT T_JobOffer.CName, T_JobOffer.Cno, T_JobOffer.CDept FROM T_JobOffer WHERE (((T_JobOffer.CDept)=[forms]![F_EmpOTHeader]![CboAddOT] Or...

Hi, I have mainform with a subform. Mainform is unbound but subform is bound with table. On mainform I have a combo CboAddOT wherein I select dept and when I enter in subform to enter the relevant record of that dept, all the employee I can see in subform combo “CboOTEmp” using following code...

Thanks again Minty, This time I kept all default bit value to 1 and I removed CHild and Masterfield link on form. I know that will show me all the records in subform irrelevant to main form record. And just for trial I removed link between Masterfield and Childfield which was earlier set on...

I just tried converting relevant tbls to local and edited record. It has no issue. It means when tble are linked from server, write conflict problem occurs. For Bit and Int value I already set default value as 0. How about varchar or NvarChar field? Do I need to set default value for these text...

Minty, I have both tbls and set all bit fields default value to 0. I tried even removing direct tbl as datasource of child tbl and instead I placed query based on the child tbl. But still same. Then I deleted child table and created fresh one and when I started entering value direct to sql...

Sorry, It is again appearing...let me scan whole tables with such kind of fields where I can set 0 as default value.....

Thanks Isladog, Excellent observation and solution.... I did it and it worked.... Thanks a ton.... Regards,

yes..... I have unbound textbox (ProjNum) on main form and same textbox (ProjNum) on subform. But on subform it is bound with field.

Hi, 1. Linked tbls from Sql Server in my Access FE (tbles: T_ProjectBaseContracts and T_ProjAssigneeDetails) 2. Main form with subform - where main form is unbound and subform is linked with tbl and it bound with tbl fields directly. 3. Main form is in relationship is one-to-many. Master and...

Thanks Galaxiom, You are correct. My below line working properly. stConnect = "ODBC;DRIVER=SQL Server;SERVER=" & MyNewIP & ";DATABASE=Mydbname;UID=MyUserIDHere;PWD=MyPwdHere" What I was making mistake is I was connecting from same network that is why it was not working. Therefore, I connected...

Thanks Arnel, I will try this and let you know.

Thanks Bastanu, But considring string'" & MyNewIP & "' is not working instead it is displaying Server login dialog where in Server combo show '198.52.45.120' mean the IP address is quoted with apostrophe sign.

Thanks Arnel, In your code where you want me to place USERID and PWD to connect the server tbls in MS Access FE that is at remote.

Yes I treated my IP address saved in tbl T_IP is text type field. And tried the above way I explained but working properly.

Hi, I got this DSNless code lines somewhere from net to link SQL Server tables into my MS Access FE Db remotely. Since we dont have static /web host server, our IT keep changes IP address every now and then. Then to solve this issue I decided to place a text box on login form where remote user...

Excellent point Arnel, I changed just now to not null and by default value to ZERO

Thanks Cheekybuddah, Yes, it is working. Only thing is I need Not Is Null with second criteria.