Recent content by rsfnoam

Hi thanx for the reply well you helped me alot but guess what.. I found out that what i forgot to do is to acually insert the values into the public variable..I declared a public module named:pubvar. But entered the 'explicit option" .. so what Ihad to do is : pubvar.fd = clng(myfd)...and...

Hi there Whatsup friends? long long time since the last time i was here..:) well I have a problem that occured to be a big one for me but probably a "nothing" for you ..what can i do. I have two fields on my MAIN form called fd and td.. I want to use them as global variables so that when the...

Hi there I got a bugging problem.. I need to update a table from 2 different sources at the same time. I have on the table(TESTSRESULTS) 3 fields: recnum,testcod,testap recnum(numeric data) is on the form and holds the order. testcod and testap are supposed to come from table TESTS. What i mean...

Hi there Sorry for not writing for couple of weeks..a lot of work ... Well sometimes simple things become complicated problems. This is the problem i got.. I am working on a db which manages callers to the clinic.. I work with one table (callerstables)and 4...

Hi john Many many Thanx Noam

Hi John I looked at that site and found out that I got nearly the same structure diagrams ideas(i.e. ideas not same tables and same tables (-:) As for that. How do I use the docmd.open form with the open args What I know (I know that what i don't know is alot more ha) is that the openargs is...

Wow.. Thanx That is very vey helpfull Noam

Hi john Gee thanx for that quick respose.. Why do you say that it is not normalized.? To think it up is always a helpful advice I'll be happy to.. Well I need to keep 10-30 in parallel i.e. I need a column for each result in the same data record .everyone of those columns is a combo which after...

Hi everyone First of all I would like to thank RODMC for the advice about that bugging problem with displaying data in datasheet view..thanks very much again. I got a problem with passing parameters to forms. The situation is:I have 9 or ten forms with two data fields changing all the time. The...

Hi rodmc This is what i did. but I guess I have a little different problem..I have on the record data only the numeric value (to save amunt of storage I suppose that even you will not save text values) and I use the schisans just as a text box for displaying the information for the users.. For...

ouch.. Now I understand..that text box schisans is not really bound to a field.. So I have actually to create a query referring to the tozaot table. i.e. in the record source refer to that query column 2(result) is that correct ? hmm. I thought that was simple and it is (-: many Thanx Noam

hi rodmc I've done exacly what you suggested..with many thanx and on the after update of the combo it does it. but the string(the text box to fill: schisans ) that is supposed to get the information from the column(2) (i.e. result in the tozaot table ) is showing on every row ..thaT what's...

Hi rodmc probably not or maybe or I am confused if you could help with that What bothers me is that in another application I did the same and there it worked. Thanx alot in advance Noam

hi I did that. yes I want the string to appear in the text box..but only for the record(line) i am working on. what it does at the moment is displaying the string for all the records after I select a value in the combo.

Hi again As usual this forum is just great and again i thank all in advance. I have another problem with my combos.I am working on the spreadsheet view. The combo: quest2res1list the lookup table:tozaot the columns displaying in the combo:kod(long),result(string) the text box to fill: schisans...