Search results

Use the Tab Control. Depending on your table structure, you could link sub-forms onto multiple pages, or if you have a large table, group the controls on the different pages. Duane Barker

Why would you need to delete the sub-form and then add it to make changes? Sounds a little buggy to me.

I don't have an answer for the e-mail question, but I have a question of my own regarding your code. What purpose does the variable tdf serve? I have never used a tableDef object in my code, nor would I know how to use it. As for the second question regarding setting up a separate table with...

Write the SQL code as you normally would. Assign the SQL statement to a string variable, and use this variable when needed. eg: strSQL="SELECT * FROM Table WHERE [Field] = Criteria ;" If you want to use variables in criteria, use string concatenation. Dim strVariable as String Dim...

I will muddle through the code tonight. To set a breakpoint, click to the left of the line where you want it to stop. A red dot will appear beside the code. When you run the code, it will stop when it reaches the red dot. Duane Barker

Have you stepped through the code to see the values of your variables as your program functions? Put a breakpoint on your function call, and see if you can't solve the problem there. It seems to me that your function may not be returning a value to the text box. provide a sample of the...

Your Unbound text box just displays the calculation. It is not considered good design to save calculated values in the table. Duane Barker

When you are creating the new record on the second form, Access does not know what Unit Number to use. In a sub-form with links established, it uses the value from the main form. Here is what I would do. On the Command button, send the Unit Number on the form open call. Dim strOpenArgs as...

Is your combo box unbound? If you bind it to the link field, it should work. Duane Barker

See post for Gram123 Duane Barker

Place this code in the Before Update Event of the combo box. Set the Combobox Limit to List Property to Yes If Isnull(Me.CombControlName) = True Then 'Do nothing Exit Sub Else Dim rst as DAO.Recordset Dim db as DAO.Database Dim strSQL as String Set db=CurrentDB 'If code field is numeric...

the Me. references the Current Form. Instead of typing Forms![CurrentForm]![ControlName] you type Me.[ControlName] Duane Barker

If you want the Appraiser field to be unique, go to your table definitions, and set the Index property to Yes(No Duplicates) Duane Barker

I think I see your problem. I don't think you can use a Query in the call. *Not sure though cause I've never tried it.* I always prefer to use an SQL statement in my Open Recordset call. The SQL you wrote should be changed to : strSQL="SELECT WTN from WTNS WHERE BTN= """ & Me.btn & """ ;"...

The problem is with NULLS Use this expression. [Field D]=nz([Field A])-nz([Field B])-nz([Field C]) 'The nz() function changes any null or "empty" values to 0 Duane Barker [This message has been edited by BarkerD (edited 01-15-2001).]

It sounds like you need to normalize the structure of your application. If you have information that is duplicated in records in the same table, or in different tables, this is a good indication that it is a separate data entity. Duane Barker

Thanks, Pat. I will look it up Duane Barker

Use this format to requery subforms. Forms![Mainform]![Subform].Requery Duane Barker

You will need to use a transaction to accomplish this. This will keep your database in a consistent state. If an update fails between the BeginTrans and UpdateTrans, you can RollBack the updates. On Error GOTO UpdateError Dim wrkDefault as Workspace dim rst as DAO.recordset dim rst2 as...

Thanks Pat. I don't know why I didn't think about using the footer. I don't believe I have scope problems, I think that the detail section is being formatted more times than I realize. I will have, say 100 iterations expected, and my coutner will be 800 or so. This really causes a problem...