Recent content by fgaiga

This issue is now an known error and should be part of a patch in October 2007. This is a thread in a Microsoft discussion group...

Thanks a lot Bob; at least I will sleep better this night !!

Hello, Since the last Windows XP update on the secretary PC, all combo lists are now empty even if the related tables are not at all. Here is her configuration: Windows XP SP 2 Access 2003 SP 3 Here is the description: 1) I've got a combo list based on the table Towns with zip-code, name...

OK. Thanks. I found that solution 2 min ago and it works !

Thanks Pat; I made something almost similar and it works properly; thanks for your major input. I've just one small complaint: at the execute SQL statement, I get an Access window message "You are about to append 1 row(s)...." Is it possible to get rid of that annoying message ??

If the user then answers Yes to the creation. How do I "cleanly" present information to him in the subform ? Do I have to use an "insert" statement ? or something else ??

So ok I won't dirty the record; but then how do I present new information in my subform and let the user decides if he keeps the info (by clicking the "Save" button") or if he discards it by just going back to the main form ??

Yes I am dirtying the record on purpose: Each time the user on the mainform is selecting something new that affects the subform, I do a requery based on the key fields in my subform. EIther I find the information and I display it in the subform either the information is non existing and I...

Exactly Alastair, I don't want to save the information if I don't click on the "Save" button and so that's why I want to Cancel the action. You said, it is too early, so in which event do I need to put the Cancel if not in the "BeforeUpdate" event ???

I have a main form + subform bound by a RecordSource/Requery everytime something changes in the mainform. In my subform I've got a save button to save/update the information in my subform. As I wanted to avoid the ACCESS default behavior that updates/add records each time you do some action...

What do you mean by DAO ?? You would do a SQL INSERT and then requery the subform that's what you mean ??

Hi, I've got a main form with some unbound fields and a subform. From the unbound fields in the mainform, I modify dynamically the RecordSource of my subform to display the information. ==> This works fine !! When there is no information to display in my subform, I need to create a new record...

This is the best approach I 've seen so far. This looks great !!

Thanks; I'll try this approach.

Hi, I am a bit stuck now and I want to get some ideas from you. The context first : I am writing a timesheet application and I've got a main form + a sub-form. In the mainform, I select the engineer, the contract and the week nbr. My mainform calculates the first and the last day of the...