Search results

I think for columns in reports it's an all-or-nothing sort of deal, so I would be prepared for subreports. It would be alot to type, but I will offer this link as a reference. There is a sample I put on there which may provide some insight ... well, as to how I would approach the problem...

Good to go. You could have used a text control, but then you would have to set more properties to make it look like a simple message on the form in your pop-up simulation. Glad to see it working for you .. good luck in your project! -dK

If you aren't learning then you aren't growing ... there is always something new or better. :) I am glad you figured it out and posting your solution. Good luck! -dK

You could use the .Requery property for the subform to refresh. The question is, do the users keep the form open all day? Or do they update it, close the db, and reopen when they need to update it again? I think the problem might lie in the condition of the .Requery. If it is the former, there...

You're welcome. Glad I could offer a solution. Good luck on your projects! -dK

Hey lzfy ... I think your problem is you are trying to establish a primary key as the many side of a relationship. To my knowledge this can't be done - only a non-primary key can participate on the many side of a relationship. I would think that your design structure may contain a flaw or you...

Do you have records in the tables? If not, it is probably because the data types might not be same (if using autonumber pk's ensure your fk's are long). If so, you can only probably create it one way because records exist in one table and not the other (the way you want it). For instance ...

I think that was one of the issues, that there are no nulls in the dataset - a record is there or not. I couldn't use groups with a LEFT JOIN because if there was data in one group (say for state A) that group wouldn't show for a different state (B) where there were no people in that group...

You bet. Good luck. -dK

Other than turning on an 'add to list' in the combo box properties, you have to ensure that the country code is updated along with the added city. If I don't have a seperate interface or doing control level access rights, I usually refer to this link for adding to a list. I like their...

Okay. I see. DLookups are not the way to go, but I mentioned it to demonstrate how far off-based I was thinking. Grouping on the profession may not work because you want the professions the be displayed even if the dataset does not contain any. I don't know of a way to force that but perhaps...

Yes. What you have is a combo box that is set to the primary key (instead of a foreign key) of a table so this will throw an error because it is an autonumber on a new record. The last attachment I posted works because it is all set up nice and neat on a table-bound form where you are only...

Will the user's be adding cities to the country's off of this form? Or will they merely be selecting the country/city? -dK

I see what you are saying but having difficulty in understanding because I don't understand the structure. In addition, I am looking for the most efficient implementation that fits your needs. So when you run this report, is it for an individual 'thing'? That is, let's say it is for a...

Here is correct attachment. -dK

Here ya go. This is the quick fix - the form is bound to the table, but that is not how you have it specified in your initial cut. I am not entirely satisfied with this because we are duplicating a field. In the databases I have created - I have avoided this issue because of the way I set up the...

Yah .. it is doing something weird - it has been awhile since I actually have set one of these up in this particular fashion. I know the quick fix (bound the table to the form and add a field), but I am sure I am overlooking something to base the form on the initial query you had specified. I...

Opps .. I didn't finish the job - forgot to set the forms source correctly. -dK

I didn't put the country code in the University table because I did not see a need. You can reference the country code utilizing the relations through the city table. However, if this just has to happen then add the field back to the table and in the AfterUpdate event of the country combo box...

Ah. I hate it when that happens. Awesome it is working for you now and thanks for posting back. Good luck in your projects! -dK