Search results

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 Bob,, Im getting error 3265 (Item not found in this collection).. can you fixed it? thank you again..

Where should I put this code? sorry for asking too much.. I really appreciate all the reply and all the helps here.. Thank you all guys...Thanks Spikepl

Thanks.. I'll try your code.. Thank you.. I really Appreciate it.

Thanks.. but the way i see it,.. I'll still be using my current code. co'z there's no alternative to what im currently using... Thanks again..

Thanks for the reply.. I really don't know how to write codes... i even don't know how that "variant" is working... Thanks again..

Hi thanks for the reply, I'm a newbie in access and zero knowledge in writing codes, yes you are right that code creates multiple records.. I am actually making a timesheets for payroll..."Field1" is the monthdays... so it will create records based on whatever number of days in months in...

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

Well explained...... I appreciate all the help... Thank a lot.

Thanks.. I got it working..

I tried the combobox.. still getting same run time error..

I have 600 employees.. I think if I use a combo box it will take me sometimes to scroll to the bottom, though you have a point in setting property on it... i'll try that.. thanks..

The field in the form Im referring to is The "Employee Number" it so happened that employee number is my ID number also.. The form has a subform where I can edit/delete some information.. I intentionally type ID that are not in the table because the user might do the same.. any better...

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

PERFECT!!!!! THANK YOU!!! I actually tried that at first but without carriage returns...anyway.. Thank you so much.. I really appreciate your help.. GOD Bless.....

nope... still struggling.. what I meant on my post "I just figured it out now" is the error I encountered with the null values in "LeaveTypeID".. I tried this but stilll not working.. please help.. Thanks =IIf([LeaveTypeID]=1 Or...

Thanks.. that was working perfectly.. But I notice one thing.. if the "LeaveTypeID" is null... it also gives me the the results.. any other way to include the null value?? Sorry fot asking too much.. I just figured it out now.. Thank you so much...

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