Search results

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...

Hi paul and others Just as I thought.. did work but now i got a problem with a user. :-) (darn users I got) well the problem is that the user does not like the button that Icreated to choose between the two sorts..she wants to change the sort from within the combo by pressing a key or somt'n.:-(...

Hi paul and everyone Thanx alot for the advice. Hope it will work..I'll see on Sunday next week when the users will re-use that application Noam

Hello there i have a field that is a combo box.I need to display the list in two different ways depending on the user's choice(that is how the user is searching along the list). the combo's name: mailinglist the combo box(mailinglist) is based on a table: tbl_mailinglist It displays two columns...

Thanx very much for the reply.That helpedI just put in the if that setfocus for the page and it worked.Again thanx alot

Hi thereI've got a little problem in changing a tab control enabled parameteri have a tab control named tabctl0within that tab I have 3 pages: page1,page2,page3I want to depend the enabled parameter of each page on a field in the main form.the field in the main form = dovisitif me!dovisit = 1...