Recent content by djossh

I'm trying to make a database for Employee's Annual Leave Payment.. I need to Get/Extract the current Salary of an employee because I'm calculating his Leave Settlement based on the Current Salary (In case an employee got an Increment during his service) after extracting those data, I will...

Thank you so much... that was helpful...I really appreciate it..Thanks.

Hi Im a newbie to Access, I really need help on this one.. I have a MainTable with Subform The Subform is based on a Query. I want to save the data/Fields from subform to my TempTable.. MainTable Fields: EmployeeNo Name Position TempTable Fields: ID* Salary Allowance Subform Fields...

Thank you for your reply.. I'm really a newbie in access, I just want to save that field (Salary) to my table.. Sorry I didn't mention that my query is based on another Table which holds all the data pertaining to salary..Thanks again..

Hi, 1. I have a Main form (based on a table) with a Subform. 2. The Subform is based on a Query (Because I want to show the Last recent Record only... Im talking about the Salary) I want to save the data from the Subform (Salary Field) to my Table, I dont know if VBA will be the best...

THANK YOU!!! Got it working now... I really appreciate it..THANKS!!!!

Thanks for the reply.. but it's not working.. here's my complete code .. Im a newbie to VBA and just copied some of my code over internet. Dim db As Database Set db = CurrentDb() CurrentDb.Execute "DELETE * FROM TimesheetTbl WHERE Project IsNull" Set db = Nothing End Sub Im getting...

Hi I tried to delete a record (Project) in a table(TimesheetTbl) with Null or blank value.. I tried this code but I don't know why it's not working.. Here's the code.. CurrentDb.Execute "DELETE * FROM TimesheetTbl WHERE Project = IsNull(Project)"

Thank you so much.. I really appreciate it... Keep up the good work! Thanks again..

Hi, Newbie here, Hope someone can help me.... I have this multiple sets/groups of unbound textbox in form.. I want to save the values of the sets/groups of texbox in my table as new record based on per sets of textbox.. here's a sample.. (Sets/groups of Textbox in my form) textbox1...

That was really helpful, thanks.. I really appreciate it.

Hi, how to write VBA code to sum "textbox1" to "textbox20" based on Criteia in "textboxA" .. I know I can use "IF" function but it will be very long formula since I'm going to add 20 textbox.. I'm new to VBA.. thanks..

Thank you for your reply.. But I'm a newbie to VBA and don't really know how to write codes... here's what Im using right now.. I just want to shorten this code like what you are trying to say to me..(Can you edit this code for me?) Thanks.. Private Sub Add_Click() Dim db As DAO.Database Dim...

Hi, I have multiple textbox in my form Textbox1 to Texbox10...I need to transfer this data into Table1 with Fieldname Data1 to Data10.. Thanks.

Hi I have this code from my Excel userform.. I want to use the same to my Access form... I really don't know how to write codes, I dont know why it is not working in Access, Please help.. Here is my code that I used in excel userform. Thanks Sub filter () Dim n As Integer Dim k Dim dic As...