Search results

  1. O

    Form Total - creating numbers

    I am working on a Report that has several groupings with fields containing data that I want to total in the report footer. At present I am using “=Sum([section_amount])” to attempt to get my numbers, although I am not getting a error message, the numbers that are returning from the calculation...
  2. O

    Error with Recordset Open using SQL statment

    I am trying to use the code below to open a Recordset yet I get an error “ No value given for one or more of the parameters” rstScopeQuery.Open "SELECT [line_data_id],[section_id], [chk_status] " & _ "FROM section_detail WHERE (((section_id) = [Forms]![frmJob_section]![section_id]));", _...
  3. O

    missing operator error

    I have this bit of code - rstScopeQuery.Open "SELECT line_data_id FORM section_detail", _ cnnLocal, , adLockOptimistic and it bring on a "syntax error (missing operator) in query expression..." at run time. I am sure that the answers is right in there but I can't see it. Any ideas ?
  4. O

    Stoping code - from going on

    I have used a msgbox to check in a field if filled in or not, and if it is not then I set the focus back to that field for the user to enter. Yet my code does not stop, once the msgbox it Oked the code jumps to the field and just keeps on going. How can I stop and wait , then verify that the...
  5. O

    keeping form open

    I am trying to keep open several different forms at the same time. Yet in using acDialog I am no able to access more then the last form opened. I need to be able to access more then one form and keep the code form moving on. Below is the code used to open the two forms. With the second form...
Back
Top Bottom