Search results

this code I use. But it open all page. actually, I create a Menu with SubCommand in TabControl Tried it : ''Private Sub btnCustomers_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) '' Me.TabCtl_Menu.Visible = True '' Me.P2.SetFocus '' Me.P3.Visible = False ''...

Here again have new problem... Tab Control name is TabCtl_Menu here have 9 pages And all page is not visible . I would like to do that if I hit CmdDashboard then open Page1 [P1]& Page3 [P3]

Thank you very much to all.

This is my UNION QUERY. SELECT qryVacationProgressList.EmployeeID, qryVacationProgressList.EmployeeName, qryVacationProgressList.CompanyName, qryVacationProgressList.MaxOfLeaveDate, qryVacationProgressList.BranchEn, qryVacationProgressList.Status FROM qryVacationProgressList; UNION SELECT...

Excuse for late reply. I find the another solution LIKE tblEmployee.GrossSalary is previous Salary And tblEmployeeSalaries.sGrossSalary is Increase/Decrease salary. Its twice table And tblAllowance combine a query. Its worked now. Thank you very much all

any update

can check why not print.. cause details here : Post 1 Edit : There is mistake that remove PrevousSalary filed.

this is work perfectly. This Dlookup not work. error of the PrevES field. I given salaryID = salaryID -1 then work. But same result with my previousSalary field. SWITCH function is work. Nothing error. But result display 1 all the field. IN my View : I thing my query is worked. But here is...

Hello Sir, Look post #4 if I would like to print first row then need open INCREASEING report Second row then need to open Decrease report

My query was like that. SELECT tblEmployeeSalaries.SalaryID, tblEmployeeSalaries.EmployeeID, qryEmployeeExtended.EmployeeName, qryEmployeeExtended.DeptName, qryEmployeeExtended.Designation, tblEmployeeSalaries.DateFrom, tblEmployeeSalaries.DateTo, tblEmployeeSalaries.ContractTypeID...

You suggest me do like that DoCmd.Save If IsNull(Me.txtDateFrom) Then MsgBox "Please select a valid record", vbOKOnly, "Date Required" Me.txtDateFrom.SetFocus End If If Me.txtPreviousSalary = 1 Then DoCmd.OpenReport "rptIncrasingSalary", acViewPreview, "", "[SalaryID] = " &...

Hello, can anyone talk me where I have mistake ? one report opened, second report not opening Private Sub cmdPrint_Click() DoCmd.Save If IsNull(Me.txtDateFrom) Then MsgBox "Please select a valid record", vbOKOnly, "Data Required" End If If Me.txtPreviousSalary > 1 Then...

There is also facing problems that search form loading take time 1 to 2 minutes, sometimes more then and when enter any keys also result display taking long time where my total database 6.17 mb and record 6236. How can resolve this issue... ?

Thank you very much sir, its nice work. Can possible to do that ? if searcher textbox enter completed word then 'those word is became Green 'And In-completed word is Red as you done. end if

Okay Sir, I agreed to convert them Short text to Long Text.

Hello Sir, I forget to asking that there is no string a colour in Search Subform when I enter the specific Word or Alphabet.

Thank you very much Sir. Appreciate to help. again thanks a lots.

get error 94 Edit # When select specific chapter then enter any key on the SEARCH textbox. then get long time loading.. last opening time 3 minutes.

Yes, Perfect Sir. little correction plz, Code is not work where I selected combo "txtSearchSpecificChapter" code available but not debug/requery Private Sub txtSearchSpecificChapter_AfterUpdate() Me.sfrmSearcher.Form.Requery End Sub And When I enter the complete a word in the textbox...

this is my sample db Edit: Here I like to work this searcher like: Firstly If me!txtSearchSpecificChapter = null then 'find whole book if me!txtSearchSpecificChapter = not null then 'find selected specific chapter only end if Secondly if I type any keys then founded character is count how...