Search results

Yep, that's exactly my problem and yours is a good suggestion but.... ...the reason I can't edit the source tables is that the entire company (4000+ strong) uses them. And they are live tables, updated often daily...so I couldn't use a static version of it either. Any other ideas?

I have a problem manipulating data in a subform. I couldn't think of a better way to describe it than to put it in graphics: http://angelfire.com/pw/access/nformproblem.doc Would appreciate any help....Thanks.

There will never be 'no data' at all. Some fields will have no data, but on the form there are maybe 50 fields -- my report only shows the fields that are populated.

I have a report that interacts with a form. The report only shows data fields only IF they are populated on the form. There is a function in the report code, that checks if the form data isn't null and accordingly sets it to visible. I also have a position variable that works like a running...

I have a field on my form where I have to be able to accept data like "P " (P Space), however access chops off the trailing space? any way around this?

I'm trying to rename my controls with CAPS, I'm keeping the name the same, but Access converts it back to lower case as soon as I'm done naming (eg. I'm calling it LABEL, they change it back to Label)

I have a form that, after clicking a button, appends line items to a table (I run an append query which extracts data from the form). My problem is: I want to create a protection against adding a line item which was previously added. I know how to use the RecordSet to search the existing...

On my main form, I have an option group (ACDFrame), with two choices: 1 and 2 (default value) I have a button on the main form that opens Form 2. If 1, I want to show all the records in the next form I open. If 2, I want to show ONLY the records with NULL data in the field in question. Here...