Search results

Thanks. It works. Now I have new form, name as : frmMainForm. frmTest become subform in the frmMainForm. What will be new VBA code in the query above ? I've tried [Forms]![frmMainForm]![frmTest]![textboxA] , but it doesn't work. Error message: "Method 'Item' of object 'Forms' failed" Any...

Form Name: frmTest with textboxA Query Name: qryTest with field : fldA, fldB, fldC My current VBA coding as below :- A) For FORM Private Sub cmdA_Click() DoCmd.OpenQuery "qryTest" End Sub B) For Query fldA with criteria written as : textboxA I believe the root cause of the problem...

I am trying to get the value from subform by putting the message box. However there is an error prompted out. This mean the [Forms]![[formname]![textbox] doesn't work correctly. Any idea how to solve this syntax ?

Can anyone has a look to the attachment below for error and suggest some resolution code ?

How to resolve VBA filtering query issue ? I have these pieces of codes inside my form (name: frmBOMComparisonQuantity) I have inserted below code into the QUERY : Report_BOM_Comparison_StandardQty_WithoutUnitPrice and Report_BOM_Comparison_BalanceQty_WithoutUnitPrice . Both queries are the...

I have this piece code here http://www.access-programmers.co.uk/forums/showthread.php?t=212746 Can anyone suggest how to call rewrite the code for the highlight in red color so that the above function can call different worksheet. Currently the code only manage to call the FIRST worksheet

TQ. exactly what i want.

As title, i am using MS Access 2003 to write VBA to call a MS Excel and wish to load all worksheet name into combo box. Anyone has the idea how to write this piece of VBA code ?

I am designing tables for a BOM (Base of Manufacturing) system. Example below illustrate the sample data I have How to create this table base on above info in order to have recurring call for the same table for report generation . Anyone can suggest ?

Attachment below show the total price comprised of few parameters. I already create a function to store the formula as shown in the attachment. The function name is CreateTotalPrice. My questions are following a) What object events I need to use to call the above function ? b) Any changes to...

How to create unbound subform? Anyone?

Any suggestion?

Look at the attachment

Anyone know how to create dynamic tab control ?

My questions did not well put in previous post. Additional, the wrong attachment is uploaded. Thus, I've deleted and re-post. I never notice that you have replied something, so sorry. What is your comment ?

Total price comprised of parameter like (SubForm total CT * Quantity * PerHourCost ) + etc cost ... I already have that formula, question is how to insert the formula to the following :- 1) After the main form is loaded ? 2) When use press the record selector at main screen, how the total price...

In the attachment below, how to disable the "create new record" navigation selector only and to make auto sequence number for the field under the subform ?

Thanks .............

Thanks for the suggestion above, it is one way. Any chance to show the grand total at the form footer inside the subform at the execution time in a main form ?

There is one grand total text box in a subform under the form footer. How to display the text box at the subform and after this subform is embedded into a main form at the execution time?