Search results

I am sorry, but i am not a programmer just started to learn from access because i like to complete my database not extremely interested unless i get direct classes for programming languages. Anyways, as best of my understanding i try to cover all areas that you have pointed me out, also i went...

My full code is below, but still getting syntex error. Option Compare Database Option Explicit Private Sub btnSearch_Click() Dim SQL As String SQL = "SELECT tblEmployees.EmpID, tblEmployees.FullName, tblEmployees.Surname, tblEmployees.Gender, tblEmployees.Nationality...

its giving syntex error because code is not complete, can you provide complete code...please.

I have to include like condition in all fields, which i am missing the code, my above code is incomplete and giving me the errors.

Hi I want your help in below code, which include 2 tables in list box query. I have named frmSearch on this form their is a list box placed with rowsource SELECT tblEmployees.EmpID, tblEmployees.FullName, tblEmployees.Surname, tblEmployees.Gender, tblEmployees.Nationality...

Hi I am struct with following code in below query involve 2 tables including numeric and text fields. Option Compare Database Option Explicit Private Sub btnSearch_Click() Dim SQL As String SQL = "SELECT tblEmployees.EmpID, tblEmployees.FullName, tblEmployees.Surname, tblEmployees.Gender...

Thanks for your reply that is ok. now i am trying to call employee name based on combo selection on form Fullname field is text in tblEmployees my code on form current event is Me.Name = Nz(DLookup("Fullname", "tblEmployees", "EmpID='" & Me.cboEmpID & "'"), "") it is also showing same...

Hi I have form where i am trying to call the image based on combo box selection its employee image. 1. Field Name EmpID is number field. 2. Field name Picture is text field which hold the file path of employee on computer. my code is below but its showing data type mismatch error "3464"...

I have attached snap of my table where all fields are not necessary to call in query however, based on further requirements i will do modify the code to include the another fields from table but so far i need the fields mentioned in my first post. What i need to achieve is a latest entry of the...

Hi everyone, I am trying to call most recent value of data row of table entry based on category and employee ID selection. Table Fields [EmpID] number format [Category] Combo Box Value list [PayDate] Date format [Amount] number format Their is multiple entries for each...

So each one i have to put separate iif because as you mention only 2 fields are visible i need cut off of each based on Year value if 1 or 2 or 3.5 or 4.5 or 5 anything. Sorry but not clear to understanding technically your advise.

Hi everyone, I struct with some logical calculations in coding, i have 5 fields on my report and their is 5 year selection so each iif condition should show result based on the year value. for example if txtYears equal to 1 than result should visible only [1 filed] and remaining 4 fields...

Thnks for your help its working now. Actually i want to cut off the periods in Years on the report. for example: I have one employee Mr.ABC and his join date [HireDate] is 05/02/2012 i want to calculate his Service award by each year end starting from his joining year. Can i able to do it...

Hi everyone, I want to get result in query for cut off (Year end) date for my employees hire date the year they join i want that year's last date. I have date field called [HireDate] i want the result in another column which is 1stYearEndDate: to show the 31/12/## of [HireDate] field's date...

Ok guys @Ranman256 I glad to have your views and always welcome. ok so your understanding is little bit wrong here, Vacation doesn't mean they are absent let me explain it to you more clearly. Every employee has a different Employment contract and different eligibility for no's of air...

Hi As promised i am back again from the beginning of my project, attached is tables and relationships that i have made to start this project, please i required your kind help at my database start up version for verifying tables design and its relationship. All is done already by me now need...

My apologies, I will go back and normalize/redesign database and make sure it's satisfy the requirement of project and maintain the correct relationships without duplicates. let me start from scratch, once done with tables will post in a new thread, Thanks for everyone here, for your...

Ok now i have changed the EmpID to Number but ContractID is still text and i have attached strip version for DB. Have a look its still not working and giving the same error.

I am attaching here the strip version of DB, please see as the error is still their. Dlookup for other tables are not available as i am uploading the strip version so we need to examine only the txtLoginID.

I have to change many fields type and in short almost complete project, because [ContractID] is also a text field and both tblEmployees and tblEmploymentContracts has many many tables under their relationships so, its kind of taking a glass of water from leg and not from your hands. one more...