Search results for query: *

I didn't know that "DataEntry = True" mean't add mode. That's kinda goofy. They should have called that feature "AddNewRecord" or something. Thanks! I've spent hours on this!

I want to open a form (for a facility) in edit, but open the subform ready to add a new record. I wanted to turn off the 'Record Navigation' on the subform, so that the user cannot look at other records for that facility, without going through another access point. Any ideas? Thanks.

My formfield in Word did not care for vbNewLine (which is probably a Chr(13). Anyway, I found CHR(11) which is a vertical tab. This seems to work-- so far. Thanks for your input.

I'm trying to force a new line in a .Formfields result (in a Word document) using the following: --------------------------------------------- .FormFields("fldSub1a").Result = rst!CAS_Number & Chr(10) --------------------------------------------- I've tried Chr(13) and Chr(10) &...

I got it to work with ADO the SELECT statement. Still wondering why the =SUM(Units]) hangs the form. Thanks for your help.

You second solution =sum([Units]) works beautifully, until I go to close the form. Then it hangs, and I have to ‘End Task’ on Access. BTW, if I use sum([txtUnits]) I get an #error. But if I use the underlying field name [units] it works (until I go to close the form.) The first solution...

I'm trying to calculate a total from values on a subform. Given the following: MainForm: BaseFee=xx (immaterial) Subform: Record1 Quantity=2 Record2 Quantity=5 Record3 Quantity=4 When I click a "Calculate" button on the MainForm-- I want to cycle through the Subform...