Search results

I tried following and it is producing following errors. X = DCount("*", "T_ProjAssigneeDetails", "ProjNum = '" & Me!CboSearchProj.Column(0) & " ' " And AssigneeActive Is Null) = False '") Run-time error 424 - Object Required X = DCount("*", "T_ProjAssigneeDetails", "ProjNum = '" &...

2 records are checked and one record unchecked

I just played with your code particulary with quotes like below: X = DCount("*", "T_ProjAssigneeDetails", "ProjNum = '" & Me!CboSearchProj.Column(0) & "'") and half part of worked. But addtional criteria is still pending.

Tried that way in the beginning. Please see the pic. I placed cursor to know the x value...it is still zero.

This is rowsource of combo on main form: SELECT [T_ProjectBaseContracts].[ProjNum] FROM T_ProjectBaseContracts ORDER BY [ProjNum];

Attached shows the data in both table

Thanks Arnel, My tables are on SQL server and linked in Access FE.

ProjNum is Text data type. Your above line produces Run-time error 2471 - The expression your entered as query parameter has produced this error: 'PRJ' The string value is actually PRJ/CNRT/21/00001, PRJ/CNRT/21/00002 etc....

Thanks Arnel, I tried the both way you explained but still X is producing 0 value. Or do you suggest I should place my text box"TotAssignedStaff" on main form instead of subform to get X value.

Hi, I have mainform called F_Project with subform F_ProjAssigneeDetails - one-to-many relation The key field in main form is ProjNum which is relevant with subform as well. When we enter new project in main form, we adds number employee to that particular projects. I just want to count number...

Thanks for the hint.... DONE..

I tried calling following way the saved NewIP that saved in a table. Dim MyNewIP As String MyNewIP = DLookup("NewIP", "T_IP") stConnect = "ODBC;DRIVER=SQL Server;SERVER=MyNewIP;DATABASE=INATHR;UID=hr;PWD=hr@inat123" Set td = CurrentDb.CreateTableDef(stLocalTableName, dbAttachSavePWD...

Yes...I saved in text field in tbl

At our remote pc, one ERP is also running and in at login form of that ERP the user know the new IP address. Therefore, the remote user know whenever new IP changes. So I did the same in my login form user will type new IP and it will be saved in a table and I want my stConnect to read IP...

Hi, My following code line connects to SQL Server from Access db. stConnect = "ODBC;DRIVER=SQL Server;SERVER=182.128.1.7;DATABASE=INATHR;UID=hr;PWD=mypwd" For some security reason IP address changes every week and I have to update in this module. So what I did is, I placed additional text...

Thanks Minty for pointing out this issue. Yes, there was an issue of IP address. I placed the correct IP address and now it is connecting remotely to our head office sql server. Thanks to The Doc Man also. His details on this issue supported me a lot. Regards,

You are correct Sir,. I installed Database Engine Object Lib (32Bit) on remote pc and then the error changed to attached one. What step need to take to tackle this above attached error..

Sir, We have Full Speed WiFi at our branch office. But no info about component in Access. Moreover, another ERP is installed at the same pc which is connecting to our server in our head office. So I also want my FE to connect to server tables but the code lines I am not gone thru or even I don't...

2016 version of Access at remote work station. This is the first time my Access FE is installed at remote pc. For local (in same office) connection are made DSN less all the FE at each work station is working smoothly. But I think there should be some other code that will connected remotely to...