Search results

Hi Takstein, i do it using dmax function Text294.Value = DMax("SN", "tbl_main_data") + 1 it works fine.

Hi Sexy, did you try to delete them by a button? or do you have vb code? ASARAK

i try to create blank record and it works with no problem at all. Now i have plenty of time to do the normalization.... thank you all

Thanks Neil, i was trying to normilize the 6 tables ... and keep trying..

I mean, if it is logical to create with VBA code in order to initiate values in all fields in these 6 tables while i insert the main key (SN). Is that clear??? or else i have to go for English lessons!!!!! thanks you all

thanks Colin....

Hi guys, i want to export in text, records from multiple tables using joins, but i could not export this using a temporary table or query because the fields are more than 256, is there any ideas :confused: how to export them? regards ASARAK

hi again guys and many thanks for your time. first, about the date, this short date in some fields is what the clinet wants. second, the main problem of multiple fields which have the same data to capture is that it could be someone to have more than one medication data, that is also to...

and the mdb is.... ok Colin thanks all of you also you need the mousehook.dll in the same directory with the mdb i use it to disable the mousewheel record rotation. thanks

Colin you are absolutely right. i am at the same side, and i am going to have a discussion to fix some things. anyway... do you mind to mail me in asarak@bioiatriki.gr regards ASARAK

possible yes, but i have at this time my client want to run it asap. thanks a lot, if i send you the db could you please checkit??? thanks

thanks Paul i think this is it thanks a lot

what kind of queries?? only select or also insert update delete???

did you have the data from the first table in the main form and from the second table in the subform? if you do that, you may not have a valid relation in the connection between main form record from table 1 and sub form record(s) on table 2 check this first

Hi guys, i have a little problem with a form. while i put the last value in a tabbed form and press enter or tab, the data disappear, just as i press clear!!!! The data are ok, because by pressing next and before record navigator buttons appears... I am trying to play with lost focus on the...

the whole db has 285 fields includes the "sn" also i have 29 other tables that i use them in combo boxes... which works ine. the main has 81 fields the habits has 42 the med hist has 45 the medication has 48 the osteo has 50 the woman has 19.

the fields are more than 256 fields. So .... :-(

did you try to put into the second form in the candidates name as default value the name that you can take from the first form?? p.e. forms!frm_candidate_name!text ???

in any of the cases the same problems... any assist???

another try in a previous version that i have also no relationships but tbl_main_data has the "sn" field as indexed with no duplicates tbl_habits_data has the "sn" field no indexed tbl_medical_history_data has the "sn" field no indexed tbl_medication_data has the "sn" field as indexed...