Search results

  1. E

    Solved Txt box on Form to add data

    Hi KitaYama your suggestion works perfectly thank you. It was initially generating some kind of syntax error but i shut down the database and opened it again and all was fine. Thanks again for taking the time to help and also to everyone who made suggestions....i'm always amazed at the help and...
  2. E

    Solved Txt box on Form to add data

    Thanks MajP i'll try omitting it and see what happens
  3. E

    Solved Txt box on Form to add data

    Thanks KitaYama this version looks promising........i need to get a couple of boring meetings out of the way before i can give it a proper try. Cheers
  4. E

    Solved Txt box on Form to add data

    Thanks KitaYama....there's an error popping up on the AfterUpdate event about communicating with the OLE server ?
  5. E

    Solved Txt box on Form to add data

    CJ the boxes are just blank when i try adding new records Edit : Sorry CJ i had to unblock the file before your code worked. I was wondering if there's a way of doing it without the PK ?. The counter can keep on counting away as long as it restarts when reset to zero ?
  6. E

    Solved Txt box on Form to add data

    Thanks MajP. I tried the below but still no luck =DSum("[Weight]","[tbl_MainRecords]",)
  7. E

    Solved Txt box on Form to add data

    I don't need to sum all the records Gasman. The records are entered into the database using a scanner. The reason for this counter is that the operators need to record exactly how much raw material was used to fill a particular tank. This is only necessary for one tank and the rest of the time...
  8. E

    Solved Txt box on Form to add data

    GaP42 i definitely don't want to reset the records in the table to zero. I just need a counter which can be reset to zero without affecting the underlying table
  9. E

    Solved Txt box on Form to add data

    My VBA is not good Gasman. I tried the code below but it just turns red as soon as i type it DSum ( Weight, tbl_MainRecords)
  10. E

    Solved Txt box on Form to add data

    Ok i didn't know that gasman. How do i use the DSum() event ?......my VBA is atrocious. Thanks
  11. E

    Solved Txt box on Form to add data

    Hi....no i'm not initiating a new set of records i simply want to reset the counter. What code would i need to change to in the OnClick event ?
  12. E

    Solved Txt box on Form to add data

    Hi Everyone, I have a data entry form where one of the fields where info is entered is called Weight. I need to have a text box on the form which adds up the weights as they are entered into the table (it's just a visual aid for the User). However, i also need a command button beside the text...
  13. E

    Very Weird Problem

    Thanks again Pat...i'll use this method in future
  14. E

    Very Weird Problem

    Thank you. I actually tried that code but the error was still coming up. Actually i've put some of Pat's code in instead of what i had and the error doesn't happen anymore. I'm now getting a different error when i move on to the next form. I think this database might have had it :oops:
  15. E

    Very Weird Problem

    Thanks everybody for the help and suggestions as always. Em x
  16. E

    Very Weird Problem

    Yes i think my sloppy use of the OnOpen and OnClose events may have caused this. Still, i'll make a note of it and not repeat the same thing again
  17. E

    Very Weird Problem

    Thanks a lot Pat....it never occurred to me to simply hide the initial form. Sounds like a much cleaner way of achieving the same outcome with less risk of causing this kind of error in future.
  18. E

    Very Weird Problem

    I wasn't aware that parameter was for saving design changes....i thought it was data. Yes i'll remove it and replace the code and see if it works. Thank you
  19. E

    Very Weird Problem

    Thanks Minty....yes the OnClose event had code which was the reverse of the code above (it opened the form Frm_SearchMulti)
  20. E

    Very Weird Problem

    Ok so i managed to get the form in question to open. In the OnOpen event of this form, there was a snippet of code which simply closed the previous form to keep things neat. When i removed this code everything started working again ??. This is the code DoCmd.Close acForm, "Frm_SearchMulti"...
Top Bottom