Search results

How should I test for a non-empty value then? I assumed that putting if not equal to "" it would test for the two double quotes instead of an empty string.

One of my acces reports needs to point the recipient to what fields in it are non-empty(changed). Most fields in the report will be empty, but some might have a default value. How can I do this, preferably with some VBA. I tried looping over the controls in the form and setting...

solved me.requery and the dataEntry property seem to do the trick.

No, I dont want to view any existing records at all. So I already have set the data entry property. In form view mode the data entry MENU item does exactly what i want (altough I can't find any help-info on it). When the user is done entering a record, it needs to be send as a report to some...

Isn't that the property data entry, not the method in the menu? The menu item i wish to use only appears with the form in 'form view', so I'm not sure if this is the same thing as setting the property.

Is there any way I can run the 'records->data entry' menu item from my code, or is there an equivalent method?

Hi Forum, Maybe some of you can tell me what is going on here and how to correct it: I have a form that gets its data from a query that selects status=10. In the 'send' button code the status is set to 20 so that the record should not appear in the form anymore and the form should show a new...