Recent content by krester

Mr. B - thank you so much, I followed your directions and – its working. I added Or strChar = " " to the if in order to solve the problem plog talked about. Thank you plog as well for divert my attention to the problem Now - how can I keep the result in another field?

Is it possible to spread it to 3 different fields? Well, I see I have a problem…. :(

Actually, it's an address field. Here are some examples: Text 1. 12 windflower st. 2. Rose st. 24/2, flowers village 3. Tulip eve. 125 The expected output 1. 12 2. 24/2 3. 125 Thank you so much for helping me!

I have a text field that includes numbers. How can I extract the numbers to another field by using a query?

highandwild - it's working, so simple and elegant (I thought that I must use VBA). Thank u very much :) !

Hi highandwild, First, thank you for your help. I try it and it really work but I want that after that the user will choose a year and click a button, the records will be added according to the selected year. Thanks in advance.

Hi everyone, I have 2 tables: tblMembers and tblPayments tblMembers: member_id, f_name, l_name, active tblPayments: member_id, payment_code, month, year, sum … At the beginning of each year, I would like to add records for all active members for each month in tblPayments. Anyone got any ideas?

Hi David, * What I hope to get is – in each iteration, I want to get "member_id" from the next record. * You are right – "sum" have to be "count". * I want to select all records from tblMembe, so I have no condition.

I have a table: tblMembers (member_id, member_fn, member_ln etc.) I want to write a loop that goes to tblMembers and brings member_id. At the begging the member_id in the first recorde then in the second recorde … and so until the last record. This is what I wrote – but it's not working...

Dear David, Wow... it was quickly. Thanks a lot!

How can I call the same function from some forms?

Dear vbaInet and gemma-the-husky, Thank you so much! It's working!!! Have a nice day – my day is already nice thanks to you :) ... By the way, Dave – what do you recommend to writte instead of - Dim i, n, n_halvaa, c_rez, rez As Integer?

Hi, I added the code as you suggested "end_payment = rez" and it was accepted. Now, when I run the code I get a new error: "return without GoSub". I really don’t understand – what's wrong :confused:?

Dear vbaInet, I changed the code and now it's working. I don't know if it's the best way to write it. I'll be grateful if you'll have the time to write your opinion. But I have a problem: I want to return the value I have in "rez", but if I write return rez I get compile error: Expected: end of...

OK – I have bills. Each bill can be paid in some payments. I what that each time I mark that one of the payments was paid – the program will check all the payments whether they were paid. As a result I what to know: 1- Is all the dill was paid. 2- What is the balance. Do you have any idea how...