Search results

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

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

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)"

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

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

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

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

Hi. I have a form with subforms to enter various data.. Whenever I closed my form using the "x" on the upper right side or the form.. Whatever data/information that are left in the form will be saved to my table. (this happens when a user enter some data then suddenly realized not to continue...

Hi,I found this Calendar in one of the forum.. But I want to remove the Pop up form everytime I click on the dates... What I want is to Enter data into the dates and save the data to my table.. I think this can be useful for my Payroll database..Thank you in advance.

Hi all, I have this code from one of the forum and it is working fine, but everytime I run this code it takes a while to complete my data. Are there any code to speed up this or other code that will give me same results but faster speed. Thanks here's my current code. Private Sub...

Hi, I need a code to open a form from combo box selection...but I want to have only two forms open at the same time, the main form (Where combobox is located) and form from combo box selection.. ex. Open Mainform (Select Form1 from combo box in Mainform).. so now two forms are open.. Mainform...

Hi I need some help on error handling...I got an error of 3101.. and I know the reason for this error is that, I dont have record ID in my table.... are there any code to handle this?? I want the user to get prompt by a message box that the ID he/she is trying to enter is not yet in the...

Hi, How can I combine this two iIF formula into one.. IIf( [LeaveTypeID] =1 AND ([MEPNumber]>200,0,[BasicSalary]) IIf( [LeaveTypeID] =1 AND ([MEPNumber]<200,0,[BasicSalary]/30*21) The formula above will give me a result of "0" if the "LeavetypeID" is not equal to 1 or should I say any...

Hi I have a main form for data entry.. on lost focus a popup form (Modal) opens then I need to enter some data. after that is a button to close the popup form.. then... I want my main form to set a new record.. but it was adding the data that was retained when I opened my popup form.. so I tried...

Hi Im a newbie to access so please forgive me for my question.. Is there a way to change the color of mainform into a Light Black color upon opening of my popup form? (and return to its nomal color when I closed the popup form) I just think it looks nice to have this effects.. I read about...

Hi, I want my button to fire/Run the command below based on the number in my unbound textbox field (txtboxnumber) the scenario will be... to input the number in my txtbox ex. "5" ....then when I click on the button (ComButton) it will run the code below 5 times... Private Sub...

Hi, I need a code for my Forms.. I dont know if this is possible.. Im a newbie in access please help.. I have a form (PayrollForm) with multiple sets of fields...what I want to do is.. after entering all the data in the first set of record.. it shoul be save to my table (PayrollTable)... then...

Hi I have a mainform with 2 forms (form1 & Form2)I inserted using a drag & drop on design. after entering some data in my main form, it will go to my "form1".. and that is no problem at all... but after entering data into my "form1" I want the tab or the focus to be set in my "form2"... please...

How to write this in Expression builder? I want to add fields with "false (N)" value only. In my example below the total should be 12 only (adding 3+2+3+4=12).. Take Note that Y/N fields are constantly changing... Using IIF formula might be the answer but Im a newbie in access.. please help...