Replies

But which of the 20+ users would fire it off?

That’s cool Mark as long as one of the 20+ users remembers to run that form.

Nothing worse if no-one remembers.

HTH
Pat

Hi Mark,

When you create the record you should probably include an extra yes/no field that tells you if you have sent the email yet. Obviously you would set the flag after sending the email. You would also need to define an ever incrementing number that starts at zero.

The problem is that all 20+ forms would time out at roughly the same time (preuming that that they all started their timeout at approximately the same time, if they didn’t then the following logic does not apply since there will be probably enough time between timeouts to do their test of the flag anyway)), and if they all started at approx the same time the trick is to make each one of them further wait for a specific number of minutes before testing the flag.
The number of minutes that a form would have to wait would be determined by what value was in the ever incrementing field.

So the scenario is:

a) create the field and set the yes/no field to false and the ever incrementing number to zero.

as each form times out, it reads the yes/no flag and if true it just ignores any further action. If the yes/no if false it adds one to the ever incrementing number and times out for that amount of time, before testing the flag again.

HTH

Pat

It depends what you want to do. Do you only want the event to happen only once no matter how many front ends are open, or do you want only selected fe’s to kick it off?
From the sounds of it you may only want one to kick it off, in which case you would best make one of the fe’s a “Master” or “Supervisor” (as you call it).
More info please,
Pat

Try a search for GetUser in the lounge’s threads

Thanks. From memory I have also had problems with update queries.

Thanks Charlotte.

That’s exactly what happened, I previewed the edit.

Pat

Charlotte,
Would you tell me why you need the Distinctrow set?
I have had similar problems in the past with joined tabled delete queries.
Pat

Jennifer,

Just a couple of things I would do differently are:

a) change the names your combo boxes to something more meaningful. eg Combo8 to ComboCourse and Combo12 to ComboModule. The reason is when you are in the code you don’t have to try and figure out what combo8 and combo12 really are.

I would have changed the SQL in combo12 to filter on the CourseNum, not setup Combo12’s source in the code of Combo8. The reason is if you have to change the SQL in Combo12 you would also have to change the SQL that is setup in Combo8.

These are just my opinions.
Pat

What is wrong exactly?
Are you selecting the modules based upon the course selected? ( I know I’m asking the obvious).
If you are still having problems either post me your database or I will send you an example of one.
Pat

As Charlotte explained, having chosen a value from the first combo box you need to put code in the AfterUpdate event of the first combo box that requeries the second combo box.

eg.

AfterUpdate event of the Course combo box holds the following statement

ComboModules.Requery

HTH
Pat

Sorry about the attachment. I seem to have lost it when I edited the post. Howveer, here it is.

I forgot to mention about setting to True the Autotab property of the response field in the sub form, this allows only a single character to be typed into this field without having to press ‘Enter’ or ‘Tab’.

Pat

Hi Judy,
I am including your database (modified). As you will see I have made the following changes:

a) The response field in the tblResults is now one character (I did this to speed up data entry of the response). You will notice that when you enter an ‘A’ (without the quotes) that the cursor will end up on the next record at it’s response field, so there is no need to use the ‘Enter’ or ‘Tab’ keys (only when you wish to ignore that particular question).

I made the Form add the 63 records (or as many as there are in the tblTopics table when you add a new record in the After Insert event on the main form named entryForm). The requery at the end of the event is to display all the records that are applicable to the main form’s record.

c) The subform now displays all 63 responses and their associated questions.

d) The autoexec macro now has an extra function that deletes all tblResult records where the response field is null.

Hope all this helps,
Pat

Try a search for GetUser and you will find quite a few responses to this.
HTH
Pat

I agree with Wendells idea to populate the results table with all 63 records.

You could also make a single keystroke to enter data in the response field by setting the AutoTab property of the response field, of course you would have to set the response field length to one. This would then mean just one keystroke per response field therefore saving heaps of time.

This does not require much code at all to do all this.

If you like I will post a copy of your database amended to do the above, however I cannot send it till tomorrow night as it’s on my PC at home.

Hope this helps.
Pat