for..next

alpertunga65

Registered User.
Local time
Today, 23:16
Joined
Mar 15, 2013
Messages
21
Hi again me and the same problem "for..next loop"

After my first thread, I got some help but unfortunately I couldnot solve my problem. So I decided to add Db here.
If anyone opens my database;
there is a table "frequencylist"
and a form of this table with fields; firstfrequency, lastfrequency and FreInt.

What I want is; I will enter one frequency (i.e 88) to firstFrequency and one another frequency (i.e 108) to lastFrequency, then I will enter a value to FreInt (i.e 0.025).
the last step is; clicking on Command10 button. Then I want to produce frequencies from 88 to 108 with the increment 0.025. (like 88.025, 88.050, 88.100)
I want to record all frequencies to the field "Frequency" in the table FrequencyList.
BUT ı COULD NOT DO THAT. :confused:
Could you please help me
here is my attachement Db.

thanks in advance....
 

Attachments

I gave you the outline of a method on the other thread. Have you not tried it? I see no effort in this db.
 
You should be very careful trying to implement something like this with those kinds of parameters. Let's take your example of a range of 88 to 108 in increments of .025. This would add 800 rows to your table. Now, what if a user accidentally enters 1008 instead of 108? You just added 36,800 rows to your table. This could become a mess very quickly unless you build in some safeguards or are using a temporary table that can easily be deleted if there is a mistake.
 
I gave you the outline of a method on the other thread. Have you not tried it? I see no effort in this db.

Hi pbaldy
yes I have tried it. Not only your method but also I got sodbme other methods, but unfortunately I could not do it. I tried 4 different method. unfortunately I couldnot.
Actually sevral years ago I had a similar Db and I had done at that time. In the beginning I used my own code. It was failure again.
And this Db that I attached here is another copy. I never work on the original ons.

Thanks again for your help...
 
You should be very careful trying to implement something like this with those kinds of parameters. Let's take your example of a range of 88 to 108 in increments of .025. This would add 800 rows to your table. Now, what if a user accidentally enters 1008 instead of 108? You just added 36,800 rows to your table. This could become a mess very quickly unless you build in some safeguards or are using a temporary table that can easily be deleted if there is a mistake.

Hi, thanks for your advise. I know that. Somebody can make mistake. The attachment is not my original Db. Ofcourse I will limit the lowest and highest frequencies. 88 and 108 were just examples for here.

Thanks...
 
yes I have tried it. Not only your method but also I got sodbme other methods, but unfortunately I could not do it.

Why don't you post an example of the code that you tried, so we can see where you went wrong.
 

Users who are viewing this thread

Back
Top Bottom