Search results

Hi all It seems that I made some kind of a mistake when defining the Subject’s lookup properties. After redefining it and manually fixing the data which was entered using the form, everything is working fine. Thanks for anyone who tried to help.

The database is in an isolated system which is disconnected from the Internet. I'll make a simplified version of it and upload ipwr your suggestion. Thanks

Let me add one more thing that might be useful. I think that the issue is related, in some way, to the fact that the Row Source Type of the Subject field is a Table/Query. I made a little experiment and changed the Row Source Type of the Subject field to Value List. In that list I included some...

I hope that the following explanation will make my issue clear. The form is used to enter data to tblTrainess. One of the fields in the form (and thus in the tblTrainees) is Subject. In the Form (or in tblTrainees) there are NO fields name Objective1/2. All data entered via the Form is stored...

Yes, data entery from the form is OK. If I open tblTrainess the Subject field (and all other fields) has data in all records (I later present the Subject field in a report and it's presented perfectly. The problem is probably in the linking of the two tables.

Hi all, I would appreciate your help with the following issue (presented in somewhat simplified way): I’ve got two tables: tblTrainees and tblObjectives. I’m entering data to tblTrainees via frmTrainees. One of the fields in the form is Subject – its Row Source is tblObjectives and the Row...

I was able to come up with an adequate solution, based on the link that MajP posted and little experimenting. In my report, I used the 'Hide duplicate' option for the CallSign column to hide duplicate CallSign. Than I used the following statement in Conditional Formatting to hide all the other...

isladogs and MajP - thank you both for your comments. I'll try implementing your suggestions on Monday and will report if it helped.

Hi, I created a report in Access that looks something like this (please see the attached zip file). Most of the time, under the Event column, there is only one value per each CallSign. However, sometimes there is more than one. In my example, CallSign Cc (marked with blue rectangle) has three...