Search results

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

Thanks for the reply... I think the first one is not so good.. but the second one gives me something to think of... the real problem is everytime I enter the employee ID (In my form).. it will automatically get the current salary (From salary table).. what I need to do now is to have that salary...

Hi, I've created a salary/payroll database.. Everything is working fine except when I updated the salary of the employee.. and try to generate previous reports, what I'm getting is based on the current salary... I dont know how to correct this.. ex. Month of April 2012 = salary is 2,500...

Thank you for the reply... Yes the first code will work if my focus is still on the mainform before the user close the form... but in the instance when the focus is on my subform.. the data in the mainform are automatically save and vice versa...

Yes I agree... I read some blogs and most of the suggestions is to have a DELETE QUERY... anyhow.... Thank you so much.... I really appreciate it..

Thanks for the Reply.. I tried the code but Im afraid this is not what I'm looking for.. My form have a subform, and my Tab Orders are to enter data in the first 3 Fields in my form then it will go to subform to enter another data.... what's happening is everytime I enter data on last fields in...