Solved Query And Form Design

[smtazulislam]

Hey access all experts,
I have a database but before I have to entry Payroll Or Salary Transfer in an excel sheet, now I like to update data in access database.
So, I needs your help that, these table how can create easily query and form for easy to entry data and search,

NOTE: if any expert want to modify allowed.
Many Thanks

tblAbsentDates
tblAllowanceData
tblContract
tblDeductionProcedure
tblPayroll
tblStopSalary
tblBankTransfer
===================================
in this tblTransactionWorkers little criteria like :
TransferDate- If same EmpleeID will transfer another company then status text should change automatic Transfer And LeaveDate field - change last date of transfer
Please see here tblTransactionWorkers

 

[arnelgp]

open tblTransactionWorkers and add new record (same EmployeeID to transfer).
see the table in design view, and look at the After Insert Data Macro.

 

[smtazulislam]

open tblTransactionWorkers and add new record (same EmployeeID to transfer).
see the table in design view, and look at the After Insert Data Macro.

Thank you for reply, I appreciate you have done my before thread.
I want automatic insert transferdate field as same date in LeaveDate field, if same EmployeeID
Exp:
ID -EmplyeeID- TransferDate- Company-Branch-BranchType- LeaveDate- Status
1 - 3-----------01/06/2020 - A comp. - HO----Main------- 10/06/2020- Transfer. (Here LeaveDate and Status insert Automatic, bcz Same EmployeeID
2 - 3-----------10/06/2020 - B comp. -HO----Main ------- -Current

I try this code. but it is insert same field in the row, not I want to previous row insert .... HOW ?

Private Sub TransferDate_AfterUpdate()
    On Error GoTo ErrorHandler
    Dim Chg As String
    Chg = Me.TransferDate
   
    If Not IsNull(Chg) Then
        Me.LeaveDate = Chg
    End If
   
Exit_Procedure:
    Exit Sub
       
ErrorHandler:
    MsgBox Err.Number, Err.Description
    Resume Exit_Procedure
    Resume
End Sub

I thing you understand me what I mean or I want.

 

[arnelgp]

View the After Insert data macro of your table while in design view (of your table).
There is a portion that Setvalue to [TransferDate] -1.
Remove the -1.

You also remove the transferdate_afterupdate since we are already doing it through data macro.

 

[smtazulislam]

View the After Insert data macro of your table while in design view (of your table).
There is a portion that Setvalue to [TransferDate] -1.
Remove the -1.

You also remove the transferdate_afterupdate since we are already doing it through data macro.

I remove -1, but not insert Automatic LeaveDate.

 

[arnelgp]

i forget to make the After Update macro on the table.

 

[smtazulislam]

i forget to make the After Update macro on the table.

Thank you so much, it's worked. really ! its nice job you done,

 

[smtazulislam]

arnelgp can I get help for another table on this thread. I appreciate... Thank you.

 

[arnelgp]

which thread?

 

[smtazulislam]

which thread?

Thanks for quick replies. this thread,
for below list tables need to advice for design form and Query, I again explain you that, this table create in excel file. but I like to access database, and it was almost complete... Now I need also add salary information activate in my database.
tblAbsentDates
tblAllowanceData
tblContract
tblDeductionProcedure
tblPayroll
tblStopSalary
tblBankTransfer

Thank you so much,

 

[arnelgp]

i am afraid i cannot if you want the Whole program/package.
it will take lot of time and code.
show the Excel file and someone, perhaps will convert it to Access.

 

[Rene vK]

Thanks for quick replies. this thread,
for below list tables need to advice for design form and Query, I again explain you that, this table create in excel file. but I like to access database, and it was almost complete... Now I need also add salary information activate in my database.
tblAbsentDates
tblAllowanceData
tblContract
tblDeductionProcedure
tblPayroll
tblStopSalary
tblBankTransfer

Thank you so much,

That is a lot to ask.

 

[smtazulislam]

i am afraid i cannot if you want the Whole program/package.
it will take lot of time and code.
show the Excel file and someone, perhaps will convert it to Access.

thanks for reply. Sorry for late reply.
I dont want to code for Form and Form field design, Just need to give advice or method how to work these table, Bcoz, these table are linked PK & FK.
Also advice me how many Form or Sub-form should I created.

thanks you so much.

 

[smtazulislam]

That is a lot to ask.

Hi Rene VK,
I am sorry, I dont know how much time to this work, bcoz, I am totally new for access, before my all of the work in the excel file. Alhumdullillah, I know better an excel. And now I study access everyday 4-6 hours from few months. AWF every post I watching. InShaaAllah, shortly I will be know well.

 

[Rene vK]

Hi Rene VK,
I am sorry, I dont know how much time to this work, bcoz, I am totally new for access, before my all of the work in the excel file. Alhumdullillah, I know better an excel. And now I study access everyday 4-6 hours from few months. AWF every post I watching. InShaaAllah, shortly I will be know well.

I can only say that study will help you on your way. A good way to start developing your db is to make a demo on paper, create tables and imagine how a user would like to use your application. You will make mistakes, things will not work and then you will know exactly what to ask . Good luck!

 

[smtazulislam]

I can only say that study will help you on your way. A good way to start developing your db is to make a demo on paper, create tables and imagine how a user would like to use your application. You will make mistakes, things will not work and then you will know exactly what to ask . Good luck!

Thanks for your good advice.....

 

[smtazulislam]

Hello,
I updated my db, I would like to check this 3 forms.
I appreciate someone help. Thank you so much.

 

[smtazulislam]

Hello arnelgp
your attention please

 

[mike60smart]

Hi

You need to stop and go back to basic table design.

In most of your tables you are using Lookup Fields which should NOT be used.

On your Data Input Form you would use a Combobox to obtain these values.

 

[smtazulislam]

Hi

You need to stop and go back to basic table design.

In most of your tables you are using Lookup Fields which should NOT be used.

On your Data Input Form you would use a Combobox to obtain these values.

Hello, Thanks for your reply,
All of LOOKUP table is hide, And in this db is available... Please check