Emma35's latest activity
-
EEmma35 replied to the thread 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...
-
EI changed the code in post #5. Download it again. You can click the record selector to add to the calculation or remove from it.
-
EEmma35 replied to the thread Solved Txt box on Form to add data.Thanks MajP i'll try omitting it and see what happens
-
E=DSum("[Weight]","[tbl_MainRecords]",) If you really have a comma at the end, that may be a problem when using a function. If no...
-
EFor my method, you need a unique field that represents the order. This would usually be the PK (autonumber field). If you don't have a...
-
EEmma35 replied to the thread 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...
-
EIt's because I'm using a non-English version of Access. Copy the event to your own database.
-
EEmma35 replied to the thread 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 ?
-
EIs it what you need. Start typing the weight in text box. Click reset to reset. Continue to add weight. Edit : ooops, a little late...
-
EEmma35 replied to the thread 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...
-
Enot fully tested but have a hidden textbox to store the 'latest' PK and then sum all weights where the PK is greater than the 'latest'...
-
EEmma35 replied to the thread Solved Txt box on Form to add data.Thanks MajP. I tried the below but still no luck =DSum("[Weight]","[tbl_MainRecords]",)
-
EWhen using a D functon all the arguments are strings. So you have to enclosed them. See how the name of the field, table, and the...
-
EEmma35 replied to the thread 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...
-
ELook at the link please and the syntax. :( Also what you are trying to get there is the sum of all the records in that table? Surely...
