On Fri, 2011-12-16 at 15:55 +0000, Jeremy Browne wrote:
> I’ve had two big, time-consuming problems – one I think I’ve solved,
> and the other I haven’t.
>
>
>
> At first my Base tables wouldn’t add a new record to most of my Access
> tables. After lots of trial and error I realised that the presence of
> a hyperlink field and/or a memo field in the Access table was causing
> the trouble. Once those field types were changed to text in Access,
> all was well. (It’s a shame to have to do that, though ...) I couldn’t
> find anything about this on the internet, even after I guessed what
> was doing it, so I thought it might be worth mentioning ...
>
>
>
> But now I have added a form, and there is another problem. Base will
> only add a new record if all the fields on the form are filled in –
> apparently it won’t allow null fields. This seems to apply however
> many fields from the table are included on the form, and irrespective
> of field types: one empty field is enough. I’m used to Access and this
> seems crazy to me – can anyone help?
>
>
> Many thanks
>
> JB
It sounds to me like all the fields of the underlying table for the
form have the "Entry required" property set to Yes.
--Dan
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
