Recent content by smtazulislam

Ah, I understand now. Thank you very much for providing this information; I truly appreciate it. I have gained some valuable insights. So, to address this issue, I utilize the code. Me.Width = Me.Width - 100 This code is success in another database, but I encountered difficulties within my...

Okay, I will try to seperate the attendance Table and Form.

Hi @MajP, Thank you for your response and the detailed explanation. I must admit, your dynamic design approach has truly inspired me. That's why I decided to replicate it using MS Access, especially after relying on spreadsheets for almost eight years. This transition will undoubtedly streamline...

I test it, It is not matched with my requirement idea. I need a way to efficiently record attendance for over 1500 employees and 35+ suppliers in our system, I means, our employee work within 35 suppliers. I have using 25 to the end of the month completed the recored by menually. If I have 37...

any ways i can uploading spreadsheet in ms access permenantly by using a button. In a Worksheet I have 12 months recored. Give me some Idea. Second Idea, I can allocate 31 columns for days. when I will selecting a year and month, I need a method to adjust the column count accordingly. For...

Hi June, Thank you very much for your response. I'm actually quite inspired by how both an appointment One and Two operated, especially, in terms of their appointment scheduling functionality. I havve attempted to apply and in-corporate some ideas from both databases. In this database, I have...

Hi, I have an Excel sheet for recording attendance, and I would like to replicate format in MS Access. However, I'm not sure how to proceed with creating it. Essentially, I want to be able to select the year and month, and then have the days of the week and corresponding dates automatically...

Its not work with me. Edit : update the ScreenShot & Db

Here is it..

I've managed to create some space in the top row, but it doesn't look quite right. It's not as I expected.

The code is functioning well, but I'm still facing an issue with creating adequate spacing. How can I generate a gap or free space without resorting to methods like underscore or underline? I need to do something here cmbo.AddItem rs!TableName & ";" & "-----" & rs!FieldName Perfect worked...

It appears that the layout consists of multiple column headers and some space between the table records. see the attached.

Hi, There have any ways to display multiple table Name (Table1, Table2, Table3) within there Field (Field1, Field2, Field3) in the combo box list, But Table name is readonly/Header, its can't select to insert. Table1 Field1 Table2 Field2 Table3 Field3 Private Sub...

Thank you for your support and advice. It's now functioning properly within the Subform, TabControl, and TabPage components.

Thank you very much for providing additional details. Your explanation is quite clear. I already applied the suggested code to approximately 12 forms successfully. However, now I encountered a form where unsure how to implement the code inside the "case" statement, specifically when dealing...