Recent content by namu

Hi Guys, I need help/advice to create a query that will show the difference between the number on the first row and the next number below it and so on. Currently i have a query that calculates some data that is a result of a formula. I want to get the Diff Value just like the table below...

That works really well. Thanks a lot.

Hello, I will appreciate if someone can help me with this. I want to insert multiple records in a table but i always get runtime error 3061: Too few parameters. Expected 1. I tried to google and it seems this is a very common issue when inserting multiple line. But still i cannot find the...

Hello, Please, can anyone help me with this? I am trying to add a Table on the header of a word document but i can't figure out the proper way to do it. The code below creates a table but it is created in the body of the word document not on the header. Please help. I am using the below code...

Hi, Thank you for pointing me in the right direction. I made some changes on my code. 1. If there's only 1 record, SplitPercent = 1 or 100%. It works fine. 2. If there's a additional record, assign the SplitPercent to whatever value based on Title08Split1 & Title08Split2. Note: There could be...

Hello Guys, I need some help on my vba code. What I am trying to do is add a new record to a subform. If there is only one record then the value is 100%. But if you add another record, then it should split the value depending on whatever percentage you assigned them. The value will be taken on...

Great! thanks a lot for the help. I was able to populate the ID by editing some of the code you provided. Dim myDB As Database Set myDB = CurrentDb Dim rs As Recordset Dim J As Integer Set rs = myDB.OpenRecordset("tempTable") For J = 1 To 24 rs.AddNew rs!ID = J rs.Update Next J...

I appreciate your recommendation though there is no real problem with normalization. I just need to know if it's possible to create a tempTable with x number of rows as pre-populated data. I really don't know where to start. I start googling but i don't get much information or maybe my search...

Thank you for the Diagram. We are planning to use Access for Estimation purposes(Budget, Cost, Manpower, Schedule, etc. ). We already have an existing excel file for the estimation but we try to convert it into access database. And yes, there can be a lot of different projects. The only...

Hi, Thank you for your interest on my question. The x number of records will represent the "number of weeks (which is a result of calculation)" and the tempTable is for the graph that i need to create after. I would like to generate a tempTable because the number of weeks will depend on the...

Hello Guys, I would like to ask some help on how to dynamically create a tempTable with "x" number of rows. Let's say x = 24. The tempTable should populate ID's from 1 to 24. That means 24 rows. Is it possible? Thank you, namu

Hello, I have 12 subforms and i used the code below as a pointer to refer to the subform "tblTitle01 subform'". It works great but it is not dynamic. Can somebody please help me how to make this dynamic so when i click the field in tblTitle02 it will point back to the same field after the...

Thank you so much Mr. Arnel. You saved me again! Cheers!

Hello Arnel, It works just fine on the first record. However, when i try to add data on the next record of MaterialRequest form, it gives me a run time error 3021. No current record. Do you think this can be applied on the next record as well? Thank you for your help. Kind regards, namu

Hello Arnel, i tested the sample db that you sent, however the LineNumber is not incrementing. It remain as number 1 for all the records added. I slightly modified the code you added on the before insert event to something like : Me.LineNumber = Nz(DMax("LineNumber"...