Recent content by NW27

Thanks apr pillai, I'm finally understanding :) This is how it looks and works :) But! Am I using the correct syntax ??? I'm still not sure on where to use . and ! and Me's and [] but... it does work Dim rst As dao.Recordset, Sample As Double Me.Refresh Me!Trade_Profit_Gross = 0 Set rst =...

Thank you everyone for responding. It is greatly appreciated. Neil.

Thanks Bob, Neil.

Hi, I'm just starting on VB and Access. What do people generally use in naming conventions ie 1. do they put tb in front of a table? tbFred 2. rpt in front of a report? rptMonthlyProfit 3. Primary key on a Table called Fred. Do they use ID or Fred_ID as the primary key column name? 4. Forms...

Hi, Thanks for responding. Trade is a Table on the main form and has Entry and Profit columns. Exit is a subform table with Price being a column within the table. There may be 1..3 rows in the exit table that match the corresponding trade table. I need to loop through each one separately and do...

Hi, I'm just starting out as a VB & Access programmer. I have plenty of programming experience just not in these languages so to speak. I have a form with a "Record Source" of "Trade". On this form there is also a Subform with a "Record Source" called "Exit" It is a one to many relationship...