Search results

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

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

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

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

Hi, First, i have a main form (MaterialRequest) bound on "tblMaterialRequest" with a subform(MaterialRequestDetails) which is bound to "tblMaterialRequestDetals" and "tblItemCodes" . What i want to do is i want to have an autonumbering on the LineNumber field. The code i used on the Before...

Hello, I have a table with 2 fields set as primary key. One is the ProjectID and the second is CostAccountID, when both are combined they will become a unique key. I want to replace the default warning message of access to prevent the duplicate entry. To do this, i used dcount function but i...

Hi All, I have a continuous Form [Letter Log - All] with "LetterNo" field as the primary key. What i want to do is click the "LetterNo" and a filtered pop up form with subform should appear based on what has been clicked. But i don't have luck doing that. The name of the main form is...