append from a continous form

[EeOr]

I have a continous form that opens up and displays the top 5 random numbers,
I would like to create a log that records the username, date and time, and 5
numbers. When i do this just now it is only appending one record and only
the top number. I dont mind if it appends 5 records with one number each or
1 record with 5 numbers however I really need this information to be logged.
Any Ideas?

Thanks in advance for any help you can give.

Jon

 

[Van T. Dinh]

How do you populate the Form with 5 rows and a random number in each row?

If you can "create" these 5 numbers to display on the Form, it should be
possible to save these 5 numbers (and other data) as 5 Records in the
destination Table. However, when to save these Records depends on your
requirements ...

Perhaps, you should provide details of your set-up and the processes related
to the Form and how / wwhen you want to save these "Records" ...

 

[EeOr]

Hi Van, thanks for your response,

The continous form gets its data from this select query which uses a
randomizer function I found on this forum:

SELECT TOP 5 member_no AS [Winning numbers]
FROM [tblmembers]
WHERE (((randomizer())=0))
ORDER BY Rnd(IsNull([tblmembers].member_no)*0+1);

I tried running an append query when this form opens however it then gives a
different set of numbers which is no good, I also tried an append query
using the form as the data source however it only gave me the first of the 5
records which was also no good.

thanks again

Jon

 

[EeOr]

I decided to use a make table query to create a temp table and run the form
and the append query from that.

thanks for your help anyway.

Jon

Hi Van, thanks for your response,

The continous form gets its data from this select query which uses a
randomizer function I found on this forum:

SELECT TOP 5 member_no AS [Winning numbers]
FROM [tblmembers]
WHERE (((randomizer())=0))
ORDER BY Rnd(IsNull([tblmembers].member_no)*0+1);

I tried running an append query when this form opens however it then gives
a different set of numbers which is no good, I also tried an append query
using the form as the data source however it only gave me the first of the
5 records which was also no good.

thanks again

Jon

How do you populate the Form with 5 rows and a random number in each row?

If you can "create" these 5 numbers to display on the Form, it should be
possible to save these 5 numbers (and other data) as 5 Records in the
destination Table. However, when to save these Records depends on your
requirements ...

Perhaps, you should provide details of your set-up and the processes
related to the Form and how / wwhen you want to save these "Records" ...