Search results

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...

ObjName ObjType frmEmployee Form frmEmployee_GeneralPage tab frmEmployee_EmployeeIdentityPage tab frmEmployee_BankInsPage tab frmEmployee_HealthInsurancePage tab frmEmployee_NotesPage tab frmEmployee_txtEmployeeName textbox frmEmployee_txtEmployeeNameAr textbox frmEmployee_DOB...

Thank you for sharing this helpful approach. Setting .Locked=TRUE is indeed a great way to prevent users from editing while keeping the field visible. using .Locked=TRUE and .Visible=FALSE can completely hide and protect the field. I had uesd it in function that provide posts #12. Select Case...

Thank you very much for your time and assistance on this thread. It's reassuring to know that the functionality with textboxes, buttons, and comboboxes is working perfectly. Now, I'll proceed to test it with sub-forms and list-boxes to ensure comprehensive functionality. appeciate.

Thank you very much for your help. I appreciate your assistance and the time you dedicated to this thread. Regarding the issue with the form, if it's enabled but does not allow access to Add, Edit, or Delete functions, and users encounter 'error 94' when trying to access these buttons, the best...

I appreciate your understanding regarding the delay in my response. The issues your encourage, I encountered while applying and running the solution, it's possible that there were mistakes due to changes in table field names, form textboxes names. Could you please reviews and provide me with...