Recent content by madctch

Anyone?

I have created a Form that lists the Name of a company which is listed in a General Information table. I then made a subform for my financial information table that is related. The problem occurs when I attempt to enter the information. The subform does bind to the general information form it...

I am having trouble with how I should relate these tables: Table One contains general information about a company and table two contains insurance enrollment information. Sometimes there are multiple entries of the same company in the insurance table, but only a single can exist in the general...

Disregard that last reply. I think it would be alot easier if I just made a table with a notes field and a combo with all the certification values. Thanks for all of your help!

Thanks for your help! I changed my table structure and am attempting to do a data entry form. Would I do a subform inside of another subform? The thing I cannot figure out is how to have the notes correspond to multiple fields on each certification. Right now I have one notes field per record.

Ok, that works. But when it comes to the report how should I go about only displaying the fields that are not empty, the main problem being formatting. I could use the visible property and change it on print, but that would leave many of blank spaces on the report.

Yes, I don't think it normalized either. What I am attempting to do is to be able to allow the user to enter notes for each check separately. I didn't know how to work the relationship so I just made a notes field for each checkbox.

What I have is a table with yes/no fields, with notes fields that correspond to each of the yes/no fields. These two fields are related to a Company name in another table. I am attempting to make a report to display the yes/no fields with their corresponding note boxes for each company, but I...

Perfect! Thanks.

I created a series of If statements in VBA that detects the current quarter. It is a text field with format 99/99/00 - 99/99/00 and I need to find a place to make sure it calculates every time the database is accessed. I am doing this in order to compare to another date field which is formatted...

Thanks! I just created an action query and that did the trick.

I need to sort based on the value of the unbound control. How can I do that?

[New] is a field in the table General Information. When I run the report I get runtime error telling me I cannot assign a value to the object.

I have data that needs to be changed based on the date that the report is accessed, but I cannot figure out how to change the data in the OnFormat event. Ex. If Now = #07/07/2007# Then [New]= -1 End If

That's it! Thanks for the help.