Search results

As I mentioned I need to verify the LoginID nothing else at the moment because this form has to work for reset users details who forgot their password in order to verify their password (recreate) and other security details i need to filter their steps [loginID] which is txtLoginID on the form...

EmpID is a text field with number and words not a number field only and i can't change it as per my DB requirement. is their any solution to this problem because i have huge number of reports waiting this combination of information to call upon EmpID I really need to fix it.

This is to check the txtloginID entered is correct or not as per the record of tblUsers field [LoginID] I don't know if its make any sense in the code :confused: but i am pretty new to the coding so, please ignore in wrong methods and guide/provide the correct one. Remember i am checking...

This is not allowing me because EmpID in tblEmployees is a string I have modified the following as per your guidance, can you tell me where is the problem. SELECT tblEmployees.EmpID FROM (tblIqama INNER JOIN (tblGosi INNER JOIN (tblLifeInsurance INNER JOIN ((tblMedical INNER JOIN...

here is the full code Option Compare Database Option Explicit Private Sub BtnSubmitLoginID_Click() On Error GoTo errhandlers: 'Check to see if data is entered into the txtLoginID text box. If IsNull(Me.txtLoginID) Or txtLoginID = "" Then MsgBox "You must enter a User Name !"...

I am sorry its not working also

Sorry I forgot to mention UserID is number and not text in tblUsers. I am sorry but its still same error, i change the following do i need to change also something? Can you please mention where i have to input the ;0)>

Please need help with below code it returned "Data type mismatch error" and "Data type mismatch criteria expression error" Many thanks in advance for your help. Option Compare Database Option Explicit Private Sub BtnSubmitLoginID_Click() On Error GoTo errhandlers: 'Check to see if data is...

I am sorry if i make no sense here, I am little confused here what forms have to do with table and query? And its tblEmployees & tblPersonalDetails and tblEmploymentContracts i dont know which table you are referring as form and subform i am sorry but i am totally muddled. I have total 9...

Hi eveyone, I am facing problem with following SQL for my query in access DB. EmpID is the main key to filter the records from multiple table some are connected with tblEmployees and some are connected with tblEmploymentContracts but tblEmployeee (PK) is connected with tblEmploymentContracts...

Thank you thank you agian and i was just making something very silly i forgot to include the column of Reportlocation in cboReportName. Thanks again my friend. now i will do the reset button coding. I will come back in same post with my code error.

I have attached the DB, Thanks for your help.

Hi Everyone, I have following field on my form & sub form. FIELDS & OBJECTS Sub form Name = frmObjectFORMS_subform Main form =frmUsersFORM_Permissions Save Changes button = BtnSaveChanges Combo Box = cboUsername OBJECTIVE tblObjectFORMS is a list of forms that i have in Database and i am...

I am sorry but i am struct here, please give me final solution i just want to complete it to have an example for export reports. here the part i am missing in the code is how to tell export report based on cboReportName saved as actual report name in tblReports, [ReportLocation] field which is...

I am sorry, again i think i am doing some stupid things but nothing is happening if i put the following may be i am wrong some where? :confused: Private Sub btnExportToPDF_Click() On Error GoTo errhandlers: Dim sReportName As String Dim sReportPath As String If...

i have added the [RID] to cboReportName record source query but i unable to achieve it let me try again and not possible then i will upload the strip version of data base, also i want you to know that I already have [ReportCatagory] and [ReportType] in it with criteria of...

Here i came with another query, I am trying to export the report based on combo selection of cboEmpID cboCatagory cboReportName After all this are selected on frmExtIndividualRpts than only this command button should work and export the report based on the same name of report saved in...

Yah That make sense a great resource of knowledge, thnks Minty...

Please if you don't want to help than no problem, each of this SQL is totally different from other. As you can see in my previous post, in control query it giving lot of names & type which i don't know how to filter it.

Tables SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=6) AND ((Left([Name],4))<>'MSys')) ORDER BY MSysObjects.Name; Reports SELECT [MSysObjects].[Name] FROM MsysObjects WHERE (Left$([Name],1)<>"~") And ([MSysObjects].[Type])=-32764 ORDER BY...