Search results

  1. smtazulislam

    Form Position

    Could anyone tell me, why my access icon doesn't show that app is opened. See attached file named "123.png" 2. If I minimize the app then show nearly in window start button. It's happened from two days. See Attached file named "Capture.png" 3. any report don't open if it was not call LOAD_ForM...
  2. smtazulislam

    How to Hide

    How I do "Title Bar" and File > "Option" is hide.
  3. smtazulislam

    Solved User Permission Control

    Any help will be appreciated. Hello, I have a database where I want to create user permission. I have User Control 3 tables tblUsers, tblUserRoles, tblUserActivity. I have 36 forms, And 47 report. Here Before we used 2 database (separately). 1) Employee Management 2) Payroll. Now we add one...
  4. smtazulislam

    Solved Input Password box in the Form.

    Any help will appreciate. In a FORM, I want to input box for insert USER password which password he enter to access database. If this password is correct then he can allow to edit this form. Can possible ? I dont like to Fixed Password in the VBA.
  5. smtazulislam

    Help a query...

    Thanks for any help. In the attached dB, I want to show ............. Table Employee is "Status = Active" Table Transfer is "Status = Transfer" Table Vacation is "Status = Back Vacation" How to work it : First checking Employee Table with Status is "Active" Then Transfer Table with tStatus...
  6. smtazulislam

    Create FrontEnd and BackEnd for Multi Users

    Hello everyone ! I want to use my database on three desktop computers with the same network. But I don't have server. For that need suggestions to set up file based on Multi Users. My 3 users using the ms Access 2016 ver. First I split my database, now it has a twist file. The twist file...
  7. smtazulislam

    Tick Mark Filter Based on Sub(form)

    Any help will appreciate... My subform TEXT search work perfectly. Now I wanting my subform to filter by the STATUSID Where I have "1) Active 2) Final Exit". But I don't have idea what code I put there. Note : 1) subform display all when opened. 2) If First Click Ticked then Active AND Second...
  8. smtazulislam

    Solved Create Manual Reference Number

    Hello, I have a table like: Data - DataType VSID : PK VSNumbers: Numbers Name : Short Text Date : Date/Time Ref : Short Text I want to create a Ref Number which Format is Like : Manual Insert "VS" / " [Name] field First 3 Digits " /...
  9. smtazulislam

    Highlight and Message for duplicate Record

    Hello Experts Ramadhan Kareem to ALL. I have attached a dB which I what to highlighted and message me when I entry any duplicate "ID". e.g. tblSC tblSC SCID Year Month CreateD ID 2 2021 01 13/04/2021 1 7 2021 01 13/04/2021 2 10 2021 01 13/04/2021 3 11 2021 01 13/04/2021...
  10. smtazulislam

    Solved Null field not return

    Hello, any help much appreciate.. SELECT tblEmployeeSalaries.SalaryID, tblEmployeeSalaries.EmployeeID, tblEmployee.EmployeeName, tblEmployee.DeptID, tblEmployee.CountryID, tblEmployeeSalaries.DateFrom, tblEmployeeSalaries.Basic, tblEmployeeSalaries.Food, tblEmployeeSalaries.Others...
  11. smtazulislam

    Project Data Model Design

    Good Day ! I want to create project cost and Balance Model design for Cost and Balance Control Database. want to someone help basic thing and how to design this database tables and relationship for easily to calculate my below of field. How we work progressing : each project give Bill of...
  12. smtazulislam

    Print Problems...

    Hello everyone, good day ! I want to printout from a sub(form) as same row data, see attached picture. But its print out all entries with selected EmployeeID. I try to code like : Private Sub cmdPrint_Click() On Error GoTo cmdPrint_Click_Err If IsNull(Me.EmployeeID) Then MsgBox "Please...
  13. smtazulislam

    Office.FileDialog & FileSystemObject Not defined

    Hello, Any help will appreciate.... Private Sub cmdBrowser_Click() 'Dim fDialog As Office.FileDialog Dim fDialog As Object Dim item As Variant Dim Ist As Variant Dim FSO As New FileSystemObject 'Set up File dialog box 'Set fDialog = Application.FileDialog(msoFileDialogFilePicker)...
  14. smtazulislam

    Query no record display

    Hello everyone, I try to create a successfully database for payroll. Before I have 2 threads for payroll resolving issue, and one thread is pending yet . Alhamdullillah, I solved with out side help. Now I have another problem. I have 3 tables with each table have a "Total" filed. See in the...
  15. smtazulislam

    Solved DateDiff function not work in the SQL

    Hello all, this is my subform sql and its work perfectly. SELECT AbDaySN([Forms]![frmPayrollHistory]![txtEmployeeID],[AbsetdayID]) AS SN, tblAbsentDates.AbsetdayID, tblAbsentDates.EmployeeID, tblAbsentDates.PayHdrID, tblAbsentDates.AbsentdayType, LtblAbsentdayTypes.Deduct...
  16. smtazulislam

    Solved Filter in the subform based on a date

    Any help will appreciate I have a subform Like : ID ClinID JoinDate LeftDate 01 25 01/02/2020 03/03/2020 02 26 02/05/2020 15/09/2021 03 27 15/01/2021 01/03/2021 And I create a Main form that is data RecordSource to tblclient table. I want to create two combo box (Year) and (Month) for...
  17. smtazulislam

    RecordSET under the YEAR and Month.

    Any help and advice will be appreciated. Before my payroll system work another processing. I try to modify/update payroll system. And finding out in the google to solving this issue, But not success. Attached, first form is the main Form. In this form if i selected year from the combo box...
  18. smtazulislam

    Solved Conditional formatting record Edit

    I have use conditional formatting for criteria that, if cboStatus= Transfer then Visible false. Its all working well, You can see attached image. Now I want to add EDIT Button to edit record data. I put cmdEdit button code: Private Sub cmdEdit_Click() Me.cboStatus.Locked = True End Sub...
  19. smtazulislam

    Large Report Setting

    Hello, I have Student database which try to create One Report file print with 5 pages deferent data, . Report Name : "All Student" I want student Name - No 1 page Room - no 2 page Student ID - no 3 page Level - no 4 page Date of Birth - no 5 page. Page size: A4 Insert Header print all of the...
  20. smtazulislam

    Solved Calculations on Previous Record

    Hello, I want a query to calculation previous total value into current record values. My Record Details: Record #1 Date: 01/02/2021 Cost - 105 TotalCost - 105 Record #2 Date: 01/02/2021 Cost - 15 TotalCost - 120 Record #3 Date: 02/02/2021 Cost - 115 TotalCost - 235 Thank you. Any help will...
Top Bottom