Search results

I'm having this same problem - my mailmerge automation function works pefectly when my database is an MDB but after converting it to an MDE file it seems want to do the connection as ODBC rather than DDE. Is there any way I can force the data to be passed via DDE programmatically? My code is as...

Thanks for your help rak, but this doesn't make any difference. The subform display is still one record behind and only updates when I move to a different record or close the form.

I wonder if anyone could offer some advice on a problem with a form & subform? I have a main form, based on table PublicationOrders: POrderID (pk) EventID(fk) And a subform, EventDisplay, based on table Events: EventID (pk) EventName The main form and subform are linked on the field EventID...

I've created a totals query to count the number of places that have been booked on each course. In the same query, I would also like to display how many spaces are left on each course. However, the expression: Places Left: Sum([Capacity]-[Booked Places]) gives me the error message "Can't...

That solved I problem I'd been working on, too. Thanks!

Sorted it! Through trial and error, I worked out that Sub Form_Current () cboParent.Requery cboChild.Requery End Sub does the trick. Just thought I'd post it in case anyone else is having this difficulty.

Thanks, but that's not it. I've taken out the second End Sub and it still causes a compile error. I'm a novice and I'm absolutely stumped with this so any other help would be hugely appreciated. Thanks.

On a sub-form I have two cascading combo boxes; cboParent which allows the user to select a year and cboChild which then allows the user to select a course dependent on the year selected in cboParent. I created these using Mile-o-Phile's method in the FAQ here. However, when I scroll back...